Question Having column only show up once in query (1 Viewer)

kloot1rr · Jun 10, 2015

Hello fellow programmers,

I just started my internship a couple weeks ago so I am still relatively new, but here's my problem...I have created a query to run the weekly statistics for my data but one column continues to show multiple times. I want the "Left in Estock" and "Left in Estock Line Items" to only show once, instead of all the way down the side. Check out the attachments. It is probably a very easy fix, but hey I'm learning.

Thanks in advance.

bob fitz · Jun 10, 2015

You don't appear to have any relationship between the two tables in your query?

kloot1rr · Jun 10, 2015

Hey Bob,

Thanks for replying first off. Secondly, when I make a connection between the 2 Date fields from both tables (include ALL records from "Master Estock Report" and only those records from "Left in Estock Totals" where the joined fields are equal) I lose the final two Estock statistics. To make my data work previously I used an append query for "Left in Estock" and "Left in Estock Line Items" to append to the Master data table. Would it be wise to make another append query on top of the query I am making?

Thanks for your help.

JHB · Jun 10, 2015

Show some data from both tables and which result you want to get, (show it, don't describe it)!

kloot1rr · Jun 10, 2015

Pic 52 is what I have, Pic 54 is what I want

JHB · Jun 10, 2015

Sorry, but I don't think you can get that in a query!
Yeah okay - maybe if you use a union query.

kloot1rr · Jun 11, 2015

How do I go about that? I have never used a union query.

sk84gtspd · Jun 11, 2015

I may be misunderstanding what you asking to do kloot1rr.

Would a RIGHT JOIN (all the rows from one table and only the rows from another table that are joined ON a field where they are equal) be appropriate for what you are trying to do?

If that works you could you the Query Designer to set the join properties between the two tables to simplify the process.

If you need more details about my suggestion let me know

JHB · Jun 11, 2015

I have made a description in the attached file.

sk84gtspd · Jun 11, 2015

That was helpful for me JHB I hope it works for kloot1rr

kloot1rr · Jun 12, 2015

Very descriptive - thank you JHB

JHB · Jun 12, 2015

You're both welcome, good luck.

Question Having column only show up once in query (1 Viewer)

kloot1rr

Registered User.

Attachments

bob fitz

AWF VIP

kloot1rr

Registered User.

JHB

Have been here a while

kloot1rr

Registered User.

Attachments

JHB

Have been here a while

kloot1rr

Registered User.

sk84gtspd

Registered User.

JHB

Have been here a while

Attachments

sk84gtspd

Registered User.

kloot1rr

Registered User.

JHB

Have been here a while

Similar threads

Users who are viewing this thread