Unwanted parameter for report

[wvanpup]

Newbie here, both to forum and to Access 2007, so please forgive me if this is somehow inappropriate.

I have a database to track workload. We track, among other things, day in, day due, day out, who it is assigned to, and category of item.

There is a query to track workload by who it is assigned to. The query has parameters that ask for the name of the person and the date range desired. When I run the query I get a table without any problems.

There is a report based on the query. When I run the report, I am prompted for the parameters I want (person and date range) but then I am prompted for two additional fields (clerk who logged in the item and clerk who logged out the item), neither of which are in the query on which the report is based nor in the report itself.

Does anyone have any ideas on what could cause this and how to fix the problem (please let me know if you need any additional information)?

Thanks for any help you can provide.

WVANPUP

 

[spikepl]

Maybe a query is used to filter the report. Check the bits of code that open the report

 

[wvanpup]

Thank you for your response spike. However, I am not sure I understand.

My report is based on query1. When I run query1 as a query it asks for the three parameters built into the query (person, start date of report, end date of report) and provides a table with the results. When I run the report based on query1, I am asked for the same three items (person, start date of report, end date of report) and then asked for the clerk. The clerk is a field in the table, but it is not included in query1 and, to the best of my knowledge, it is not included in the report.

The report was developed using one of the Access report wizards. I would like to do what you suggest and "check the bits of code that open the report" but if it is anything more than looking at the report in design view I do not know how to do that. How do I "check the bits of code" as you suggest?

Again, thanks for your help.

WVANPUP

 

[lcook1974]

Are there any labels or headers on the report that has a reference to a parameter?

 

[MarkK]

Also check the RowSources of lists and combos. Those might rely on fields that existed in a previous version of the form/report...

Row Source: SELECT * FROM tTestData WHERE id=[UnknownValue];

With a list having that rowsource I get prompted for the [UnknownValue].

 

[wvanpup]

Thanks for the replies, lcook and lagbolt.

To clarify, the report that is generated is a workload report for a specific employee for a period of time. The report queries the employee name field, and asks you to input the name of the employee. The report also queries the action date field, and has a "between" criteria which asks you to input the start date of the period covered by the report and the end date of the period covered by the report. There is, I believe, a label that refers to the employee's name. There report lists the action date, but does not otherwise refer to the between dates of the report. When the report is run, after asking for the employee's name and the period covered by the report, the report then asks for the name of the clerk who input the record (this information is kept in one of the fields of the table) and then the customer name (which is kept in another field of the table). Neither of these two fields are mentioned anywhere in the query on which the report is based or in any of the labels or headers of the report.

I don't know if this helps. I still cannot figure out why the report asks for information about fields which are not part of the query or the report.

Again, thanks for your help.

 

[spikepl]

There is not much point in repeating your information that the fields asked for are not part of the query or the report.

There IS apparently a query somewhere that wants to know the answer. Either used as a filter, in the the command that invokes the report, or in the report itself, specified as the filter, or, as lagbolt mentioned, in some list or combobox. So you have to look at
1. The command that invokes the report
2. The filter property of the report
3. Record source of any ListBox or ComboBox shown in the report

 

[wvanpup]

Thank you Spike

In the properties listing for the report there is an OrderBy property. That property listed several table fields, including the two fields that were giving me the problem. Those fields are not in the query (or, at least, I cannot find them in the query since I am learning that there may be things there that I do not know about). I do not know how they got in the Order By property, but I deleted everything in the Order By property, ran the report, and it seems to have solved the problem.

I appreciate all the time and effort that went into responding to my request. I am sorry if I seemed somewhat closeminded and did not understand the messages the first couple of times, but eventually my skull softened and you were able to get through to me.

 

[lcook1974]

Glad you got it worked out!

This forum is fantastic...you can find just about everything you need here.