Recent content by rpferguson

Excellent peice of code. I altered this slightly to calculate mean in my queries. Thanks for the great code!

Is this in VBA? I'm assuming that this is part of the expression type in a query or macro coding. I would assume this would be Microsofts auto-format of particular expressions.

thnx. I didn't think so. I'll post my VBA functions when they're complete.

I have a database I am working on that allows a user to change or reset their password. This portion is not the issue, but I would like to be able to make sure that their password contains at least one upper case letter, one number and one special character before it gets encrypted and written...

I am trying to calculate the number of weekdays between two dates in an access query. I'm using Expr 1: DateDiff("w", #4/01/2006#, #02/26/2007#) When I use this expression with "d" instead of "w" I get 331 days, but when I use "w" I get 47 days. I know this can't be right.... Is there...