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
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
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...
So basically you would add a combobox or textbox for the Name, then just open the report based on the form selections...
ASKER
i need the report to display like this that is why- will try suggestion-
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
ASKER
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
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