cornishteeth
Board Regular
- Joined
- Dec 6, 2002
- Messages
- 117
I have a form that runs off a query. I utilize the DatePart
function to allow information for each quarter to be
displayed. Problem lies when the Employee Name comes up
for each quarter. Example - the name Bill Rice will come
up for quarter 1,2,3 & 4. I would like the name to come up
once and say January, February, and March show up. I
looked for a duplicate under properties and didn't see
one. Would I need to change the query or the form to only
display the Employee once. I have the Employees as the
GROUP BY function in the query, but for the DatePart to
work it also is selected as GROUP BY.
.
function to allow information for each quarter to be
displayed. Problem lies when the Employee Name comes up
for each quarter. Example - the name Bill Rice will come
up for quarter 1,2,3 & 4. I would like the name to come up
once and say January, February, and March show up. I
looked for a duplicate under properties and didn't see
one. Would I need to change the query or the form to only
display the Employee once. I have the Employees as the
GROUP BY function in the query, but for the DatePart to
work it also is selected as GROUP BY.
.