help with parameter queries - code added

[Christine Brandel]

The code for the query I have written is:

SELECT
[dbo.census].[FacilityCode],[dbo_census].[Facility],[dbo_census].[LastNa
me],[dbo_census].[SSN]
FROM dbo_census
WHERE ((([dbo_census].[FacilityCode])=[Please Enter Facility Code])));
That code results in the parameter value request being made twice before
the information I want shows up in the datasheet view.

I wrote the query originally using the Design view rather than in SQL as
I don't know as much about that. The SQL is what shows when I switch to
the SQL view.
Thanks!
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Mike Krous]

<snip>

[dbo.census].[FacilityCode], </snip>

is [dbo.census] correct? Looks like it should be [dbo_census]....do you
have two tables? or just one?

Have you tried MGFosters idea? I think theres some merit to his suggestion.
P.S. Its probably not a good idea to post responses to threads as new
threads....this should have simply been a response to my request for the
query code in your original thread "help with parameter value queries" on
11/28/03 :) just a suggestion.

HTH

Mike Krous

"Christine Brandel" <le********@comcast.net> wrote in message
news:3f***********************@news.frii.net...
The code for the query I have written is:

SELECT
[dbo.census].[FacilityCode],[dbo_census].[Facility],[dbo_census].[LastNa
me],[dbo_census].[SSN]
FROM dbo_census
WHERE ((([dbo_census].[FacilityCode])=[Please Enter Facility Code])));
That code results in the parameter value request being made twice before
the information I want shows up in the datasheet view.

I wrote the query originally using the Design view rather than in SQL as
I don't know as much about that. The SQL is what shows when I switch to
the SQL view.
Thanks!
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Christine Brandel]

Thanks, MGFoster's idea DID work, and I was very happy about that.
Thanks for all your help. It's all working fine now.

Christine
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!