Pick a date range to report on

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a database for asset tracking. I want to have a report where I can
go in and select a lease ending date from a combo box that is being populated
by the dates already existing in the table. I have a query created that will
give me the names, dates serial numbers that I am looking for but I am not
sure where to go from there to get the report how I want. If you need more
information I can get it to you.

Thanks!
 
That's not really what I'm looking for. I don't have a beginning date, only
a lease end date. I also can't enter a date, I need to be able to pick from
a list that is populated from entries already in the table because I would be
guessing all day trying to find a date that is valid if I were just typing it.
 
Then:
a) you don't need a begin date, just an end date,
and
b) You cannot use a parameter withint the query, but must use a Form with a
combo box, so you can set its RowSource to the table values for the dates.

You will then build the WhereCondition string for the OpenReport action as
shown in the article.

Or you could refer to the combo on the form, by putting something like this
in the Criteria row of your query:
<= [Forms].[Form1].[Combo1]
 
Back
Top