Access97 Report & SQL select statement - TechRepublic
General discussion
May 1, 2002 at 03:33 PM
cmtaz

Access97 Report & SQL select statement

by cmtaz . Updated 24 years, 2 months ago

I have a report that when it opens it gets the data based on a SQL Statement. I allow the user to set the parameters that are updated to the query each time they call the report via a cmdButton. Here’s the problem, I have 15 row headers with 3 columns of data. Each dataset is based on a different timeframe.

For Example:
Jan ’02 Feb ’02 Mar ’02
Grp A 10 15 20
Grp B 15 20 25
Grp C 20 25 30

I have triedusing labels in the Report Open code but I end up getting the last record although I have the looping to go through each 15 records. Do I need to place 15 labels or am I just missing something in the logic?

Thx for any help you can provide.

CLM

This discussion is locked

All Comments