Search results

I have a field that calculates the difference between two dates (formula below). It is outputting in numeric format (I looked at the table in design view). Whenever I add a criteria of <365 (to help eliminate bad data) the whole query returns a table with no information. Without any criteria...

I am trying to create a calculated field that outputs what date range of the month a file was received by a department. I want to create the following groups: day of month 1-10 in one group, days 11-20, and 21-EOM. I tried to create a formula to do this and I think I messed up something...

I am trying to find the earliest date out of 6 different date fields (some of which may be null). I found this article on the Microsoft Site (support.microsoft.com/kb/182760) that helped me create a module so I have a function called Minimum and Maximum that seems very easy to use, and in fact...

Hi, I'm a newbie here, and pretty much a big newbie with Access too. I live in Minneapolis, Minnesota, US. I work at a bank that isn't very good at keeping up with technology. I am relatively new in my position and could definitely use some help here and there. I found this site from...