required date range query

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

Guest

I have a switchboard set up for my database to make it more user friendly to
those who have never used access. I need to be able to list the multiple
reports that are available in the database so that the user can click on the
report name and the parameter boxes will open to query the date ranges. I
have set up a macros to open the query from the switchboard and that works,
but it adds an extra parameter field that's not listed in my query. When I
run the query directly from the database this box doesn't pop up so I'm
perplexed as to why I'm getting it from the switchboard. Also, I need to
make the query require the date fields for the user to continue. I have it
set up "Between[Enter Report Start Date] and [Enter Report End Date]". This
is the first database I have had to set up on my own and code is very greek
to me.
 
I read your question and I am not sure what question you are asking. You
need to be more specific than "it adds an extra parameter field that's not
listed in my query", too. This often means that something is misspelled and
Access is not finding the Field because of the misspelling.

In addition to the Criteria you show, have you defined Parameters for the
Query, or are you only referring to the [Enter Report Start Date] and the
[Enter Report End Date] that you describe?

Can you describe the macro that is involved?

What, exactly, is in the box that pops up asking for the extra parameter? Is
that the name of a Field in the Table, or a Field in the Query, or is it
"close" to either?

Larry Linson
Microsoft Access MVP
 
Back
Top