Search results

I have the results from a query that need to be presented on a chart, below are the fields: Name, Calls, Idle, Available, Lunch, Break, Emails, Meetings, Mangers Discretion I want to create a Stacked Column with the Names on the x-axis and the other fields representing the stacks on the...

I have a query of records that have to be grouped by week, i cant figure out how to display the week commencing date instead of the week of the year. The date I want to show is of the monday of the week. Field name im using is 'Date' Can anyone suggest code to correct this problem?

I am recording and manipulating data on the time workers spend doing various tasks. All the data is to be stored and presented in the hours:minutes:seconds format. In one case I need to store the total task time over a month, this value exceeds 24hrs so it can't be stored as a date/time...

I have made a query in design view on Access 2000, I have made the following field which groups by the week. However it only works because i set it to format the date as "ww, mmm yy". Field: Week of Year: format([Date], "ww", "mmm yy") Total: Group by Output is Week of Year 32, Aug 04 33, Aug...

[/SIZE][/FONT]Im trying to make a simple database where i can record the times call centre agents spend in certain codes. I want to be able to view the information on a form where i can select the agent from a drop down list and pick how to view the data (average times daily, weekly or...