Heya all,

I'm using a modified version of the Service Call Management template that comes stock with Access. Just like the Invoice 'report' that they use to generate an invoice, I'd like to generate a work tag with just some basic information from the workorder form, and the workorder by customer form.

I've tried using the wizard (no luck) and design view using the form fields as control sources, but considering I'm not clear on exactly how all that works, nothing happened except for "name?".

Anyone who feels like guiding a newbie on his maiden report voyage, please do so! :)

Edit! I guess I could tell you what info I need...

The customer name from WorkorderByCustomer
The customer telephone number from WorkorderbyCustomer
The problem description from WorkOrder
The date received from WorkOrder

That's BASICALLY it. I can muddle my way through everything else.

I think.

Heh
Thanks,

Scott

grant,
Don't know if you solved this or not. I noticed another post about parameters. I will try to answer that one after this.
Have you used a query?
Try a query "new" and pick "simple query wizard" in the "tables/queries" choose WorkorderByCustomer and then select the fields you want. Then choose the WorkOrder table and select the fields you need. Finish the query and use the query to create a "form" or "report."