If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Dynamtic Report columns Based on Crosstab Query
I have a simple crosstab query where the rows are an emplyee type and the
columns are job locations. I have tied this to a report successfully however the report columns are not dynamic and do not update to changes in the data unless the report is manually modified. I've seen reference to a crosstab.mdb recommended or write by Duane Hookom as a good examples to resolve this type of problem. All of the web links I followed to download this file were broken. I'm looking for a simple example to resolve this issue. Other web source I have reviewed for coding example were not of much help. -- Mark H. Trainor |
#2
|
|||
|
|||
Dynamtic Report columns Based on Crosstab Query
http://www.rogersaccesslibrary.com/f...sts.asp?TID=11
-- Duane Hookom Microsoft Access MVP "Mark" wrote: I have a simple crosstab query where the rows are an emplyee type and the columns are job locations. I have tied this to a report successfully however the report columns are not dynamic and do not update to changes in the data unless the report is manually modified. I've seen reference to a crosstab.mdb recommended or write by Duane Hookom as a good examples to resolve this type of problem. All of the web links I followed to download this file were broken. I'm looking for a simple example to resolve this issue. Other web source I have reviewed for coding example were not of much help. -- Mark H. Trainor |
#3
|
|||
|
|||
Dynamtic Report columns Based on Crosstab Query
Thanks Duane,
Lets see if I can figure this out. -- Mark H. Trainor "Duane Hookom" wrote: http://www.rogersaccesslibrary.com/f...sts.asp?TID=11 -- Duane Hookom Microsoft Access MVP "Mark" wrote: I have a simple crosstab query where the rows are an emplyee type and the columns are job locations. I have tied this to a report successfully however the report columns are not dynamic and do not update to changes in the data unless the report is manually modified. I've seen reference to a crosstab.mdb recommended or write by Duane Hookom as a good examples to resolve this type of problem. All of the web links I followed to download this file were broken. I'm looking for a simple example to resolve this issue. Other web source I have reviewed for coding example were not of much help. -- Mark H. Trainor |
Thread Tools | |
Display Modes | |
|
|