Use Pivot table, crosstab or build my own?

  • Thread starter Thread starter Pendragon
  • Start date Start date
P

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
 
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.
 
Okay, thanks! Kinda thought I'd have to go that route.

Duane Hookom said:
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


Pendragon said:
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
Click to expand...
Click to expand...
 
Back
Top