Recent content by accesconfused

worked like a charm. I did not realize the AND also had to be enclosed in the quotations separating out the second criterion argument. Thank you so much!

Hi all, I am attempting to create a DSum argument with a year criterion(Yr =2016) (Yr is a text field in my table) and an ID criterion (Me.ID)(ID is a number field in my table). I can successfully create functions that are either criteria independently, but when I try to combine the criteria...

thanks for getting back to me. the issue is related to storing data relative to who was entering it. "You have many people entering data. Presumably they log on to your system and are identified or are identifiable. Maybe they have or need a UserID. Then, in each new record add a field called...

Hi all, I know saving calculated values to a table field are generally taboo. however, i want to assign each record that is entered a new ID based upon the person entering data (such that if i have multiple persons entering data at the same time the record ID's from each individual will not...