Search results

Like CBrighton said using a mulity search form by using form design make ase many bounded text boxes you need (one box for each colum you want to search by) lable the lables and then name the box then leave the controle source blank. in your query in the critera use Like "*" & [form]![the form...

Thank You this worked I was trying not to have to make another query but I guess that is what I needed to do. I had to make 4 querys just to get that simple task done:banghead:

In Access 2010 when you add a button the wizard will open. then go to misc and Run Query. you can also show it as a report if you have made a report from your query you would use the Report Operations and Run Report this will show you your query as a report that you could print or email.

Here is the SQL from my Query SELECT PreStatus.Operator, PreStatus.Mode, Sum(PreStatus.CountOfMode) AS SumOfCountOfMode, IIf([SumOfCountOfMode]>=3,"YES","NO") AS [Current], PreStatus.Rate, PreStatus.Last, PreStatus.First, PreStatus.DET FROM PreStatus GROUP BY PreStatus.Operator...