How do you show Multiple ComboBox results for a record???

E

Elvis72

I have a report that has Project and Personnel information from 2 tables.

I have another table that records the staffing positions needed.

There might be 15 positions needed, but I don't know how to get that result
into my report?

The TblStaffing has:

StaffingID
Title

Then there is TblStaffingRequirements which has:

Job/ProposalNo (links this to the project)
StaffingID
StaffingListID

When I see this in my main form the result is a subform that has continuous
combobox fields to select the titles needed.

I can't wrap my head around producing a report that shows the output for
positions needed?
 
J

Jeff Boyce

Have you tried starting out with a query that gathers all the information
you need?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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