Search results

Ok thank you and this goes into the code of the unbound control or do you need an unbound control for each WHERE statement?

Pat Ok sorry I'm learning here and really dont follow alot of what you said. I get the unbound control but what code goes in that then for the search parements to be set. maybe this question is just too advanced for me

Not sure what all that means Here is the SQL I currently have but if i leave end date blank it returns nothing SELECT DISTINCT tblDisciplineIssues.DisciplineID, tblDOHLocations.BureauName, tblDOHLocations.OrgCodes, tblDisciplineYears.DisciplineYearID, [Firstname] & " " & [Lastname] AS...

Search starts with a button that opens the report. A query is tied to the report so when the report access the query it runs the SQL of the qurey to get the data for the report. The date is 01/01/2023 (Layout) so if there a search just by 2023 in the same query or would i have to make another...

The year is just part of the date Like 01/01/2023 Can we just do a search on 2023?

OK thank you so i put this as the onclick command for the button and it did not work sure i'm missing Private Sub cmdOpenRPT_Click() DoCmd.OpenReport rptAllDiscipline, acViewNormal WHERE (DisciplineDate >= [txtDateStart] Or [txtDateStart] Is Null) AND (DisciplineDate < [txtDateEnd] + 1) OR...

Hello, I can't figure this out. I have a query with a date. I want users to select the start date and if they want to see any thing from the start date forward just hit enter at the end date box. If they want to enter an end date they can do that as well. Also is there a way to query just the...