I need help figuring out how to display filter string criteria in a report header. Right now, I have the filter string displaying foreign key id's instead of the actual descriptive text.

For example, the report header shows the following:

    function_id IN (4,5) AND status_id IN (2,4)

Instead of showing the format above, the end-users are requesting the following format:

    Function IN (Customer Service, Billing) AND Status IN (Open, In Progress)


Any help is greatly appreciated!

The following is an SQL statement that uses the IN function:

SELECT *
FROM suppliers
WHERE supplier_name in ( 'IBM', 'Hewlett Packard', 'Microsoft');

Now, do you have the actual string data listed in a table with ID's for the strings being the key to another table? Perhaps you could make the SQL statement's IN function include the string arguments instead of their key values?

I'd really need to see the table with the strings stored to make a firm suggestion.

But I am glad to help if I can!

Shane

Hey, thanks for your reply. I was able to get this issue resolved. See http://p2p.wrox.com/topic.asp?TOPIC_ID=62872 within the Access VBA forum for the full thread.

Do you have any insight on another issue I'm having regarding how to pass filter criteria to a sub report? See http://p2p.wrox.com/topic.asp?TOPIC_ID=62883