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

  • Thread starter Thread starter Elvis72
  • Start date Start date
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?
 
Have you tried starting out with a query that gathers all the information
you need?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top