DB from DB extract

[rforster]

Good morning everyone,

I get datasets weekly for company wide positions. They are used to look up details about a particular employee, or if a position is vacant, a position #. Actually everything revolves around the Position #. What I want to do is import these datasets into Access every week. Roughly 15,000 records with 30+ fields. I did an import of one and the DB was 33MB. Rounding up to be conservative, a year's worth of data is roughly 2GB which is the capacity of Access. This is OK, I will figure out a way to delete and not import fields that are not used. What other issues should I be concerned with up front?

What I want to accomplish is to be able to compare from week to week, or from one date to another, is a comparison of fields. Like, if Pos# was there last week but not this week, and conversely, not there last week but added this week. Or, Employee name changed from Smith to Vacant. Pay changes, and so on. I know how to compare columns in Excel, but how do I query this week to last week and return a list of Position#s where the name is different.

Appreciate any feedback. Thanks!

 

[ranman256]

make 2 queries. 1 to this week, 1 for last week. These would run off a form, the form has text box , txtThisWeek.
select this week in the box.
the after update event would fill in txtLastWeek, via txtLastWeek = dateadd("d",-7,txtThisWeek)

query 1 , qsThisWeek, would pull data , select * from table where [week] = forms!frmMain!txtThisWeek
query 2 , qsLastWeek, would pull data , select * from table where [week] = forms!frmMain!txtLastWeek
query 3, would put both Q1 & Q2 in and compare the differences, via a new virutal field : qsThisWeek.[emp] = qsLAstWeek.[emp]

so you can find the changes.
This is not elementary stuff. Study up.

 

[rforster]

Thanks for replying. Agree, not beginner stuff.
I'm going to import a couple of data sets and build the two queries using specific dates. Then i'll figure out the third
Appreciate the help.