By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,831 Members | 1,024 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,831 IT Pros & Developers. It's quick & easy.

What is the destination field for a query

P: 1
I need help with setting up a query. I don't know what a destination field is?
3 Weeks Ago #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,327
Good Morning Arlinefrey,
The destination field is the field from the table that you are wanting to report the data from and may depend a bit on what you trying to do; however, for all of the Access query types the following basic concept applies...

For a simple select query
For example we have a table with the following design named "T_users"
[PrimaryKey]
[UserFirstName]
[UserFamilyName]
[UserServiceLevel]

and we want to return all the users with some given service level... say "Gold"

Then our destination field(s) might be
[PrimayKey]
[UserFamilyName]

in the access gui for the query we would show the table in the top section and drag the two fields to the bottom grid

The underlying SQL query would be
Expand|Select|Wrap|Line Numbers
  1. SELECT [PrimayKey], [UserFamilyName]
  2. FROM [t_Users]
  3. WHERE ([UserServiceLevel]="Gold");


-Z
3 Weeks Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.