Cannot open the report

[SAS user]

I have three different databases created in Access ’97. I merged these
databases into one. I basically copied the data into the respective tables
and kept everything else same. But, now some of the reports are not working.
I checked the relationship and it is unchanged. I will need to keep the
database in Access ’97, because field people use that version. Any help will
be greatly appreciated.

Thanks

 

[Daniel Pineault]

Does not work? Do you get an error? Please elaborate a bit more.

 

[SAS user]

When I hit to view the report, enter parameter value box pops up and asking
me to enter the information for the field names which basically I want to
view in the report. A query is the source of the field names and the query
works perfectly fine. Thanks.

 

[John W. Vinson]

I have three different databases created in Access ’97. I merged these
databases into one. I basically copied the data into the respective tables
and kept everything else same. But, now some of the reports are not working.
I checked the relationship and it is unchanged. I will need to keep the
database in Access ’97, because field people use that version. Any help will
be greatly appreciated.

Thanks

Correct the errors in your tables, your queries, and/or your reports.

If you would like help doing so please post enough information (e.g. the
nature of the error message or problem, the SQL view of the offending query)
that someone who cannot see your screen might have a chance to help.

 

[John W. Vinson]

When I hit to view the report, enter parameter value box pops up and asking
me to enter the information for the field names which basically I want to
view in the report. A query is the source of the field names and the query
works perfectly fine. Thanks.

Having fieldnames pop up suggests that those field names do not exist in your
table, at any rate not spelled the same way. Perhaps you could open your
report's recordsource query in SQL view and post it here, and indicate what
fieldnames you're getting prompts for.