Recent content by mhill31

Fantastic! Thanks so much. I was guessing all kinds of words but obviously never thought of that one. Help from all is much appreciated!

Is there a function that works like WeekDay() for time frames. I have a date field that includes time. I would like a field that returns one number for all times between 1AM and 2AM then a different number for all times between 2AM and 3AM. So if the date field included the time 2:04 AM then...

It worked. Thank you very much!

I have a couple of subforms on a main form that are in datasheet view. There are just three fields in each. I want to tab out of the third field to save the record but I want to reselect the same record instead of going on to a new record. I also have subforms on this same main form that...

Thanks very much. I still needed the code to scoot the lines up so there were no blank lines in the address but once I set them all to Can Shrink, it stopped moving them up if the fields were not blank. Mystery solved. Thanks again. Now I can move onto my next challenge. Melissa

Hi, I have an invoice (report) with fields listed down [company], [address2], [address1], [City, State, zip]. When [address2] is blank I want [address1] and [City, State, Zip] to move up. There are also occassions when both address lines would be blank in which case I want [city, state, zip]...