Compare dates within rows

Jeni - Oct 21, 2010 at 02:52 PM
 RayH - Oct 21, 2010 at 03:10 PM

I have a query in access wich returns a title column which is common between 3 tables. The query also returns a date column which is found in each table - so the query returns 3 columns for dates. The query has a total of 4 columns, lets call it title, date1, date2, date3.

I might have to export the query to excel to do what I'm trying to do: I want to compare each date within a row (meaning 3 dates have in common the title) and if the dates dont match in that row then highlight the row (or fill it in with a colour), if dates match move on to the next row, and so on.

1 reply

in Excel, you can use Conditional formatting. In Access you can use a continuous form and some VBA code to highlight the row. You can't color the row just a a query. But, you can add another column that can act as a flag if all three match, i.e. IF date1=date2 and date2=date3 then flag=TRUE. Then filter for this.