Adding or subtracting fields from query for a graph

  • Thread starter Thread starter Susy
  • Start date Start date
S

Susy

I have created a crosstab query with dates as the rows,
well names as the columns, and water levels as the data
(averaged). There are approximately 50 wells.

I then created an xy scatter graph (report) from this
query. It works but I'd like to be able view only a few
wells at a time in the graph. I usually use a control on a
dialog box when I open the graph report to specify date
range and well name, but the query won't let me call for
these controls ("the Microsoft Jet Engine doesn't
recognize these fields" - something like that).

Is there a way to specify specific values in my column
headings in the crosstab query?

For example, if the following were the headings for my
crosstab query (i.e., [wellname]):

10P 10P Deep 10P Shallow 12PA 12PB 12PC
1/1/01 10 11.4 12.3 6 7 etc.
2/1/01
3/1/01

can I just display 10P Deep and 10P Shallow in my graph?

Thank you.
 
You must explicitly define your parameter datatypes. Select Query|Parameters
and enter your criteria and datatypes.
 
Back
Top