I have an access datatbase with mutliple fields in a table. in addition i have a form with different creiteria selection options
you can select wether you want clients that are labeled billable or non-billable
start date and end date
The above is on a form with paremeter boxes for the dates and
radio buttons for the billable and non-billable status
how do i build a query to bring back all data based upon the criteria selected...
currently i have 2 command buttons
1) Build query 2) Run Query
behind the build query i have
Dim strSQL As String
if BuildSQLString(strSQL) Then
MsgBox "you query has been built"
CurrentDb.QueryDefs("qryshell").SQL = strSQL
i donot hae any code behind the other button