Query always asks to enter ssn twice

[KrazyAngel]

I have a simple query that is prompting the user to enter the Social Security Number that they want to search on. After it is entered, the query prompts the user AGAIN for the number before it will show the results. HELP!!!! Our programer told me that this is a glitch with Access..... I am not sure if I should believe this.

 

[dcx693]

Can you post the SQL text of the query here? Or a jpg of the query in design view?

 

[KrazyAngel]

SELECT Table1.[Date Rep'd], Table1.[Entered by], Table1.Network, Table1.Local, Table1.[Last Name], Table1.[First Name], Table1.[Date in], Table1.[Date out], Table1.Provider, Table1.Charges, Table1.[Rep'd Amt], Table1.[Claim NO], Table1.[Patient Control No], Table1.State, Table1.TIN, Table1.UB92, Table1.HCFA, Table1.[Surg Ctr], Table1.[Adm Type], Table1.[Disch Type], Table1.SSNo, Table1.Sex, Table1.Birthdate, Table1.[Rev Code], Table1.[Rev Code Desc], Table1.[How long], Table1.[Actual charges], Table1.[Rev Code1], Table1.[Rev Code1 Desc], Table1.[How long1], Table1.[Actual charges1], Table1.[Rev Code2], Table1.[Rev Code2 Desc], Table1.[How long2], Table1.[Actual charges 2], Table1.[Rev Code3], Table1.[Rev Code3 Desc], Table1.[How long3], Table1.[Actual charges3], Table1.Savings, Table1.[% Disc], Table1.Method, Table1.LOS, Table1.Inpatient, Table1.SDS, Table1.DRG, Table1.[Adm Diag], Table1.[Prin Diag], Table1.[68 Code], Table1.[69 Code], Table1.[70 Code], Table1.[71 Code], Table1.[72 Code], Table1.[Principal Proc], Table1.[81 Proc], Table1.[82 Proc], Table1.[83 Proc], Table1.[84 Proc], Table1.[85 Proc], Table1.[Attending ID], Table1.[Attending Physician], Table1.Notes, Table1.[Date Rec'd], Table1.[Date Entered], Table1.[WA date sent to], Table1.[WA network sent to], Table1.[WA date 1 follow up], Table1.[WA date 2 follow up], Table1.[Determined non-par], Table1.[WA determined non par], Table1.[WA date received back], Table1.Other, Table1.[WA received back], Table1.[WA info entered by]
FROM Table1
WHERE (((Table1.SSNo)=[Enter SS No ]))
ORDER BY Table1.[Last Name];

 

[KrazyAngel]

This query actually runs off of a button on a form.

 

[GumbyD]

Did you enter the "Enter SS No " into the parameters windows on the design view of the query? If the characters and spacing are not identical it will prompt for the parameter entry and the entry in the body of the query.

GumbyD

 

[dcx693]

It looks like you've got a trailing space in your prompt for the SSN:
[Enter SS No ]
As GumbyD pointed out, if you then place "Enter SS No" in your parameters list I think you'll get prompted twice if the labels don't match up exactly.

Pat, I'm curious, why do queries sometimes need to run twice to produce reports?

 

[GumbyD]

Looking again at the SQL - there are no parameter values specified in the SQL statement. Try coping the SQL into a new query and see if the double prompt still occurs.

GumbyD

 

[KrazyAngel]

Thank you all for your help. I will try your suggestions and let you know if they work.

 

[dcx693]

Aha. I didn't think that Access would re-run the query in that case. I thought it would perhaps format the report twice (once for the total # of pages, then once again for each individual page).