vo2max_999
New Member
- Joined
- Sep 11, 2006
- Messages
- 2
Hello forumers
I need yr. help on the following. I will try and be as concise as possible.
I have 2 tables in access, a daily and a monthly table
The daily file has the following structure.
day ---> dd-mmm-yy
qty ---> number
01-Mar-06 456
02-Mar-06 999
03-Mar-06 123
etc...
The second table contains aggregated data for the month which is not contained within the daily file
month ---> mmm-yy
exceptions ---> number
Mar-06 123
Questions is how can I format the date/sum/join/group the tables, that the information would display as follows (based on limited data above)
Mar-06 1578 123
Thank you in advance.
vo2max_999
I need yr. help on the following. I will try and be as concise as possible.
I have 2 tables in access, a daily and a monthly table
The daily file has the following structure.
day ---> dd-mmm-yy
qty ---> number
01-Mar-06 456
02-Mar-06 999
03-Mar-06 123
etc...
The second table contains aggregated data for the month which is not contained within the daily file
month ---> mmm-yy
exceptions ---> number
Mar-06 123
Questions is how can I format the date/sum/join/group the tables, that the information would display as follows (based on limited data above)
Mar-06 1578 123
Thank you in advance.
vo2max_999