need to calculate weekend date

[Randy]

I track my daily work in an access data base. very simple. each day I enter the date, activity, the person I was helping, and a value ie. 1.5 hours etc.

I might work on the same project many times that week, i.e. 1.5 hours on Monday, .5 hours on Tuesday, and 1.0 on thursday.

my new boss wants a weekly summary. so I need to create a query that would show the total for this activity 3.0 hours for that week. So basically at the end of the year, I would have a query with activities by row, weeks across the top i.e. 52 columns, and the total of the various activities summed up for each week.

I looked at all the standard date functions, and did not find a weekend type functions.

 

[mhartman]

Hello:

I believe what you want to do is set up a "CrossTab" query. That will allow you get the results your asking about. The wizard can guide you through the process. Also, Online help has a good example.
Regards
Mark

 

[Randy]

yes I am using a crosstabl query

yes I am already using a crosstab query. This issue is, the columns has about 245 days, i.e. one column for each work day in the year. I need to take a whole week of data and summarize for each week, so that I only have 52 columns, i.e. one column for each of the 52 weeks in the year, with all 5 working days of that week summarized.

thanks for the response, but the crosstab wizard, and so far, access help, has not provided any real solution.

 

[Rich]

Just GroupBy Week and Sum the hours