Search results

Doesnt work I have selected a new form in design view. Selected the Chart option and when i choose the fields I want for the chart, a pop up appears saying, 'Please select up to 6 fields for this chart'. How can i overcome this? I have got Access 2000, which doesnt have the PivotChart...

Nice one Meboz, it worked a treat! :)

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...