Search results for query: *

Thanks again for helping! The table structure is just 2 tables (tblTracking & tblOrigin (which just has the country names). The fields are as followed: tblTracking: ArrivalDate OriginID > tblOrigin: OriginID, Origin Quantity The quantity field refers to number of units & the ArrivalDate...

Thanks - that sounds like what I'm looking for!!! I'm pretty good with Access, but unfortunately my VBA skill level is low. I have used some very basic codes, but am not sure how to write this. If you could possibly write an example or point me in the right direction I'd really appreciate it.

Thanks for the help, but it is not comparing 2 dates. It is choosing a starting & ending date and then summing the quantities (for each location) during this choosen time span and then comparing it to the same time spans in previous years. An example would be: 10/1/05 thru 2/1/06...

No, I just used the 15th as an example. However, if it is only possible to use either the 1st or 15th of the month as cutoff points that will work providing I am able to specify which time periods to include. This could be Dec 1 - March 1, Jan 15 - August 15, etc. With these periods...

Hello ... I'm trying to create a report that compares historical data between user specified dates. A dialog box has worked for making reports based on user defined dates, however I'm having trouble comparing periods (ex. a report comparing Oct. 15 to Jan 15 of this year and all previous...