That is fair and considerate on my part...sorry about that...here you go...
SELECT tblweeklyduties.InfraAdmin, tblweeklyduties.Date
FROM tblweeklyduties
GROUP BY tblweeklyduties.InfraAdmin, tblweeklyduties.Date, Year([date])
HAVING (((tblweeklyduties.Date)=basLastWkDay()) AND...
thanks Michael!
This is very close but when I call the function in my where clause on the Date field it only returns the last monday of the current month...I want to move through the table and return the records that match the last monday for each month...not just the current one...is this...
Here are the results from the above query...this is close but how can I pull out of this only the records that have a week date that is the last one for the month...for example...01/26/2004 is the last week of January but 04/19/2004 is not...I know this is a tough one and there might not be a...
I have a table that tracts weekly duties for my department. The weekly duties are dated beginning on monday of each week...I want to "filter" out the last week of a month for each month on the current year. Getting the current year is not a problem year(now()) and I tried doing a...
I am trying to number labels on a report I built. The labels have first name, last name, employee number fields included...I also want to number the labels consecutivly (ie, 1,2,3..)and show the number on the report...the report is generated from a table.
I have tried to do for...next...
We have a database with employees that have multiple employee numbers because their status has changed from temp to permanent employee.
What I want to do is create a group by name and list only employees with 2 or more employee numbers.
How can I count just the ones with duplicates?
Employee...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.