shafh and 1starr,
Is it possible for you to attach a small DB with only the necessary tables and queries and some test data so that we can have a look at your queries?
You can change any sensitive data before attaching.
If possible, attached the DB in Access 97 format (In Access 2000, choose save as a prior version from the Tools menu) as many of us here are still using Access 97.
To meet the size limit here, you may need to compact your DB (also from the Tools menu) before zipping and attaching it.
Is it possible for you to attach a small DB with only the necessary tables and queries and some test data so that we can have a look at your queries?
You can change any sensitive data before attaching.
If possible, attached the DB in Access 97 format (In Access 2000, choose save as a prior version from the Tools menu) as many of us here are still using Access 97.
To meet the size limit here, you may need to compact your DB (also from the Tools menu) before zipping and attaching it.
