Problem with Report displaying relavent results

[wotamelon]

Hi all, thx for taking time to read this.

Problem: All the detail supplied to the report is based on query. The query displays results based on customer first name and last name based on parameter prompts

It's not displaying all the data, even when i hit show all...
(Customer details, job items, job orders are in tables)
The query is suppose to pluck out all the data when i filter it

why is it working?
It's getting on my nerve

 

[PNGBill]

Have you tested the query by itself to see what data it returns?
If it supplies all the data you are looking for in your report, then it should work.

If any data is missing, then your query is not constructed properly.

 

[wotamelon]

Thanks for the post, i fixed it!

great 'query' on my query. I had relationship problems so thats the reason behind it!