Strrange report => query builder problem

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

This is REALLY weird . . .

I am working on a report. I am using the query builder to
create my data. I am trying to take a table
of "transactions" that include dates and make a summary
report (by month).

I am doing all of the work to sum in the report, I have a
couple fields I am using to select and group the fields I
want.

I am trying to add a field, and when I do it in the query
builder IT WORKS FINE. I go to the data sheet view, and
IT WORKS FINE, everything works exactly as I would like it
to. So I close the query builder (saving the change),
Close the report, RUN the report, and I get prompted for
the value I just created (It is an expression field on the
report). I curiously reopen the query in the QUERY-
builder and Viola! The expression field I've added is not
there!! It is as if I never saved the change! I know that
I did, I am no Access expert but have been working with
Access several years (self taught so I may be missing
something) but this seems VERY simple!

Any insight??

Doug
 
I have seen this behavior before. You must remember to also save the report.
You updated the SQL Statement in your Record Source property but didn't save
(you weren't prompted) the report definition.
 
Back
Top