records from query not populating report

  • Thread starter Thread starter MES via AccessMonster.com
  • Start date Start date
M

MES via AccessMonster.com

I have a query that pulls records from another query. When I run that query
on its own, the records that I need to see come up okay. However, when
attach that query to a report, then run the report, the query records do not
populate the report. Does anyone know why this might be happening?

Thanks in advance.
 
You have a query that returns rows.

You have a report based on that query.

When you run the report, nothing shows.

If this is accurate, is there a chance the report has a filter applied
(check the report in design mode, under Properties).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I checked the report properties, and there is no filter applied. Might the
issue be something else?



Jeff said:
You have a query that returns rows.

You have a report based on that query.

When you run the report, nothing shows.

If this is accurate, is there a chance the report has a filter applied
(check the report in design mode, under Properties).

Regards

Jeff Boyce
Microsoft Office/Access MVP
I have a query that pulls records from another query. When I run that
query
[quoted text clipped - 4 lines]
Thanks in advance.
 
I tend to work out (or around) a solution, after first trying to identify
cause.

If you create a totally new report based on that query, does IT work?

Or perhaps one of the other newsgroup readers has run across this?

Regards

Jeff Boyce
Microsoft Office/Access MVP

MES via AccessMonster.com said:
I checked the report properties, and there is no filter applied. Might the
issue be something else?



Jeff said:
You have a query that returns rows.

You have a report based on that query.

When you run the report, nothing shows.

If this is accurate, is there a chance the report has a filter applied
(check the report in design mode, under Properties).

Regards

Jeff Boyce
Microsoft Office/Access MVP
I have a query that pulls records from another query. When I run that
query
[quoted text clipped - 4 lines]
Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top