roofus: (Default)
Me and my friend are stranded in the uni's lab, trying to find a request command in ACCESS 2007 for filtering a query.

Two tables. One named Orders, the other named DeliveryPlan. Both have a field named OrderNb. The 1st table has 369 different numbers, the other one has 319. 50 orders don't have deliveries on them.

We have to write a query that will list only the 50 order numbers that are not in the second table.

HEELP!! Anyone out there knows the syntax for the condition or test?? We've been at it for 5 hours, no kidding!! Help!!

***** UPDATE: problem finally solved! Thanks for your help!

April 2017

S M T W T F S
      1
2345678
9101112131415
16171819202122
23242526272829
30      

Syndicate

RSS Atom

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Jul. 21st, 2017 10:54 pm
Powered by Dreamwidth Studios