D
Duane Hookom
Is the Status field defined in your table as a lookup field?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Report based on Query - Query displays correct data, but the report does not...
S
Stewart Saathoff
Hello,
I have a report that is based on a query that pulls from a Jobs table and
three smaller tables reference it. The query is coded where it prompts the
user for a customer name which I have the criteria filtering with a like
statement on what is returned and it also filters for a status field. When
the query is run, it works perfectly. If I attempt to execute the report,
it will filter based on the customer name entered, but when I enter the
status, nothing is returned...
Can anyone tell me why my report won't work when the query that it is based
on does?
I have a report that is based on a query that pulls from a Jobs table and
three smaller tables reference it. The query is coded where it prompts the
user for a customer name which I have the criteria filtering with a like
statement on what is returned and it also filters for a status field. When
the query is run, it works perfectly. If I attempt to execute the report,
it will filter based on the customer name entered, but when I enter the
status, nothing is returned...
Can anyone tell me why my report won't work when the query that it is based
on does?
S
Stewart Saathoff
Do you mean in the query or the table or the report?
S
Stewart Saathoff
In the table, it is a text box...
Stewart Saathoff said:Do you mean in the query or the table or the report?
D
Duane Hookom
Maybe you should post your SQL and some sample values from the Status field.
What is the data type of the Status field? What are you typing in for a
value? Does your query work in datasheet view?
What is the data type of the Status field? What are you typing in for a
value? Does your query work in datasheet view?