changed query, but it didn't add to record source of report

[Guest]

I am trying to figure out the best way to create this report. Since there is
a lot of conditional data I created a query that solved most of my answers
then I just add the field to my report created based on the query. But I
then added a field to the query later and it does not show up in the record
source to add as existing field. So must I "completely" create the query
before I make the report for the first time or is there a way to get to the
fields of a query? thanks

 

[Douglas J. Steele]

Are you sure that the query is being used as the RecordSource for the
report? Take a look at the report's RecordSource property: if it's not the
query you expected it to be using, change it.

 

[Guest]

Ok, when I add my query to the record source it says that I have an invalid
record source. My query has a many to one relationship with one of the
tables and this table is then related to another table as a one to many
relationship on the same key. So maybe there is a problem with my
relationships, but I am not sure how to work through it. Thanks for the
quick response.

 

[Douglas J. Steele]

That doesn't make sense. Assuming it's a valid Select query (as opposed to
an Action query: Update, Insert Into, Delete), there should be nothing that
prevents you setting the RecordSource for the report to the query. You may
not be able to use it effectively if there are field names missing from
whatever field names have been used as ControlSource properties for various
controls, but you should be still able to set it.

 

[Guest]

Ok, it seems that my query worked without having all of the tables needed in
report, so once I added all tables to the query then in the record source
added all the fields that would be used in the report to the field list from
the tables, it seems to work. Not sure I am convoluting things though.