Recent content by jversiz

Try again... Sorry that 'DMax' function won't quite work, but it's still easy to do... 1. Make a query (let's call it qryGroupByDepartment) 2. The query should have two fields in it: The RecordID (from my previous post) and the Department 3. The total field for the RecordID should be set to...

Tasty McTasterson Hi, First of all, you need an auto-number field (let's call this field 'RecordID') in the table you are pointing the report to. On your report, create a text box. In the control source for this text box you can use the 'DMax' function to show the highest record within a...

You Rock! Thanks for the quick response. It works great! I originally wanted to use conditional formatting, however conditional formatting is only available for the text box itself, not it's label. Again, thank you very much! Best Regards, James C.

Hello Smart People! This one is driving me nuts. After doing quite a bit of research, I cannot find the answer that I need, so I am posting... For a new record on frm1 I am trying to make the label (lblTest) for a text box named txtTest a certain color if a value has not been filled in. For...