Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

display multiple values for a control on a report

Status
Not open for further replies.

JOEYB99

Technical User
Jul 9, 2008
121
CA

I am using Access 2010 and have a linked table of Cost Code values and each cost code can have one or more Cost Type values. The linked table is a spreadsheet from our main ERP.

I would like to have a report that shows all cost types for each cost code.

e.g.

Cost Code Cost Type
.00.00.0.01 E, L, I
.00.00.0.02 E, L, M
.00.00.0.03 E, M, I, S
.00.00.0.04 I


Can someone please help me get started on how I can accomplish this?
 
It would help if you provided some actual data with table and field names. Generically you might be able to base your report on a query that uses faq701-4233

Duane
Hook'D on Access
MS Access MVP
 
Thanks DHookom.

I think this is exactly what I need. I will follow the instructions on your link and let you know how it turns out.

I am using a single table and its records look like this,

Cost Code Cost Type
.00.00.0.01 E
.00.00.0.01 L
.00.00.0.01 I
.00.00.0.02 E
.00.00.0.02 L
.00.00.0.02 M

Both fields are text.



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top