Re: Any Ideas!?! ;o)

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

Barry Gilbert wrote:
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

"Isaac Sanchez" wrote:

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




.

Relevant Pages

  • Any Ideas!?! ;o)
    ... I am responsible to deliver to 550 resellers, I have a table called Master ... To get the info in the Master List for only those in Week-44 I run a query ... I figured it was faster to start from scratch with the query wizard. ...
    (microsoft.public.access.queries)
  • Re: Subject: modifying SQL criteria in a search for duplicates
    ... > I'm trying to build a query that displays all records that have matching ... > strings in the first four characters of two different fields: AgentName ... > To produce the exact matches in those two fields, the query wizard inserts ...
    (microsoft.public.access.queries)
  • Re: How to do Edit Query from Import External Data.
    ... set filter conditions, and sorting order. ... Or, in query wizard, you can enter filter conditions and set sorting orders ...
    (microsoft.public.excel.misc)
  • Query Wizard Error
    ... query using the query wizard. ... be edited by the Query Wizard". ... and each time I go back to edit it ... use this report! ...
    (microsoft.public.excel.crashesgpfs)
  • Re: Combining several tables in MS Access 2007
    ... Create query in design view. ... Now you are in the Query Wizard, however we are going to write SQL to ... INSERT INTO TABLE1 ... positions than is usually needed) and numerical columns (Excel stores ...
    (comp.databases.ms-access)