G
Guest
I use the following format to get the totals of a field by week.
Format$([TransactionSub1b].[Date],'yyyy ww') This allows me to sum all
records within a week...and shows the date as '2004 45'... etc. After
getting the totals, I'd like to be able to show the week as an actual date in
a report (such as the first date of week 45). Is there some way to do this?
Or does anyone know of a calendar that I could put into a table to connect to
this query that would know that 2004 45 = 06/06/04? (or whatever 2004 45
really does =)
Format$([TransactionSub1b].[Date],'yyyy ww') This allows me to sum all
records within a week...and shows the date as '2004 45'... etc. After
getting the totals, I'd like to be able to show the week as an actual date in
a report (such as the first date of week 45). Is there some way to do this?
Or does anyone know of a calendar that I could put into a table to connect to
this query that would know that 2004 45 = 06/06/04? (or whatever 2004 45
really does =)