alternating colors for groups of records in Forms / Datasheet view?
Posted on 2006-04-07
I have a duplicates query that returns groups of records. I would like to alternate between grey and white for each group of records in a datasheet view form.
SELECT Staged_Accounts.REQID, Staged_Accounts.FILENO, Staged_Accounts.Email, Staged_Accounts.Collector, Staged_Accounts.Reason, Staged_Accounts.Date, Staged_Accounts.Approve, Staged_Accounts.Deny, Staged_Accounts.Maybe, Staged_Accounts.Comment
WHERE (((Staged_Accounts.FILENO) In (SELECT [FILENO] FROM [Staged_Accounts] As Tmp GROUP BY [FILENO] HAVING Count(*)>1 )))
ORDER BY Staged_Accounts.FILENO; (it's an access canned duplicates query, sorted Ascending)
I have looked at several solutions you fine folks have given for variations of the same problem, but I can't seem to adapt any of them to my problem. any help appreciated.