Not sure how to do this

A

Anna

In my Report if I have a Wholesaler, I have to show a Company name, If it's a
Employee, I need to show a Deptment Name. This information comes from one
Table. Any suggestions how to achieve this?
 
D

Duane Hookom

Any suggestions on what your records look like? Maybe some field names and
sample records? Then throw in the desired display to top things off.
 
J

John Vinson

In my Report if I have a Wholesaler, I have to show a Company name, If it's a
Employee, I need to show a Deptment Name. This information comes from one
Table. Any suggestions how to achieve this?
Click to expand...

Use a query which correctly pulls the name field from your table.

Since we have no way of seeing your table, how it's constructed, or
how you want the query to work, it's a bit difficult to suggest what
that query might be. Could you give us a bit of help?

John W. Vinson[MVP]
 
A

Anna

o.k. - Here's more info- Staff Query is set up like this: Registration Code,
Last Name, First Name, Department Name. Wholesaler's Query is set up like
this: Registration Code, Last Name, First Name, Company, City, State, Region.
In a report - how do I get it to show Company Name for Wholesalers or
Department Name for Staff?
 
D

Duane Hookom

You have two different recordsets with different fields. You mention one
report. One report can have only one recordsource. You can combine multiple
recordsets into a single one with a union query. Also, a report can contain
subreports.

I had asked for sample records but you seemed to have not read that...
 
Top