Cannot open the report

  • Thread starter Thread starter SAS user
  • Start date Start date
S

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
 
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.
 
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
Click to expand...

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.
 
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.
Click to expand...

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.
 
Back
Top