Multiple Combo Box Values

R

Rebeca

I have a report that I use to make invoices. When an order is ready to be
invoiced, I have a query where I make final changes. My invoice report is
based on this query. The only problem is that if one order has multiple
values for the commodities field, the report prints out one invoice for each
commodity. On every other table, query, or form, those values are separated
by a comma. Is there any way this could happen on my report?

Thanks for your help.
 
C

Clifford Bass

Hi Rebeca,

Is this a new report you are creating? Did you create the others? How
about going into design mode on one that works in the fashion you desire and
seeing what was done to get it to report as you desire? Look also at the VBA
code, if any, that is attached to the report. Then replicate the process in
the new report.

Clifford Bass
 
R

Rebeca

Thanks Clifford. Your suggestion of going back and looking at the other
properties helped me catch my mistake.

Have a nice day!
 
C

Clifford Bass via AccessMonster.com

Hi Rebeca,

You are welcome. Glad it helped!

Clifford Bass
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top