Report based on Query asking for all fields

  • Thread starter Thread starter Rick Johnston
  • Start date Start date
R

Rick Johnston

Hello,

I have created a report based on a query ... >=[Date] ... which is designed
to return all records on or after a certain date.

When I run the report, it does ask for a date input. After entering the
date, it continues to ask for criteria for all fields one by one. What do I
need to do to correct that?

Thanks in advance for any help.

Rick
 
Reports have a record source which is generally a table, query, or SQL
statement. The record source will have fields/columns. These fields can be
used as Control Source for text boxes and other controls.

How is your report different from these statements?
 
The record source is a query that pops up a window asking for a date
parameter. No Problem with that.

However, after entering the date, a series of windows opens asking for
parameters for all the other fields in the database.

That is the problem. I only want to enter the date parameter.

Rick


Duane Hookom said:
Reports have a record source which is generally a table, query, or SQL
statement. The record source will have fields/columns. These fields can be
used as Control Source for text boxes and other controls.

How is your report different from these statements?

--
Duane Hookom
MS Access MVP
--

Rick Johnston said:
Hello,

I have created a report based on a query ... >=[Date] ... which is
designed to return all records on or after a certain date.

When I run the report, it does ask for a date input. After entering the
date, it continues to ask for criteria for all fields one by one. What
do I need to do to correct that?

Thanks in advance for any help.

Rick
Click to expand...
Click to expand...
 
One possible issue is that Date is the name of a function and should not be
used as a field, memory variable, or parameter.

Am I correct in understanding that your query runs fine with just the one
prompt and you can easily view its datasheet view?

Do the field names displayed in your field list in report design match the
values in your control source properties of your text boxes?

--
Duane Hookom
MS Access MVP
--

Rick Johnston said:
The record source is a query that pops up a window asking for a date
parameter. No Problem with that.

However, after entering the date, a series of windows opens asking for
parameters for all the other fields in the database.

That is the problem. I only want to enter the date parameter.

Rick


Duane Hookom said:
Reports have a record source which is generally a table, query, or SQL
statement. The record source will have fields/columns. These fields can
be used as Control Source for text boxes and other controls.

How is your report different from these statements?

--
Duane Hookom
MS Access MVP
--

Rick Johnston said:
Hello,

I have created a report based on a query ... >=[Date] ... which is
designed to return all records on or after a certain date.

When I run the report, it does ask for a date input. After entering the
date, it continues to ask for criteria for all fields one by one. What
do I need to do to correct that?

Thanks in advance for any help.

Rick
Click to expand...
Click to expand...
Click to expand...
 
Hi Duane,

Maybe this is a workaround but I solved the problem of asking for multiple
parameters by including all fields in the query builder; but only asking for
a parameter in the one field.

And, yes the query ran just fine in datasheet view.

Thanks

Rick


Duane Hookom said:
One possible issue is that Date is the name of a function and should not
be used as a field, memory variable, or parameter.

Am I correct in understanding that your query runs fine with just the one
prompt and you can easily view its datasheet view?

Do the field names displayed in your field list in report design match the
values in your control source properties of your text boxes?

--
Duane Hookom
MS Access MVP
--

Rick Johnston said:
The record source is a query that pops up a window asking for a date
parameter. No Problem with that.

However, after entering the date, a series of windows opens asking for
parameters for all the other fields in the database.

That is the problem. I only want to enter the date parameter.

Rick


Duane Hookom said:
Reports have a record source which is generally a table, query, or SQL
statement. The record source will have fields/columns. These fields can
be used as Control Source for text boxes and other controls.

How is your report different from these statements?

--
Duane Hookom
MS Access MVP
--

Hello,

I have created a report based on a query ... >=[Date] ... which is
designed to return all records on or after a certain date.

When I run the report, it does ask for a date input. After entering
the date, it continues to ask for criteria for all fields one by one.
What do I need to do to correct that?

Thanks in advance for any help.

Rick
Click to expand...
Click to expand...
Click to expand...
 
Back
Top