I have a table called items with one field called items and has 20 records in (simple)
put rubbish out
I have a table called work which has 2 fields :
and it looks like this
itemut rubbish out
I want two queries
1. select all items for a specific work number (done) here its 2 records
2. select all items but don't include the ones that have be selected for a specific job i.e the other 18 records can you help?
so if you create the Query in design view right click the Black line and selct propreis and there are 1 of 3 options to pick from the the options
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.