creating queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, i'm very new to Access so I am hoping someone might be able to help me.

From a master table imported from excel, I have to create 2 separate queries
comparing data from a current report and the prior months report. One query
would be to compare any current changes from Prior report and second query
would be to pull all new records since prior report. The end result would be
3 tables (one main, one current with changes and one with new records).
I did try the "New" then "Unmatched query wizard" but i did something wrong
because my query came up blank. thanks for any help!
 
Hi, i'm very new to Access so I am hoping someone might be able to help me.

From a master table imported from excel, I have to create 2 separate queries
comparing data from a current report and the prior months report. One query
would be to compare any current changes from Prior report and second query
would be to pull all new records since prior report. The end result would be
3 tables (one main, one current with changes and one with new records).
I did try the "New" then "Unmatched query wizard" but i did something wrong
because my query came up blank. thanks for any help!
Click to expand...

Since you didn't post the queries, the table structure, or anything else that
would help someone diagnose the problem... all I can say is "correct the error
in the query".

One suggestion would be to NOT attempt to store these changes in any table.
Storing derived data such as this in your table accomplishes three things: it
wastes disk space; it wastes time (almost any calculation will be MUCH faster
than a disk fetch); and most importantly, it risks data corruption. If one of
the underlying fields is subsequently edited, you will have data in your table
WHICH IS WRONG, and no automatic way to detect that fact.

Instead, get a working set of queries to display the changes and base your
report on those queries; there's no good reason to store that data in any
table.

John W. Vinson [MVP]
 
Back
Top