If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Reports....

I have over 20 queries that i need put it in a different format for reporting purpose. there are some queries where end user put their name (whole name) and put two date range to get sales report.

Current Method: End user click on the query, then manually types his/her name then mannualy put start and end date.

Advance Method: Like to use form:
1. Is there a way to pick the name from drop down list
2. Input Start and End Date.
3. Click and run the query or report.

As always, any prompt help will be appreciated.

=======================================
All this queries are really for reports. So, I want the output to be in excel file. I hope i clear on this.
=======================================
you can send me a sample access database file at doran_doran8@yahoo.com.

Re: Thanks

Originally posted by charlottevk
How did you do it in access? I'm curious to know as I need to do a similiar thing except I don't need the output to be in Excell.

If you don't need to do it in excel it's pretty easy. You can either set report parameters, and reference a combo box (or whatever) for the name, and two text box values for the date. Or you could build the sql string dynamically and pass the whole thing as the source, which is a bit trickier but it's my preferred method.

How?

Thankyou for the info. This might sound like a really stupid question but how would you tell me how I can set the parameters? I want people to be able to type in a date and the report to generate it automatically.

Re: How?

Originally posted by charlottevk
Thankyou for the info. This might sound like a really stupid question but how would you tell me how I can set the parameters? I want people to be able to type in a date and the report to generate it automatically.

Hi Charlottevk

I attached a sample of my file that uses a parameter query to ask for a date range for my reports and works fine and my users can manage it without a problem. Hope this helps you out.
Bud

I think I'm trying to get at something similar. I have 3 sub forms in a form - each has it's own combo box which auto populates the other fields within the subform. What I'm attempting to get at is fashioning a report based off of the three subforms after each has been populated by a combo box choice. I wanted to do this via a link from the main form though.
Is this possible, or are we talking about completely different things?

Re: parameter values in the report

How can I place the parameter values at the top of a report? What code do I place where?

Charlotte,

After you have your parameter queries all set up, go to your ReportHeader. Create a TextBox. In the TextBox properties click on the DataTab then on the little dots....and enter something like this:

="From "&[EnterBeginningDate]&" Through "&[EnterEndingDate]

That's it. What that will do is reflect the dates the user inputs in the Parameters of the query. For my own program, the parameter is asking the user to : EnterBeginningDate and also EnterEndingDate which is the range. When the report prints it will also show the text I set up saying:
From 12/01/2003 Through 12/15/2003.
Hope this helps you out.
Bud