Multiple Records in Subform

[tmdrake]

I have a database with a Main form and a subform. From the main form a user
can make a selection from four (4) different comboboxes for a certain time
range; once a selection is made the result are displayed on the subform. In
the subform, you can double click on one of four fields and the results are
exported to excel.

My problem is the query pulls all the records for each employee for that
selection in that time frame. Exp. the selection made is by ProjectId. the
subform displays all the employees working on the project selected during
that time frame for each week. Instead on showing a row for each week, is
there a way that the employee is only showed once, but still on the double
click all the records are exported to excel.

Hopefully this makes since; all help is appreciated.

 

[Larry Linson]

You have told us only the externals... you need to clarify for us the
details of _how_ you are trying to do the export -- sounds as if you have
simply missed including one of the factors into the WHERE clause, but
without details, that's only a guess.

Larry Linson
Microsoft Office Access MVP