Search results

CDate(LEFT(string,2) & "/" & MID(string,3,2) & "/" & Right(string,2))

Here's an example: Private sub Blah () Dim dbs As DAO.Database Dim rstBlah As DAO.Recordset Set dbs = CurrentDb() Set rstBlah = dbs.OpenRecordset("Select * from tblblah", dbOpenSnapshot, dbSeeChanges) Do While Not rstBlah.EOF If rstBlah!blabbity = “snarf” then Yadda yadda End if...

Iif(v1>v2,iif(v1>v3,v1,v3),iif(v2>v3,v2,v3)))

The extensions are included with VSTO 2005. You should still be able to find a copy of this hanging around somewhere.

If me.combo1 is text you should be using triple double quotes on each side of it. """ & string & """

Just do the math in your query as an expression field and then aggregate that column as a sum.

It looks like you have a date1 and date2 for your effective date range of your forms. In your query you could have a calculated column with an IIF function that looks like IIF(MyDate between date1 and date2, 1,0) then just select all records that return 1.