Query (Add,Subtract)

[ss908]

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

[Steve]

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

[StopThisAdvertising]

"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

[Bob Quintal]

"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