My First DB

[aftabn10]

Hi, I have been using Access for a while now, but never really created a meaningful or a DB that can be used for work purposes.

At present I have a Weekly Report that has around 1000 queues in which I have to add Weekly Volumes so i thought it might be a good idea to try and develop a database just to build my experience as well as learning along the way.

Currently the Weekly Volumes come from 4 different sources and I am confused as to what the best way forward is, so any suggestions would be greatly appreciated as this is something that i would have to do every week.

Thanks in advance.

 

[Trevor G]

Are the source tables all the same layout? or do you know the fields that the come from...

I would look to use append queries to append into a temp table, then run teh append queries to fill the temp table, then query the single source.

Also run a delete query to empty the temp table prior to running the append queries.

You can do this either direct from queries or from VBA.

 

[aftabn10]

TrevorG, thanks for your response. The source tables are all the same layout. Also in regards to using a temp table, must have forgotten to mention it, but the weekly data has to be saved in order to then replicate monthyly and yearly data. Would append queries be the same way forward?

Thanks once again for your help.

 

[Trevor G]

TrevorG, thanks for your response. The source tables are all the same layout. Also in regards to using a temp table, must have forgotten to mention it, but the weekly data has to be saved in order to then replicate monthyly and yearly data. Would append queries be the same way forward?

Thanks once again for your help.

Keep a separate historical database or table, you can append the temp data to it, then delete the data from the temp table once you have run your queries for the weekly query.