Parameter Query problem

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

Guest

Trying to put in a parameter for a select query and keep getting the
following message:

The Microsoft Jet database engine does not recognize <name> as a valid field
name or expression.

I have parameters set and working in other queries. But I get this meesage
everythime I try to create a new query with a parameter set.

Any ideas?
 
SELECT INSTRUMENT.PrDPN, PROJECT.PrAcronym, InFlags.InDPN, InFlags.SICM,
InFlags.SICMInvest, InCost.PtPf, INSTRUMENT.Instrument, InLevel2.LevelII,
[nrTotal]*[2005] AS NonRecCost, [rTotal]*[2005] AS RecCost, [InCost]*[2005]
AS TOTALCost, InPtCostsEscal.PTNRCost, InPtCostsEscal.PTRecCost,
InPtCostsEscal.PtTotalCost, InTech.WT, InTech.VOL, InTech.DrLo AS DRLow,
InTech.DR AS DRMed, InTech.DrHi AS DRPeak, InTech.PwrIn AS PwrAve,
InTech.PPwr AS PwrPeak, InTech.DectType, InProg.TRL, Lead.LeadName,
InInvest.Investigator, InProg.Affil, InProg.Manu, InProg.ContType,
InProg.Start, InProg.Deliv, ([Deliv]-[Start])/30.42 AS Duration,
PrProg.Launch, INSTRUMENT.Descr
FROM PROJECT RIGHT JOIN (((((((InFlags LEFT JOIN INSTRUMENT ON InFlags.InDPN
= INSTRUMENT.InDPN) LEFT JOIN InLevel2 ON INSTRUMENT.Level2 =
InLevel2.Level2) LEFT JOIN InPtCostsEscal ON INSTRUMENT.InDPN =
InPtCostsEscal.InDPN) LEFT JOIN PrProg ON INSTRUMENT.PrDPN = PrProg.PrDPN)
LEFT JOIN InTech ON INSTRUMENT.InDPN = InTech.InDPN) LEFT JOIN (InCost LEFT
JOIN [Escalation 12-31-2002_Crosstab] ON InCost.BaseYear = [Escalation
12-31-2002_Crosstab].BaseYear) ON INSTRUMENT.InDPN = InCost.InDPN) LEFT JOIN
((InProg LEFT JOIN Lead ON InProg.LeadID = Lead.LeadID) LEFT JOIN InInvest ON
InProg.InvId = InInvest.InvId) ON INSTRUMENT.InDPN = InProg.InDPN) ON
PROJECT.PrDPN = INSTRUMENT.PrDPN
WHERE (((InLevel2.LevelII)=[Enter Hardware Category:]));
 
Hi BamaBelle,

I suspect you need to explicitly
define the parameter type because
it includes the crosstab....

if "InLevel2.LevelII" is type Long,
then starting PARAMETERS clause
would look like:

PARAMETERS [Enter Hardware Category:] Long;
SELECT INSTRUMENT.PrDPN, .....



From Access 2000 Help:

PARAMETERS declaration DATA TYPES:

Data Type SQL PARAMETER string
========= ============================
Yes/No PARAMETERS [enter yes/no] Bit;
Byte PARAMETERS [enter 0-255] Byte;
Integer PARAMETERS [enter num] Short;
Long Integer PARAMETERS [enter num] Long;
Currency PARAMETERS [enter money] Currency;
Single PARAMETERS [enter num] IEEESingle;
Double PARAMETERS [enter num] IEEEDouble;
Date/Time PARAMETERS [enter startdate] DateTime;
Binary PARAMETERS [enter bin] Binary;
Text PARAMETERS [enter text] Text(255);
OLE Object PARAMETERS Forms!frmOLE!txtOLE LongBinary;
Memo PARAMETERS [enter memo] Text;
Replication ID PARAMETERS [enter RepID] Guid;
Value PARAMETERS Forms!frm1!txt1 Value;

BamaBelle said:
SELECT INSTRUMENT.PrDPN, PROJECT.PrAcronym, InFlags.InDPN, InFlags.SICM,
InFlags.SICMInvest, InCost.PtPf, INSTRUMENT.Instrument, InLevel2.LevelII,
[nrTotal]*[2005] AS NonRecCost, [rTotal]*[2005] AS RecCost,
[InCost]*[2005]
AS TOTALCost, InPtCostsEscal.PTNRCost, InPtCostsEscal.PTRecCost,
InPtCostsEscal.PtTotalCost, InTech.WT, InTech.VOL, InTech.DrLo AS DRLow,
InTech.DR AS DRMed, InTech.DrHi AS DRPeak, InTech.PwrIn AS PwrAve,
InTech.PPwr AS PwrPeak, InTech.DectType, InProg.TRL, Lead.LeadName,
InInvest.Investigator, InProg.Affil, InProg.Manu, InProg.ContType,
InProg.Start, InProg.Deliv, ([Deliv]-[Start])/30.42 AS Duration,
PrProg.Launch, INSTRUMENT.Descr
FROM PROJECT RIGHT JOIN (((((((InFlags LEFT JOIN INSTRUMENT ON
InFlags.InDPN
= INSTRUMENT.InDPN) LEFT JOIN InLevel2 ON INSTRUMENT.Level2 =
InLevel2.Level2) LEFT JOIN InPtCostsEscal ON INSTRUMENT.InDPN =
InPtCostsEscal.InDPN) LEFT JOIN PrProg ON INSTRUMENT.PrDPN = PrProg.PrDPN)
LEFT JOIN InTech ON INSTRUMENT.InDPN = InTech.InDPN) LEFT JOIN (InCost
LEFT
JOIN [Escalation 12-31-2002_Crosstab] ON InCost.BaseYear = [Escalation
12-31-2002_Crosstab].BaseYear) ON INSTRUMENT.InDPN = InCost.InDPN) LEFT
JOIN
((InProg LEFT JOIN Lead ON InProg.LeadID = Lead.LeadID) LEFT JOIN InInvest
ON
InProg.InvId = InInvest.InvId) ON INSTRUMENT.InDPN = InProg.InDPN) ON
PROJECT.PrDPN = INSTRUMENT.PrDPN
WHERE (((InLevel2.LevelII)=[Enter Hardware Category:]));
--
ö¿ö


Ken Snell said:
Post the SQL statement of the query that is producing this error message.
Click to expand...
Click to expand...
 
Does the error message actually contain the "<name>" text, or is it replaced
by a specific name from the query?

If you replace the [Enter Hardware Category:] with an actual value, does the
query work without an error?
--

Ken Snell
<MS ACCESS MVP>



BamaBelle said:
SELECT INSTRUMENT.PrDPN, PROJECT.PrAcronym, InFlags.InDPN, InFlags.SICM,
InFlags.SICMInvest, InCost.PtPf, INSTRUMENT.Instrument, InLevel2.LevelII,
[nrTotal]*[2005] AS NonRecCost, [rTotal]*[2005] AS RecCost,
[InCost]*[2005]
AS TOTALCost, InPtCostsEscal.PTNRCost, InPtCostsEscal.PTRecCost,
InPtCostsEscal.PtTotalCost, InTech.WT, InTech.VOL, InTech.DrLo AS DRLow,
InTech.DR AS DRMed, InTech.DrHi AS DRPeak, InTech.PwrIn AS PwrAve,
InTech.PPwr AS PwrPeak, InTech.DectType, InProg.TRL, Lead.LeadName,
InInvest.Investigator, InProg.Affil, InProg.Manu, InProg.ContType,
InProg.Start, InProg.Deliv, ([Deliv]-[Start])/30.42 AS Duration,
PrProg.Launch, INSTRUMENT.Descr
FROM PROJECT RIGHT JOIN (((((((InFlags LEFT JOIN INSTRUMENT ON
InFlags.InDPN
= INSTRUMENT.InDPN) LEFT JOIN InLevel2 ON INSTRUMENT.Level2 =
InLevel2.Level2) LEFT JOIN InPtCostsEscal ON INSTRUMENT.InDPN =
InPtCostsEscal.InDPN) LEFT JOIN PrProg ON INSTRUMENT.PrDPN = PrProg.PrDPN)
LEFT JOIN InTech ON INSTRUMENT.InDPN = InTech.InDPN) LEFT JOIN (InCost
LEFT
JOIN [Escalation 12-31-2002_Crosstab] ON InCost.BaseYear = [Escalation
12-31-2002_Crosstab].BaseYear) ON INSTRUMENT.InDPN = InCost.InDPN) LEFT
JOIN
((InProg LEFT JOIN Lead ON InProg.LeadID = Lead.LeadID) LEFT JOIN InInvest
ON
InProg.InvId = InInvest.InvId) ON INSTRUMENT.InDPN = InProg.InDPN) ON
PROJECT.PrDPN = INSTRUMENT.PrDPN
WHERE (((InLevel2.LevelII)=[Enter Hardware Category:]));
--
ö¿ö


Ken Snell said:
Post the SQL statement of the query that is producing this error message.
Click to expand...
Click to expand...
 
It appears as follows:

The Microsoft Jet database engine does not recognize [Enter hardware
categoy] as a valid field name or expression.

If I type in a specific category instead of the parameter the query runs
without error.

--
ö¿ö


Ken Snell said:
Does the error message actually contain the "<name>" text, or is it replaced
by a specific name from the query?

If you replace the [Enter Hardware Category:] with an actual value, does the
query work without an error?
--

Ken Snell
<MS ACCESS MVP>



BamaBelle said:
SELECT INSTRUMENT.PrDPN, PROJECT.PrAcronym, InFlags.InDPN, InFlags.SICM,
InFlags.SICMInvest, InCost.PtPf, INSTRUMENT.Instrument, InLevel2.LevelII,
[nrTotal]*[2005] AS NonRecCost, [rTotal]*[2005] AS RecCost,
[InCost]*[2005]
AS TOTALCost, InPtCostsEscal.PTNRCost, InPtCostsEscal.PTRecCost,
InPtCostsEscal.PtTotalCost, InTech.WT, InTech.VOL, InTech.DrLo AS DRLow,
InTech.DR AS DRMed, InTech.DrHi AS DRPeak, InTech.PwrIn AS PwrAve,
InTech.PPwr AS PwrPeak, InTech.DectType, InProg.TRL, Lead.LeadName,
InInvest.Investigator, InProg.Affil, InProg.Manu, InProg.ContType,
InProg.Start, InProg.Deliv, ([Deliv]-[Start])/30.42 AS Duration,
PrProg.Launch, INSTRUMENT.Descr
FROM PROJECT RIGHT JOIN (((((((InFlags LEFT JOIN INSTRUMENT ON
InFlags.InDPN
= INSTRUMENT.InDPN) LEFT JOIN InLevel2 ON INSTRUMENT.Level2 =
InLevel2.Level2) LEFT JOIN InPtCostsEscal ON INSTRUMENT.InDPN =
InPtCostsEscal.InDPN) LEFT JOIN PrProg ON INSTRUMENT.PrDPN = PrProg.PrDPN)
LEFT JOIN InTech ON INSTRUMENT.InDPN = InTech.InDPN) LEFT JOIN (InCost
LEFT
JOIN [Escalation 12-31-2002_Crosstab] ON InCost.BaseYear = [Escalation
12-31-2002_Crosstab].BaseYear) ON INSTRUMENT.InDPN = InCost.InDPN) LEFT
JOIN
((InProg LEFT JOIN Lead ON InProg.LeadID = Lead.LeadID) LEFT JOIN InInvest
ON
InProg.InvId = InInvest.InvId) ON INSTRUMENT.InDPN = InProg.InDPN) ON
PROJECT.PrDPN = INSTRUMENT.PrDPN
WHERE (((InLevel2.LevelII)=[Enter Hardware Category:]));
--
ö¿ö


Ken Snell said:
Post the SQL statement of the query that is producing this error message.

--

Ken Snell
<MS ACCESS MVP>

Trying to put in a parameter for a select query and keep getting the
following message:

The Microsoft Jet database engine does not recognize <name> as a valid
field
name or expression.

I have parameters set and working in other queries. But I get this
meesage
everythime I try to create a new query with a parameter set.

Any ideas?
Click to expand...
Click to expand...
Click to expand...
 
I don't see anything obviously wrong with the query that you posted using
the parameter. However, because you say the query works fine when you
replace the parameter with a real category, I am guessing that there is
something wrong with how you've actually typed in the string where the
parameter is located.... a missing space, not using [ or ] characters, or
some such syntax issue.

Try changing as well the words you're using in the parameter string.
--

Ken Snell
<MS ACCESS MVP>





BamaBelle said:
It appears as follows:

The Microsoft Jet database engine does not recognize [Enter hardware
categoy] as a valid field name or expression.

If I type in a specific category instead of the parameter the query runs
without error.

--
ö¿ö


Ken Snell said:
Does the error message actually contain the "<name>" text, or is it
replaced
by a specific name from the query?

If you replace the [Enter Hardware Category:] with an actual value, does
the
query work without an error?
--

Ken Snell
<MS ACCESS MVP>



BamaBelle said:
SELECT INSTRUMENT.PrDPN, PROJECT.PrAcronym, InFlags.InDPN,
InFlags.SICM,
InFlags.SICMInvest, InCost.PtPf, INSTRUMENT.Instrument,
InLevel2.LevelII,
[nrTotal]*[2005] AS NonRecCost, [rTotal]*[2005] AS RecCost,
[InCost]*[2005]
AS TOTALCost, InPtCostsEscal.PTNRCost, InPtCostsEscal.PTRecCost,
InPtCostsEscal.PtTotalCost, InTech.WT, InTech.VOL, InTech.DrLo AS
DRLow,
InTech.DR AS DRMed, InTech.DrHi AS DRPeak, InTech.PwrIn AS PwrAve,
InTech.PPwr AS PwrPeak, InTech.DectType, InProg.TRL, Lead.LeadName,
InInvest.Investigator, InProg.Affil, InProg.Manu, InProg.ContType,
InProg.Start, InProg.Deliv, ([Deliv]-[Start])/30.42 AS Duration,
PrProg.Launch, INSTRUMENT.Descr
FROM PROJECT RIGHT JOIN (((((((InFlags LEFT JOIN INSTRUMENT ON
InFlags.InDPN
= INSTRUMENT.InDPN) LEFT JOIN InLevel2 ON INSTRUMENT.Level2 =
InLevel2.Level2) LEFT JOIN InPtCostsEscal ON INSTRUMENT.InDPN =
InPtCostsEscal.InDPN) LEFT JOIN PrProg ON INSTRUMENT.PrDPN =
PrProg.PrDPN)
LEFT JOIN InTech ON INSTRUMENT.InDPN = InTech.InDPN) LEFT JOIN (InCost
LEFT
JOIN [Escalation 12-31-2002_Crosstab] ON InCost.BaseYear = [Escalation
12-31-2002_Crosstab].BaseYear) ON INSTRUMENT.InDPN = InCost.InDPN) LEFT
JOIN
((InProg LEFT JOIN Lead ON InProg.LeadID = Lead.LeadID) LEFT JOIN
InInvest
ON
InProg.InvId = InInvest.InvId) ON INSTRUMENT.InDPN = InProg.InDPN) ON
PROJECT.PrDPN = INSTRUMENT.PrDPN
WHERE (((InLevel2.LevelII)=[Enter Hardware Category:]));
--
ö¿ö


:

Post the SQL statement of the query that is producing this error
message.

--

Ken Snell
<MS ACCESS MVP>

Trying to put in a parameter for a select query and keep getting the
following message:

The Microsoft Jet database engine does not recognize <name> as a
valid
field
name or expression.

I have parameters set and working in other queries. But I get this
meesage
everythime I try to create a new query with a parameter set.

Any ideas?
Click to expand...
Click to expand...
Click to expand...
 
Bama,
I expect Gary's reply regarding the data types of the parameters is the
issue. Have you tried entering the data types of your parameters? Do you
understand where/how to do this?

--
Duane Hookom
MS Access MVP
--

Ken Snell said:
I don't see anything obviously wrong with the query that you posted using
the parameter. However, because you say the query works fine when you
replace the parameter with a real category, I am guessing that there is
something wrong with how you've actually typed in the string where the
parameter is located.... a missing space, not using [ or ] characters, or
some such syntax issue.

Try changing as well the words you're using in the parameter string.
--

Ken Snell
<MS ACCESS MVP>





BamaBelle said:
It appears as follows:

The Microsoft Jet database engine does not recognize [Enter hardware
categoy] as a valid field name or expression.

If I type in a specific category instead of the parameter the query runs
without error.

--
ö¿ö


Ken Snell said:
Does the error message actually contain the "<name>" text, or is it
replaced
by a specific name from the query?

If you replace the [Enter Hardware Category:] with an actual value, does
the
query work without an error?
--

Ken Snell
<MS ACCESS MVP>



SELECT INSTRUMENT.PrDPN, PROJECT.PrAcronym, InFlags.InDPN,
InFlags.SICM,
InFlags.SICMInvest, InCost.PtPf, INSTRUMENT.Instrument,
InLevel2.LevelII,
[nrTotal]*[2005] AS NonRecCost, [rTotal]*[2005] AS RecCost,
[InCost]*[2005]
AS TOTALCost, InPtCostsEscal.PTNRCost, InPtCostsEscal.PTRecCost,
InPtCostsEscal.PtTotalCost, InTech.WT, InTech.VOL, InTech.DrLo AS
DRLow,
InTech.DR AS DRMed, InTech.DrHi AS DRPeak, InTech.PwrIn AS PwrAve,
InTech.PPwr AS PwrPeak, InTech.DectType, InProg.TRL, Lead.LeadName,
InInvest.Investigator, InProg.Affil, InProg.Manu, InProg.ContType,
InProg.Start, InProg.Deliv, ([Deliv]-[Start])/30.42 AS Duration,
PrProg.Launch, INSTRUMENT.Descr
FROM PROJECT RIGHT JOIN (((((((InFlags LEFT JOIN INSTRUMENT ON
InFlags.InDPN
= INSTRUMENT.InDPN) LEFT JOIN InLevel2 ON INSTRUMENT.Level2 =
InLevel2.Level2) LEFT JOIN InPtCostsEscal ON INSTRUMENT.InDPN =
InPtCostsEscal.InDPN) LEFT JOIN PrProg ON INSTRUMENT.PrDPN =
PrProg.PrDPN)
LEFT JOIN InTech ON INSTRUMENT.InDPN = InTech.InDPN) LEFT JOIN (InCost
LEFT
JOIN [Escalation 12-31-2002_Crosstab] ON InCost.BaseYear = [Escalation
12-31-2002_Crosstab].BaseYear) ON INSTRUMENT.InDPN = InCost.InDPN)
LEFT
JOIN
((InProg LEFT JOIN Lead ON InProg.LeadID = Lead.LeadID) LEFT JOIN
InInvest
ON
InProg.InvId = InInvest.InvId) ON INSTRUMENT.InDPN = InProg.InDPN) ON
PROJECT.PrDPN = INSTRUMENT.PrDPN
WHERE (((InLevel2.LevelII)=[Enter Hardware Category:]));
--
ö¿ö


:

Post the SQL statement of the query that is producing this error
message.

--

Ken Snell
<MS ACCESS MVP>

Trying to put in a parameter for a select query and keep getting
the
following message:

The Microsoft Jet database engine does not recognize <name> as a
valid
field
name or expression.

I have parameters set and working in other queries. But I get this
meesage
everythime I try to create a new query with a parameter set.

Any ideas?
Click to expand...
Click to expand...
Click to expand...
 
Yes I know where and how to do this. I've tried it. And the query will run,
without the bizarre error message, but when I try to use it for a report it
Crashes Access :-( Its been very frustrating. The report works fine if I
leave the parameter off but once I put it in all hell breaks lose. I've even
tried using the Report wizard to create a quick report, same problem. I've
never had a problem with parameters in queries before this. I guess the
query is too convoluted. Cost Analysts and their weird requests....go
figure. I'm still trying to find a way to simplify the query so that I can
use it with the parameter. Any other suggestions would be greatly
appreciated.
Thanx
Belle
--
ö¿ö


Duane Hookom said:
Bama,
I expect Gary's reply regarding the data types of the parameters is the
issue. Have you tried entering the data types of your parameters? Do you
understand where/how to do this?

--
Duane Hookom
MS Access MVP
--

Ken Snell said:
I don't see anything obviously wrong with the query that you posted using
the parameter. However, because you say the query works fine when you
replace the parameter with a real category, I am guessing that there is
something wrong with how you've actually typed in the string where the
parameter is located.... a missing space, not using [ or ] characters, or
some such syntax issue.

Try changing as well the words you're using in the parameter string.
--

Ken Snell
<MS ACCESS MVP>





BamaBelle said:
It appears as follows:

The Microsoft Jet database engine does not recognize [Enter hardware
categoy] as a valid field name or expression.

If I type in a specific category instead of the parameter the query runs
without error.

--
ö¿ö


:

Does the error message actually contain the "<name>" text, or is it
replaced
by a specific name from the query?

If you replace the [Enter Hardware Category:] with an actual value, does
the
query work without an error?
--

Ken Snell
<MS ACCESS MVP>



SELECT INSTRUMENT.PrDPN, PROJECT.PrAcronym, InFlags.InDPN,
InFlags.SICM,
InFlags.SICMInvest, InCost.PtPf, INSTRUMENT.Instrument,
InLevel2.LevelII,
[nrTotal]*[2005] AS NonRecCost, [rTotal]*[2005] AS RecCost,
[InCost]*[2005]
AS TOTALCost, InPtCostsEscal.PTNRCost, InPtCostsEscal.PTRecCost,
InPtCostsEscal.PtTotalCost, InTech.WT, InTech.VOL, InTech.DrLo AS
DRLow,
InTech.DR AS DRMed, InTech.DrHi AS DRPeak, InTech.PwrIn AS PwrAve,
InTech.PPwr AS PwrPeak, InTech.DectType, InProg.TRL, Lead.LeadName,
InInvest.Investigator, InProg.Affil, InProg.Manu, InProg.ContType,
InProg.Start, InProg.Deliv, ([Deliv]-[Start])/30.42 AS Duration,
PrProg.Launch, INSTRUMENT.Descr
FROM PROJECT RIGHT JOIN (((((((InFlags LEFT JOIN INSTRUMENT ON
InFlags.InDPN
= INSTRUMENT.InDPN) LEFT JOIN InLevel2 ON INSTRUMENT.Level2 =
InLevel2.Level2) LEFT JOIN InPtCostsEscal ON INSTRUMENT.InDPN =
InPtCostsEscal.InDPN) LEFT JOIN PrProg ON INSTRUMENT.PrDPN =
PrProg.PrDPN)
LEFT JOIN InTech ON INSTRUMENT.InDPN = InTech.InDPN) LEFT JOIN (InCost
LEFT
JOIN [Escalation 12-31-2002_Crosstab] ON InCost.BaseYear = [Escalation
12-31-2002_Crosstab].BaseYear) ON INSTRUMENT.InDPN = InCost.InDPN)
LEFT
JOIN
((InProg LEFT JOIN Lead ON InProg.LeadID = Lead.LeadID) LEFT JOIN
InInvest
ON
InProg.InvId = InInvest.InvId) ON INSTRUMENT.InDPN = InProg.InDPN) ON
PROJECT.PrDPN = INSTRUMENT.PrDPN
WHERE (((InLevel2.LevelII)=[Enter Hardware Category:]));
--
ö¿ö


:

Post the SQL statement of the query that is producing this error
message.

--

Ken Snell
<MS ACCESS MVP>

Trying to put in a parameter for a select query and keep getting
the
following message:

The Microsoft Jet database engine does not recognize <name> as a
valid
field
name or expression.

I have parameters set and working in other queries. But I get this
meesage
everythime I try to create a new query with a parameter set.

Any ideas?
Click to expand...
Click to expand...
Click to expand...
 
Yesterday, I was reading John Viescas' book "Building Microsoft Access
Applications" www.viescas.com and he suggested using temporary tables for
reporting as needed. Most of the time they aren't recommended but when you
reach some limits of "convoluted", temp tables are a workable alternative.

--
Duane Hookom
MS Access MVP


BamaBelle said:
Yes I know where and how to do this. I've tried it. And the query will
run,
without the bizarre error message, but when I try to use it for a report
it
Crashes Access :-( Its been very frustrating. The report works fine if I
leave the parameter off but once I put it in all hell breaks lose. I've
even
tried using the Report wizard to create a quick report, same problem.
I've
never had a problem with parameters in queries before this. I guess the
query is too convoluted. Cost Analysts and their weird requests....go
figure. I'm still trying to find a way to simplify the query so that I
can
use it with the parameter. Any other suggestions would be greatly
appreciated.
Thanx
Belle
--
ö¿ö


Duane Hookom said:
Bama,
I expect Gary's reply regarding the data types of the parameters is the
issue. Have you tried entering the data types of your parameters? Do you
understand where/how to do this?

--
Duane Hookom
MS Access MVP
--

Ken Snell said:
I don't see anything obviously wrong with the query that you posted
using
the parameter. However, because you say the query works fine when you
replace the parameter with a real category, I am guessing that there is
something wrong with how you've actually typed in the string where the
parameter is located.... a missing space, not using [ or ] characters,
or
some such syntax issue.

Try changing as well the words you're using in the parameter string.
--

Ken Snell
<MS ACCESS MVP>





It appears as follows:

The Microsoft Jet database engine does not recognize [Enter hardware
categoy] as a valid field name or expression.

If I type in a specific category instead of the parameter the query
runs
without error.

--
ö¿ö


:

Does the error message actually contain the "<name>" text, or is it
replaced
by a specific name from the query?

If you replace the [Enter Hardware Category:] with an actual value,
does
the
query work without an error?
--

Ken Snell
<MS ACCESS MVP>



SELECT INSTRUMENT.PrDPN, PROJECT.PrAcronym, InFlags.InDPN,
InFlags.SICM,
InFlags.SICMInvest, InCost.PtPf, INSTRUMENT.Instrument,
InLevel2.LevelII,
[nrTotal]*[2005] AS NonRecCost, [rTotal]*[2005] AS RecCost,
[InCost]*[2005]
AS TOTALCost, InPtCostsEscal.PTNRCost, InPtCostsEscal.PTRecCost,
InPtCostsEscal.PtTotalCost, InTech.WT, InTech.VOL, InTech.DrLo AS
DRLow,
InTech.DR AS DRMed, InTech.DrHi AS DRPeak, InTech.PwrIn AS PwrAve,
InTech.PPwr AS PwrPeak, InTech.DectType, InProg.TRL, Lead.LeadName,
InInvest.Investigator, InProg.Affil, InProg.Manu, InProg.ContType,
InProg.Start, InProg.Deliv, ([Deliv]-[Start])/30.42 AS Duration,
PrProg.Launch, INSTRUMENT.Descr
FROM PROJECT RIGHT JOIN (((((((InFlags LEFT JOIN INSTRUMENT ON
InFlags.InDPN
= INSTRUMENT.InDPN) LEFT JOIN InLevel2 ON INSTRUMENT.Level2 =
InLevel2.Level2) LEFT JOIN InPtCostsEscal ON INSTRUMENT.InDPN =
InPtCostsEscal.InDPN) LEFT JOIN PrProg ON INSTRUMENT.PrDPN =
PrProg.PrDPN)
LEFT JOIN InTech ON INSTRUMENT.InDPN = InTech.InDPN) LEFT JOIN
(InCost
LEFT
JOIN [Escalation 12-31-2002_Crosstab] ON InCost.BaseYear =
[Escalation
12-31-2002_Crosstab].BaseYear) ON INSTRUMENT.InDPN = InCost.InDPN)
LEFT
JOIN
((InProg LEFT JOIN Lead ON InProg.LeadID = Lead.LeadID) LEFT JOIN
InInvest
ON
InProg.InvId = InInvest.InvId) ON INSTRUMENT.InDPN = InProg.InDPN)
ON
PROJECT.PrDPN = INSTRUMENT.PrDPN
WHERE (((InLevel2.LevelII)=[Enter Hardware Category:]));
--
ö¿ö


:

Post the SQL statement of the query that is producing this error
message.

--

Ken Snell
<MS ACCESS MVP>

message
Trying to put in a parameter for a select query and keep getting
the
following message:

The Microsoft Jet database engine does not recognize <name> as a
valid
field
name or expression.

I have parameters set and working in other queries. But I get
this
meesage
everythime I try to create a new query with a parameter set.

Any ideas?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top