Need to do a query that shows the goods that have not been sent in a database. Have got the form set up with Delivery Date and Order Date - Order Date being the date that the order was made and delivery day is 7 from the order date. need the code to put in the query any ideas???? Really important!!!!!!!!!!!!!
Query
- Thread starter cath240
- Start date
Fuga
Registered User.
- Local time
- Today, 01:45
- Joined
- Feb 28, 2002
- Messages
- 566
How are you thinking of determining if they are sent or not?
Are you going to put a "sent" field as a yes/no field in the goods table or are you going to have a "sent" table?
If you have a field, you put 0 (=unchecked) as a criteria for that field.
If you have a table, you can use a missmatch query.
Fuga.
Are you going to put a "sent" field as a yes/no field in the goods table or are you going to have a "sent" table?
If you have a field, you put 0 (=unchecked) as a criteria for that field.
If you have a table, you can use a missmatch query.
Fuga.
