Report picking up wrong field (2003)

Topic

New Reply

I’m at a loss. I have a report that is really more of a letter. It’s control source is a query called Primary Administrators. The only fields on the report/letter are:
Person Name
Dept
Mail Code

The Person Name and Dept field are picking up exactly what they are supposed to. However, the Mail Code—–. I have no idea where that field is getting its’ numbers. I’ve checked the control for the report. It is Primary Administrators. I’ve checked the control for the field Mail Code. It is Mail Code. I’ve run the query independently ( it gets the numbers from a table) and the numbers in Mail Code are correct. The numbers showing in the Mail Code field look like the numbers in the ID field, but — because of deletions – at least two of the numbers are not included in the ID field of the query.
What else could it be? Where else do I look? Do I need an exorcist?
He-e-lp!

This says 2003 – it is actually Access 2002. Thank you.

Reply | Quote

Replies

If Mail Code is a lookup field, displayed as a combo box in the query, you can do either of the following:

– Add the lookup table to the query, and replace Mail Code by the appropriate field from the lookup table.

or

– Change the Mail Code text box on the report to a combo box, and give it the same settings as those of the field in the table or query (look at the Lookup tab for the field)

Reply | Quote

Thanks Hans – See what trouble you cause yourself when you only THINK you know what you are doing. For the time being, Lookup fields remain a mystery. But I’m mailing out my report today. Thanks again.

Reply | Quote

Thanks Hans – See what trouble you cause yourself when you only THINK you know what you are doing. For the time being, Lookup fields remain a mystery. But I’m mailing out my report today. Thanks again.

Reply | Quote

If Mail Code is a lookup field, displayed as a combo box in the query, you can do either of the following:

– Add the lookup table to the query, and replace Mail Code by the appropriate field from the lookup table.

or

– Change the Mail Code text box on the report to a combo box, and give it the same settings as those of the field in the table or query (look at the Lookup tab for the field)

Reply | Quote