Web Development

Ask something
Question Locked

Creating a Query

0 helpful
5 replies

by cjones

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have created a query but when I print a report from the query, one of the field is pulling the primary key as the info instead of the name of the site, which is what I want. How do I create the query to pull the name of the site and not the primary key it is tied to?

5 replies

by sgt_shultz

just uncheck the box to 'hide' the primary key field (leave it in the query, just uncheck the box). sounds like your site name is not in the query at this time? so add it to the query in Design view using the Field list icon...is this what you wanted? I am sorry, I cannot figure out exactly what you want. have you downloaded the sample forms and databases from www.microsoft.com/download
Check them out.

by cjones

The query gives the information I want. I didn't state the problem clear enough. The query itself is actually fine, but when I go to run a report off the query...instead of listing the information supplied in the query i.e. division numbers, site names etc. it gives me the primary keys of the divion numbers and site names instead of the actual division numbers and site names. It's very frustrating and I cannot for the life of me figure it out.

by cjones

Yeah, I don't know how to do that and make the data readable. I guess I'm of luck until I figure it out.

This discussion is closed to new replies.