Comparing 2 tables

K

Keith

I have a database which has a list of products and prices in one table. I
have another table which is updated each day from a file of new sales. If a
new product is sold which is not in my pricing table then I don't report
correctly. What I need is a query which will tell me which items are in the
MASTER table but are NOT in the PRICING table. I don't need a full list of
contents, just a short list of NEW items.

I know I could do an append to the pricing table of the new items in the
master table, but I want to know which the items are first.

Any help appreciated?

Thanks
 
M

Marshall Barton

Keith said:
I have a database which has a list of products and prices in one table. I
have another table which is updated each day from a file of new sales. If a
new product is sold which is not in my pricing table then I don't report
correctly. What I need is a query which will tell me which items are in the
MASTER table but are NOT in the PRICING table. I don't need a full list of
contents, just a short list of NEW items.

I know I could do an append to the pricing table of the new items in the
master table, but I want to know which the items are first.
Click to expand...


If you create a new query, there is a Find Unmatched query
wizard that will generate that kind of query for you.
 
D

Duane Hookom

I would also like to gently remind you to post questions to only one news
group.

--
Duane Hookom
MS Access MVP
--

Keith said:
Of course, It is a long time since I used it, thanks very much for
reminding me....
Click to expand...
 
K

Keith

I feel like a naughty school boy now, getting told off for this. I didn't
know there was a problem with doing this and just thought it would get a
higher chance of someone reading it and solving my problem. What is the
alternative and how do I do it?




Duane Hookom said:
I would also like to gently remind you to post questions to only one news
group.
Click to expand...
 
J

John Vinson

I feel like a naughty school boy now, getting told off for this. I didn't
know there was a problem with doing this and just thought it would get a
higher chance of someone reading it and solving my problem. What is the
alternative and how do I do it?
Click to expand...

Crosspost, rather than multiposting. That is, if your newsreader
software has a Newsgroups line, put two or three (that's PLENTY)
newsgroups on that line. This will post the same message to all three
newsgroups, but there's really only one message; replies will show up
in all the newsgroups. This is helpful for those who answer, since we
can see at a glance that a question has already been answered rather
than answering it in m.p.access and then finding an extensive thread
on the same question in m.p.a.queries when we get down the list.

Note that most of us who volunteer here routinely scan several
newsgroups (I look at eight currently). It might up your odds of
getting an answer slightly, but your best bet is picking an
appropriate newsgroup (or, if it's unclear which that might be, maybe
two) and posting there.

John W. Vinson[MVP]
 
Top