Query Criteria to pull report

  • Thread starter Thread starter administrator
  • Start date Start date
A

administrator

I have a report that I use several different queries and
tables from which to pull the report together. If I'm in
the query and I set the criteria to pull the "BankDate"
by asking for "Bank Date?" I get the information I need.
However, when I try to use it for the report I get "The
Microsoft Jet database engine does not recognize "Bank
Date?" as a valid field name or expression."

Now, Bank_Date (with the space between bank and date) is a
question to pull the criteria, bankdate (with no space)is
my field name.

Help. My whole database is based on being able to give me
information based on a bank date.
 
Is your query a crosstab? If so, you must enter the parameter data type.
Select Query|Parameters and enter:

[Bank Date] Date/Time
or
[Bank Date?] Date/Time
 
Duane:

Thanks a bunches... you're a sweetheart!!
-----Original Message-----
Is your query a crosstab? If so, you must enter the parameter data type.
Select Query|Parameters and enter:

[Bank Date] Date/Time
or
[Bank Date?] Date/Time

--
Duane Hookom
MS Access MVP


I have a report that I use several different queries and
tables from which to pull the report together. If I'm in
the query and I set the criteria to pull the "BankDate"
by asking for "Bank Date?" I get the information I need.
However, when I try to use it for the report I get "The
Microsoft Jet database engine does not recognize "Bank
Date?" as a valid field name or expression."

Now, Bank_Date (with the space between bank and date) is a
question to pull the criteria, bankdate (with no space) is
my field name.

Help. My whole database is based on being able to give me
information based on a bank date.
Click to expand...


.
Click to expand...
 
Back
Top