view button

[buggy2]

now to finish i need to select particular categories in the query. What i mean is if the person selects the amount checkbox on the form then the query results show the amounts entered for the selected day and time at that time. Any help would be great.

Note the option must be selected from the form checkbox.

 

[Dugantrain]

The first way that comes to mind to do this would be to write separate queries for each option and then have VBA code behind the form which selects the appropriate query based upon which option is checked (I would use Option buttons rather than check boxes so that you can only have one category at a time selected). Each query will have Date, Time, and the Category as fields. If you only have a few categories and writing separate queries is an option, then in VBA:

Your CommandButton_OnClick()
If me.optionbutton1=true then
docmd.openquery "Name of First Query", acnormal, acedit
elseif me.optionbutton2=true then
docmd.openquery "Name of Second Query", acnormal, acedit
End If
End Sub