I'm feeling kind of brain dead right now. I have a query where I want to retrieve all of the records from the table on the left that DOES NOT have a matching record on the right. A little more clarity. The table on the left has orders in it and the table on the right has invoice numbers. The query is part of a DCount function and if there is an order on the left that does not have an invoice number, the count is >0. I then run an Append query. If there is a matching Invoice number, no problem. I'm having brain fades on if there isn't a record in the table on the right. Drinking is next.
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.