By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,089 Members | 2,226 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,089 IT Pros & Developers. It's quick & easy.

Query (Add,Subtract)

P: n/a
I have records in a source table. Each is tagged either Base or Add or Delete
(from Base)
How do I create another table which shows Base records plus Add records and
deletes Base records which are tagged Delete.
Appreciate it.
Thanks

Jun 3 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Create a query of your source table. In your tag field, set the criteria as
"Base". Under that in the row that says OR type in "Add". When you run the
query you will get all the Base and Add records. Go back to query design.
Click on the Query Type button in the menu at the top of the screen. Change
the query to a Make Table query and follow the directions. You will get a
new table containing all the Base and Add records.

There is nothing saying the user wanted to see "All" as a choice. Rather,
the user wanted a way to see all the values. Did you learn to read from
the same place you learned to put calculated values in a table?
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com

"ss908" <u34757@uwewrote in message news:73276af1b77e5@uwe...
>I have records in a source table. Each is tagged either Base or Add or
Delete
(from Base)
How do I create another table which shows Base records plus Add records
and
deletes Base records which are tagged Delete.
Appreciate it.
Thanks

Jun 3 '07 #2

P: n/a

"Steve" <so***@private.emailaddressschreef in bericht news:9%*******************@newsread1.news.pas.eart hlink.net...
There is nothing saying the user wanted to see "All" as a choice. Rather,
>the user wanted a way to see all the values. Did you learn to read from
the same place you learned to put calculated values in a table?
Obviously your are mixing things from other posts here Steve ??
Please read your nonsense before you hit 'Send' .

Arno R
Jun 3 '07 #3

P: n/a
"StopThisAdvertising" <StopThisAdvertising@DataShitwrote in
news:46***********************@text.nova.planet.nl :
>
"Steve" <so***@private.emailaddressschreef in bericht
news:9%*******************@newsread1.news.pas.eart hlink.net...
>There is nothing saying the user wanted to see "All" as a
choice.
Rather,
>>the user wanted a way to see all the values. Did you learn
to read
from
>>the same place you learned to put calculated values in a
table?

Obviously your are mixing things from other posts here Steve
?? Please read your nonsense before you hit 'Send' .

Arno R
Not only that, he accused me of violating normalization rules.
Steve's solution certainly looks like it violates one of the
cardinal rules of normalization...

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Jun 6 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.