Report asks for criteria and I don't know why.

[UniqueTII]

I am trying to change an old report that I didn't design, and every time I open it, it asks for criteria. There are two copies of the report, one asking for a student's SS#, and the other asking for the starting and ending dates of his/her employment. The problem is that I don't know why they are asking for the criteria. I checked the code for the buttons that open the reports and there's nothing there, and I checked the fields included in the report and there aren't any extras that it would need to ask for. Where else in the report could it need the info?

 

[David R]

Are these fields that the report uses? For instance, to run a report on a Student, you'd need their SS#. To run a time report, you might need the user to input a start and end time.

If that's not the case...
Check the query the report was based on. Chances are there's somefield in there that looks like:
Expr1: [sometable that doesn't exist].[somefield in a nonexistenttable]*3

See if you can find where that field/table went to and how to update it in the query.

[This message has been edited by David R (edited 04-25-2002).]

 

[UniqueTII]

With the SS# one, it's necessary in the report, but the field in the report is [Student Info SSN] while the prompt says: "Enter SS#" Why is it different like that?

I checked the query for fields that don't exits, and I don't see anything. The prompts for the second report say:
"Enter a start date:" and
"Enter an end date:"
How can I use the dates entered within the report?

EDIT: I think I was looking at the wrong query.

[This message has been edited by UniqueTII (edited 04-25-2002).]

 

[UniqueTII]

Yep, I was looking at the wrong ones. I think I should have this project all wrapped up tomorrow...and I don't need it done until next Wednesday. Thanks for getting me on the right track.