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

prevent multiple copies of the same field in a query

P: 1
I have created a simple database, which includes a receiving table and outgoing table in my receiving table I have a multiple entry of the same fields. I am trying to create a query that contains receiving table, which is adding the quantity of the same field and minus the outgoing table. The question I have is how can I prevent multiple copies of the same field in my inventory query.

Many thanks,

Aug 9 '06 #1
Share this Question
Share on Google+
3 Replies

P: 4
Try setting the query properties to unique record by right clicking in the upper frame (where your tables are shown) and select properties. Then set the Unique record to Yes.
Aug 9 '06 #2

Expert Mod 10K+
P: 14,534
As I understand it you have fields such as QTY1, QTY2, QTY3 in the receiving table and you want one field QTY adding the value in all the fields in the outgoing table. In the create table query create a column as follows:

QTY: [QTY1] + [QTY2] + [QTY3]

Does this help??
Aug 9 '06 #3

P: 179
I don't fully understand what you are asking. If none of the previous replies solved your problem, then can you please provide more detail. Also, include names of tables and fields (with PKs).

Aug 10 '06 #4

Post your reply

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