cross table help

mitch97144

Registered User.
Local time
Today, 13:17
Joined
Sep 8, 2004
Messages
15
I have created a query to display played records assigned to each player. From this i have then created a cross-table query to display ,by date across the page , the records for each player.(example attached).

1-Is there any way i can allow the user to select the date header by a range of dates. At present the query itself displays a 'date' header for each record that contains a date. By doing this i could then create a report that will only display the dates where specified.

2-If possible can i set the 'P' values to be displayed in a certain colour if another field is set to a specific value.

i.e
League = display in green
League Cup in Blue
 

Attachments

Users who are viewing this thread

Back
Top Bottom