Im not sure what you mean; new to database. But each sql is different for instance on the same form I need a sql statement that gets the date between for DATE_OPENED but I also need to get INQ_BY="T" in the same statement:
Also i had to take refresh out for second sql or i get an error.

this is not working:

Dim sqlTotalDataBasePending As String
Dim sqlTotalDataBaseTelephone As String
Dim sqlTotalDatabaseLetter As String

sqlTotalDataBaseReceived = "Select COUNT (*) From Master WHERE DATE_OPENED BETWEEN #" & strStartDate & "# and #" & strEndDate & "#"
Data2.RecordSource = sqlTotalDataBaseReceived
Data2.Refresh
lblTotalDatabaseReceived.Caption = Data2.Recordset(0)

sqlTotalDataBaseTelephone = "Select COUNT (*) From Master WHERE DATE_OPENED BETWEEN #" & strStartDate & "# and #" & strEndDate & "#" & INQ_BY = "T"
Data2.RecordSource = sqlTotalDataBaseTelephone
lblTotalDatabaseTelephone.Caption = Data2.Recordset(0)