crosstab questions
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Date: Mon, 20 Sep 2004 20:59:04 GMT
Ok...I have setup a crosstab query. That part was fairly easy using the
wizard. Not the hard part is how to output the data!!!
A report's controls need to be bound to fields. However, with the crosstab,
the field names change when the groupings (column headings) change. How do
you tackle this?
Relevant Pages
- Re: Importing Text File that is vertically oriented
... > I have a MS access database into which I need to import a text ... I would ideally like to setup ... either write a crosstab query to pivot the data horizontally and ... visual basic code that manipulates the data and sets the value ...
(comp.databases.ms-access) - RE: Monthly Vendor Report
... I "think" Duanes' link will help after you make the crosstab query and ... that can be done with the wizard as your first step to help you. ... SQL looks something like this ... will list one vendor with multiple totals (monthly) ...
(microsoft.public.access.tablesdbdesign) - Re: DCount problem
... Basically your form would have seven controls in the detail section and the controls would be bound to the fields returned by the Crosstab query - ... As far as the Grand Total goes, you can either use a sub-form in the footer of the form bound to a variation of the crosstab query. ... Roughly the crosstab for grand totals would look like this ... Say, if I want to display VaccineA V1 in Me!bxVaccAV1, how can I do it? ...
(microsoft.public.access.modulesdaovba) - Re: DCount problem
... Basically your form would have seven controls in the detail section and the ... the form bound to a variation of the crosstab query. ... Roughly the crosstab for grand totals would look like this (if you decide to ... display VaccineA V1 in Me!bxVaccAV1, ...
(microsoft.public.access.modulesdaovba) - Re: Field not in Field List: What to do?
... You can use the ColumnHeadings property of the crosstab query to specify the ... of Fieldnames currently in the result set and then 2) change the ... ControlSource of Form/Report controls to the current Fieldnames as the ... "Jerry Crosby" wrote in message ...
(microsoft.public.access.forms) |
|
