Replies

Plese see my reply to Charlott
Thaks

John

There are no error messages. The table includes all the operations that we do on all our jobs. Each job may have up to 30 records, one for each operation that has to be performed to complete the job. Each record then has the pertinent info for that operation, furnace temperature, crew size, customer specifications, method and so on. So when we run a job we have to put a method sheet (the report in question) out on the floor to the men to doing the work. The same report is used all over the shop, but we use the parameter qry to pull up only the operation (record) that is used at that area of the shop.
So each report has only the record that we want for that operation.

When we run the other operations (records) for the same job they show show up on the report fine.
When it doesn’t work properly the report comes up with the requested job number showing and the requested Sequence which are part of the record but the balance of the infor shows blank.

As I mentioned before if I just run the qry without the report it shows up fine. Also same sequence (record) number shows up on other jobs.

Thanks
I really appreciate it. You will probley hear from me later as I try to write it. It sounds just what I need.

John

Thank You
I will try it in the morning. I wasn’t sure if I just used the equals sign then the brackets or something else.

Thanks
John