Can you help please.
I have a query that is used to create a report.
The report prints fine but I now need to adjust it to print based on a user type, which it doesn't currently do.
At the moment the table that the query uses has a field with a users name in it. I'll call this field1
I need to adjust the query.
Using the name in field1 I would like to look up the corresponding person in the user file. The users file has a field called UserType and based on this value I would like to include it in the report or not.
Does that make sense?
Thanks for the help.