Link to home
Start Free TrialLog in
Avatar of davetough
davetough

asked on

add ability to search name field in query- before displaying records

hello - am attaching database
when database opens - a form comes up
if you select the date 8/22 in 'from' box
and 8/25 in 'to' box
Then click print button- you will see it displays records for those dates.

I want to be able to create a report also that first asks to enter a name- and only displays records with that name
is this possible?
[names are jones and thomas]
thank you
Echeck.accdb
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

whats the need to create a temp table? (and all the associated code)

A basic report filter could look something like this:
DoCmd.OpenReport "repweekly", acViewReport, , "SomeDateField=" & "#" & txtDate & "#" & " And " & "SomeNameField=" & "'" & Me.cboName & "'"

This is really all you need to open a report with a filters from a form


JeffCoachman
sorry.... More info

So basically you would add a combobox or textbox for the Name, then just open the report based on the form selections...
Avatar of davetough
davetough

ASKER

i need the report to display like this that is why- will try suggestion-
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
you may be right- i was having trouble- i wanted this to display - instead of vertical- more like a cross tab query- then I realized - excel did better job- but then I went back to access- because- I need to just make buttons that people can use- and exporting it to excel seems to be more involved-
but now i am wondering if  i can create this report without having a temp table and be this involved like you said-
maybe i am making more complicated than needs to be
thank you
i'll post back - when i complete

In Access you can create a Pivot table in some cases.

Finally (if your feeling froggy) you can create a "Dynamic Crosstab Report"
http://support.microsoft.com/kb/328320