Form Field Duplication

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

Another problem that is probably an easy fix. 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.
 
I think what you want is a crosstab query. Have you
looked into doing one off of your query using the Employee
as your group by field and then your DatePart as the
columns?
 
Back
Top