Use Pivot table, crosstab or build my own?

[Pendragon]

Acc03/WinXP

I have a table with the following fields: T_ID (Tournament ID), F_ID
(Facility ID), CourtName (text, formatted as "CT " & [CourtNumber]),
CourtNumber (Number), UseDate (Short Date), UseYN (Yes/No).

The data will first be filtered by T_ID and F_ID. My end result needs to be
an interactive grid with CourtName and UseDate as row and column headings
(doesn't matter which is which) and the values being the UseYN. The user
will check/uncheck those courts being used for a tournament on a specific day.

My understanding is that pivot tables and crosstab queries summarize data.
I've set up a pivot table as described above; however, I'd rather have
checkboxes instead of the Yes or No which now appears. Also, I need to be
able to edit the Yes/No (check or uncheck).

Is there a way to accomplish this with a pivot table? Some other
method/advice? Otherwise, I'm thinking I will have to programmatically set
up a table.

Suggestions most welcome!

Thanks.

Ross

 

[Duane Hookom]

You can't edit data in a crosstab or pivot. What I have done in the past is
use code with temp tables to gather the data into an un-normalized table,
allow the user to edit it, and then push it back out to the normalized table.

 

[Pendragon]

Okay, thanks! Kinda thought I'd have to go that route.

You can't edit data in a crosstab or pivot. What I have done in the past is
use code with temp tables to gather the data into an un-normalized table,
allow the user to edit it, and then push it back out to the normalized table.

--
Duane Hookom
Microsoft Access MVP

Acc03/WinXP

I have a table with the following fields: T_ID (Tournament ID), F_ID
(Facility ID), CourtName (text, formatted as "CT " & [CourtNumber]),
CourtNumber (Number), UseDate (Short Date), UseYN (Yes/No).

The data will first be filtered by T_ID and F_ID. My end result needs to be
an interactive grid with CourtName and UseDate as row and column headings
(doesn't matter which is which) and the values being the UseYN. The user
will check/uncheck those courts being used for a tournament on a specific day.

My understanding is that pivot tables and crosstab queries summarize data.
I've set up a pivot table as described above; however, I'd rather have
checkboxes instead of the Yes or No which now appears. Also, I need to be
able to edit the Yes/No (check or uncheck).

Is there a way to accomplish this with a pivot table? Some other
method/advice? Otherwise, I'm thinking I will have to programmatically set
up a table.

Suggestions most welcome!

Thanks.

Ross