Results 1 to 2 of 2
2003-12-17, 14:16 #1
- Join Date
- Dec 2003
- Thanked 0 Times in 0 Posts
Table data to conditional grid data (2000 professional)
Hi <img src=/S/hello.gif border=0 alt=hello width=25 height=29>
I have a problem that I am sure has a very easy solution. I have rows column data of staff time worked etc but need to turn that into time sheets per person to something like:
Date Weekday Hours Saturday Hours Sunday Hours Night Duty Hours
NEXT PERSON etc
Etc etc - now doing a query and selecting criterion (give me all the Saturday hours etc) is not a problem but the only way I can think about is setting a criteria in each grid cell for the information that I am looking for but I think there must be a much easier way of doing this.
Any thoughts, starting points or indeed complete solutions (if I am that lucky then I will have a Happy Christmas) gratefully recieved.
I am fine with SQL and writing queries (13 years of Unix Informix text SQL and last 6 years of Access query writing) but it is the ease of presentation that I am lacking knowledge in.
Any pointers? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
2003-12-17, 14:36 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: Table data to conditional grid data (2000 professional)
You can probably use a crosstab query for this.
Click New in the Queries tab of the database window, select Crosstab Query Wizard and the table, click OK, then follow the instructions. Post back if it doesn't work out.