Any Ideas!?! ;o)

[Isaac Sanchez]

Let me give you the run down:
I have a delivery business for direct selling company.
I deliver each week to the people who sell the product.
I am responsible to deliver to 550 resellers, I have a table called Master
List.
that contains a map and contact info.
Each week I receive a manifest telling who will be receiving an order, I
take this
list and I input it as a table called Week-44.
To get the info in the Master List for only those in Week-44 I run a query
so that
I only have the data of the resellers I need for that week.

My question is can I set up a template or some code or a macro that will
help
to automate setting up the query?
Does anyone have a better idea of how to do a query other than using the
wizard?

I tried just coping an old query and looking for the option to switch out
the
weekly table but I could not find how to do it that way so just deleted it.
I figured it was faster to start from scratch with the query wizard.

Thanks In Advance,
Isaac

 

[Guest]

I don't think you should be creating a new table each week. Use one table,
maybe called tblMainfest. In that table, have a column called WeekNumber. So
if you are in week 44, your records for that week will have the number 44 in
the week column. Then, have your query prompt you for a week number.

Barry

 

[Dos Equis]

Not positive, but think it's also possible for you to input the current
date and Access will convert that to the correct week number, then your
query can pull up the data by either if you need to research old data.

Byron