Make Query with Parameter Issues

M

Marsha

I'm trying to run a make query that I just created, and it keep asking
me for parameters? I didn't specificy any parameters, though I did
specify a great than (>0) requirement. Maybe I wrote this in wrong.
Can anyone perhaps take a look at the sql language and endeavor a guess
as to what I may be doing wrong? (Sorry it's a bit long)

SELECT DISTINCT Trim([NF06-Scantest1].[SSN]) AS SSN1,
Trim([NF06-Scantest1].[VisitDate]) AS VisitDate1,
Trim([NF06-Scantest5].[VisitType]) AS VisitType1,
Trim([NF06-Scantest6].[MedicationAdjustment]) AS MedAdj,
Trim([NF06-Scantest2].[Residence]) AS Residence1,
Trim([NF06-Scantest5].[PrimaryDiagnosis]) AS Diagnosis,
IIf([NF06-ScanTest8].[HoehnandYahr]>0,[NF06-Scantest8].[HoehnandYahr],"
") AS HoehnAndYahrScale,
IIf([NF06-Scantest8].[SchwabandEngland]>0,[NF06-Scantest8].[SchwabandEngland],"
") AS SchwabandEnglandScale, [NF06-Scantest2].PainIndex AS PainIndex,
IIf([NF06-Scantest2].[Memory],[NF06-Scantest2].[Memory]) AS UPDRS1,
IIf([NF06-ScanTest2].[Hallucinations],[NF06-Scantest2].[Hallucinations])
AS UPDRS2,
IIf([NF06-ScanTest2].[SadDepressed],[NF06-Scantest2].[SadDepressed]) AS
UPDRS3, IIf([NF06-Scantest2].[Speech],[NF06-Scantest2].[Speech]) AS
UPDRS5, IIf([NF06-Scantest3].[Falls],[NF06-Scantest3].[Falls]) AS
UPDRS7,
IIf([NF06-Scantest3].[AbilitytoWalk],[NF06-Scantest3].[AbilitytoWalk])
AS UPDRS13,
IIf([NF06-Scantest7].[Dyskinesias],[NF06-Scantest7].[Dyskinesias]) AS
UPDRS15,
IIf([NF06-Scantest7].[DisablingDyskinesias],[NF06-Scantest7].[DisablingDyskinesias])
AS UPDRS33,
IIf([NF06-Scantest7].[PercentOff],[NF06-Scantest7].[PercentOff]) AS
UPDRS39,
IIf([NF06-Scantest7].[SleepProblems],[NF06-Scantest7].[SleepProblems])
AS UPDRS41, IIf([NF06-Scantest7].[Dizzy],[NF06-Scantest7].[Dizzy]) AS
UPDRS42, Trim([NF06-Scantest6].[AmantadineCR]) AS CurAmantadine,
Trim([NF06-Scantest6].[ApomorphineCR]) AS CurApomorphine,
([NF06-Scantest6].[BotulinumACr]) AS CurBotulinumACr,
Trim([NF06-Scantest6].[BotulinumBCr]) AS CurBotulinumB,
Trim([NF06-Scantest6].[ClozapineCr]) AS CurClozapine,
Trim([NF06-Scantest6].[FludrocortisoneCr]) AS CurFludrocortisone,
Trim([NF06-Scantest6].[MidodrineCr]) AS CurMidodrine,
Trim([NF06-Scantest6].[QuetiapineCr]) AS CurQuetiapine,
Trim([NF06-Scantest6].[CitalopramCr]) AS CurCitalopram,
Trim([NF06-Scantest6].[FlueoxetineCR]) AS CurFlueoxetine,
Trim([NF06-Scantest6].[FluvoxamineCr]) AS CurFluvoxamine,
Trim([NF06-Scantest6].[BenztropineCr]) AS CurBenztropine,
Trim([NF06-Scantest6].[PramipexoleCr]) AS CurPramipexole,
Trim([NF06-Scantest6].[SelegilineCr]) AS CurSelegiline,
Trim([NF06-Scantest6].[TrihexyphenidylCr]) AS CurTrihexyphenidy,
Trim([NF06-Scantest6].[ParoxetineCr]) AS CurParoxetine,
Trim([NF06-Scantest6].[SertralineCr]) AS CurSertraline,
Trim([NF06-Scantest6].[Levodopa-carbidopa-CRCr]) AS
[CurLevodopa-carbidopa-CR], Trim([NF06-Scantest6].[RopiniroleCr]) AS
CurRopinirole, Trim([NF06-Scantest6].[TolcaponeCr]) AS CurTolcapone,
Trim([NF06-Scantest6].[Levodopa-carbidopa-entacaponeCr]) AS
[CurLevodopa-carbidopa-entacapone],
Trim([NF06-Scantest6].[EntacaponeCr]) AS CurEntacapone,
Trim([NF06-Scantest6].[MemantineCr]) AS CurMemantine,
Trim([NF06-Scantest6].[RivastigmineCr]) AS CurRivastigmine,
Trim([NF06-Scantest6].[GalantamineCr]) AS CurGalantamine,
Trim([NF06-Scantest6].[DonepezilCr]) AS CurDonepezil,
[NF06-Scantest6].Other1Cr, [NF06-Scantest6].Other2Cr,
[NF06-Scantest6].Other3Cr,
[memory]+[VividDreamsHallucinations]+[Depressed] AS UPDRSI,
[Speach]+[Swallowing]+[Falling]+[Walking] AS UPDRSII,
[Dyskinesias]+[HowDisablinDyskinesias]+[pERIODOFDAYOFF] AS UPDRSIII,
[SleepProblems]+[LightheadedDizzy] AS UPDRSIV, [NF06-Scantest3].[EQ-5D]
INTO Visit
FROM ((((((([NF06-Scantest1] INNER JOIN [NF06-Scantest2] ON
([NF06-Scantest1].VisitDate = [NF06-Scantest2].VisitDate) AND
([NF06-Scantest1].SSN = [NF06-Scantest2].SSN)) INNER JOIN
[NF06-Scantest3] ON ([NF06-Scantest1].VisitDate =
[NF06-Scantest3].VisitDate) AND ([NF06-Scantest1].SSN =
[NF06-Scantest3].SSN)) INNER JOIN [NF06-Scantest4] ON
([NF06-Scantest1].VisitDate = [NF06-Scantest4].VisitDate) AND
([NF06-Scantest1].SSN = [NF06-Scantest4].SSN)) INNER JOIN
[NF06-Scantest5] ON ([NF06-Scantest1].VisitDate =
[NF06-Scantest5].VisitDate) AND ([NF06-Scantest1].SSN =
[NF06-Scantest5].SSN)) INNER JOIN [NF06-Scantest6] ON
([NF06-Scantest1].VisitDate = [NF06-Scantest6].VisitDate) AND
([NF06-Scantest1].SSN = [NF06-Scantest6].SSN)) INNER JOIN
[NF06-Scantest7] ON ([NF06-Scantest1].VisitDate =
[NF06-Scantest7].VisitDate) AND ([NF06-Scantest1].SSN =
[NF06-Scantest7].SSN)) INNER JOIN [NF06-Scantest8] ON
([NF06-Scantest1].VisitDate = [NF06-Scantest8].VisitDate) AND
([NF06-Scantest1].SSN = [NF06-Scantest8].SSN)) INNER JOIN
[NF06-Scantest9] ON ([NF06-Scantest1].VisitDate =
[NF06-Scantest9].VisitDate) AND ([NF06-Scantest1].SSN =
[NF06-Scantest9].SSN)
ORDER BY Trim([NF06-Scantest1].[SSN]);
 
G

Guest

Even if you have no parameters, Access will prompt you if you have an
expression that it cannot resolve to one of the source tables. For example,
in your column defined as :
[memory]+[VividDreamsHallucinations]+[Depressed] AS UPDRSI

if Access doesn't can't find a field called [memory] in one of the tables,
it will prompt you for it when you run the query.

What is it prompting you for? Look in the query for whatever the prompt is
and I think you'll find the answer.

Barry

Marsha said:
I'm trying to run a make query that I just created, and it keep asking
me for parameters? I didn't specificy any parameters, though I did
specify a great than (>0) requirement. Maybe I wrote this in wrong.
Can anyone perhaps take a look at the sql language and endeavor a guess
as to what I may be doing wrong? (Sorry it's a bit long)

SELECT DISTINCT Trim([NF06-Scantest1].[SSN]) AS SSN1,
Trim([NF06-Scantest1].[VisitDate]) AS VisitDate1,
Trim([NF06-Scantest5].[VisitType]) AS VisitType1,
Trim([NF06-Scantest6].[MedicationAdjustment]) AS MedAdj,
Trim([NF06-Scantest2].[Residence]) AS Residence1,
Trim([NF06-Scantest5].[PrimaryDiagnosis]) AS Diagnosis,
IIf([NF06-ScanTest8].[HoehnandYahr]>0,[NF06-Scantest8].[HoehnandYahr],"
") AS HoehnAndYahrScale,
IIf([NF06-Scantest8].[SchwabandEngland]>0,[NF06-Scantest8].[SchwabandEngland],"
") AS SchwabandEnglandScale, [NF06-Scantest2].PainIndex AS PainIndex,
IIf([NF06-Scantest2].[Memory],[NF06-Scantest2].[Memory]) AS UPDRS1,
IIf([NF06-ScanTest2].[Hallucinations],[NF06-Scantest2].[Hallucinations])
AS UPDRS2,
IIf([NF06-ScanTest2].[SadDepressed],[NF06-Scantest2].[SadDepressed]) AS
UPDRS3, IIf([NF06-Scantest2].[Speech],[NF06-Scantest2].[Speech]) AS
UPDRS5, IIf([NF06-Scantest3].[Falls],[NF06-Scantest3].[Falls]) AS
UPDRS7,
IIf([NF06-Scantest3].[AbilitytoWalk],[NF06-Scantest3].[AbilitytoWalk])
AS UPDRS13,
IIf([NF06-Scantest7].[Dyskinesias],[NF06-Scantest7].[Dyskinesias]) AS
UPDRS15,
IIf([NF06-Scantest7].[DisablingDyskinesias],[NF06-Scantest7].[DisablingDyskinesias])
AS UPDRS33,
IIf([NF06-Scantest7].[PercentOff],[NF06-Scantest7].[PercentOff]) AS
UPDRS39,
IIf([NF06-Scantest7].[SleepProblems],[NF06-Scantest7].[SleepProblems])
AS UPDRS41, IIf([NF06-Scantest7].[Dizzy],[NF06-Scantest7].[Dizzy]) AS
UPDRS42, Trim([NF06-Scantest6].[AmantadineCR]) AS CurAmantadine,
Trim([NF06-Scantest6].[ApomorphineCR]) AS CurApomorphine,
([NF06-Scantest6].[BotulinumACr]) AS CurBotulinumACr,
Trim([NF06-Scantest6].[BotulinumBCr]) AS CurBotulinumB,
Trim([NF06-Scantest6].[ClozapineCr]) AS CurClozapine,
Trim([NF06-Scantest6].[FludrocortisoneCr]) AS CurFludrocortisone,
Trim([NF06-Scantest6].[MidodrineCr]) AS CurMidodrine,
Trim([NF06-Scantest6].[QuetiapineCr]) AS CurQuetiapine,
Trim([NF06-Scantest6].[CitalopramCr]) AS CurCitalopram,
Trim([NF06-Scantest6].[FlueoxetineCR]) AS CurFlueoxetine,
Trim([NF06-Scantest6].[FluvoxamineCr]) AS CurFluvoxamine,
Trim([NF06-Scantest6].[BenztropineCr]) AS CurBenztropine,
Trim([NF06-Scantest6].[PramipexoleCr]) AS CurPramipexole,
Trim([NF06-Scantest6].[SelegilineCr]) AS CurSelegiline,
Trim([NF06-Scantest6].[TrihexyphenidylCr]) AS CurTrihexyphenidy,
Trim([NF06-Scantest6].[ParoxetineCr]) AS CurParoxetine,
Trim([NF06-Scantest6].[SertralineCr]) AS CurSertraline,
Trim([NF06-Scantest6].[Levodopa-carbidopa-CRCr]) AS
[CurLevodopa-carbidopa-CR], Trim([NF06-Scantest6].[RopiniroleCr]) AS
CurRopinirole, Trim([NF06-Scantest6].[TolcaponeCr]) AS CurTolcapone,
Trim([NF06-Scantest6].[Levodopa-carbidopa-entacaponeCr]) AS
[CurLevodopa-carbidopa-entacapone],
Trim([NF06-Scantest6].[EntacaponeCr]) AS CurEntacapone,
Trim([NF06-Scantest6].[MemantineCr]) AS CurMemantine,
Trim([NF06-Scantest6].[RivastigmineCr]) AS CurRivastigmine,
Trim([NF06-Scantest6].[GalantamineCr]) AS CurGalantamine,
Trim([NF06-Scantest6].[DonepezilCr]) AS CurDonepezil,
[NF06-Scantest6].Other1Cr, [NF06-Scantest6].Other2Cr,
[NF06-Scantest6].Other3Cr,
[memory]+[VividDreamsHallucinations]+[Depressed] AS UPDRSI,
[Speach]+[Swallowing]+[Falling]+[Walking] AS UPDRSII,
[Dyskinesias]+[HowDisablinDyskinesias]+[pERIODOFDAYOFF] AS UPDRSIII,
[SleepProblems]+[LightheadedDizzy] AS UPDRSIV, [NF06-Scantest3].[EQ-5D]
INTO Visit
FROM ((((((([NF06-Scantest1] INNER JOIN [NF06-Scantest2] ON
([NF06-Scantest1].VisitDate = [NF06-Scantest2].VisitDate) AND
([NF06-Scantest1].SSN = [NF06-Scantest2].SSN)) INNER JOIN
[NF06-Scantest3] ON ([NF06-Scantest1].VisitDate =
[NF06-Scantest3].VisitDate) AND ([NF06-Scantest1].SSN =
[NF06-Scantest3].SSN)) INNER JOIN [NF06-Scantest4] ON
([NF06-Scantest1].VisitDate = [NF06-Scantest4].VisitDate) AND
([NF06-Scantest1].SSN = [NF06-Scantest4].SSN)) INNER JOIN
[NF06-Scantest5] ON ([NF06-Scantest1].VisitDate =
[NF06-Scantest5].VisitDate) AND ([NF06-Scantest1].SSN =
[NF06-Scantest5].SSN)) INNER JOIN [NF06-Scantest6] ON
([NF06-Scantest1].VisitDate = [NF06-Scantest6].VisitDate) AND
([NF06-Scantest1].SSN = [NF06-Scantest6].SSN)) INNER JOIN
[NF06-Scantest7] ON ([NF06-Scantest1].VisitDate =
[NF06-Scantest7].VisitDate) AND ([NF06-Scantest1].SSN =
[NF06-Scantest7].SSN)) INNER JOIN [NF06-Scantest8] ON
([NF06-Scantest1].VisitDate = [NF06-Scantest8].VisitDate) AND
([NF06-Scantest1].SSN = [NF06-Scantest8].SSN)) INNER JOIN
[NF06-Scantest9] ON ([NF06-Scantest1].VisitDate =
[NF06-Scantest9].VisitDate) AND ([NF06-Scantest1].SSN =
[NF06-Scantest9].SSN)
ORDER BY Trim([NF06-Scantest1].[SSN]);
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Table query not populating 3

Top