i have a large table with no primary key. It has a unique identifier (client_number) but that identifier has multiple entries which are stored with various unit_number information, etc. The information is like this because it is imported to the Access database. Creating tables for data normalization each time we import the data isn't an option.
I have been requested to create some finniky reports, but the only way to get the information to look the way i want it is to create queries which do sorting and tallying (hence the crosstabs). But the reports wizard won't let me use more than one query to create a report.
Can i create an SQL statement to do what i want?
Where would i put that statement? In the VB code behind the report, or in the control source of the properties of the report?
there are actually two reports i am having problems with.
1.) i need a report which shows the top 100 unit holders for each unit in my table (MAIN_STORAGE_TABLE). I tried to create a query using Top Values in the properties section of the query in design mode, but that only displays the top 100 unit holders period. It doesn't give me the top 100 for each unit in the table.
2.) i need a report which grabs information from multiple crosstab queries - Crosstab_Main_For, Crosstab_Main_Against, Crosstab_Main_Storage.
hopefully this question is clear.
Thankyou very much
I have been requested to create some finniky reports, but the only way to get the information to look the way i want it is to create queries which do sorting and tallying (hence the crosstabs). But the reports wizard won't let me use more than one query to create a report.
Can i create an SQL statement to do what i want?
Where would i put that statement? In the VB code behind the report, or in the control source of the properties of the report?
there are actually two reports i am having problems with.
1.) i need a report which shows the top 100 unit holders for each unit in my table (MAIN_STORAGE_TABLE). I tried to create a query using Top Values in the properties section of the query in design mode, but that only displays the top 100 unit holders period. It doesn't give me the top 100 for each unit in the table.
2.) i need a report which grabs information from multiple crosstab queries - Crosstab_Main_For, Crosstab_Main_Against, Crosstab_Main_Storage.
hopefully this question is clear.
Thankyou very much
