Background: Visual Basic Front-end with Access Database.
I need to create a crosstab table that looks like the following:
Field Resp1 Resp2 Resp3 Total
A 15 30 5 50
30% 60% 10% 100%
B 10 20 20 50
20% 40% 40% 100%
C 5 3 2 10
50% 30% 20% 100%
This is probably worth more points than I have assigned, but as a new member I don't have any more than this to offer. I'm looking for the SQL statement or series of statements that I can execute from VB. Thank you.
Sometimes MS breaks things just for fun...
In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset.
Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…