Recent content by IceFreeze

I just used the below sql to get a count of records with the same value, but a higher customer id number - and changed the color of the ones that returned zero (showing they were the first records of the new value) SELECT MAIN.N_CUST_ID, MAIN.T_TEAM_NAME, (select count(SUB.T_TEAM_NAME) from...

Oh - I didn't even think of using sql to generate a value that I could use for the conditional statement. I will try - thanks so much!

hmm - Thanks so much for the fast reply - so it looks like I will need to go with the conditional formating.. Can a calculated control investigate values of different rows? If so - could you provide any example for syntex? The form is currently using a query from a table as the record source...

I have a form that has a column of data (txtLastName) - with many repeated values. I would like to change the back-color of the field each time the data value in the field changes. For example: Anderson Anderson Anderson Abby Abby Smith Smith I would like the first occurance of Abby and Smith...