Question Having column only show up once in query

[kloot1rr]

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]

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

 

[kloot1rr]

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]

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

 

[kloot1rr]

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

 

[JHB]

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

 

[kloot1rr]

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

 

[sk84gtspd]

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]

I have made a description in the attached file.

 

[sk84gtspd]

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

 

[kloot1rr]

Very descriptive - thank you JHB

 

[JHB]

You're both welcome, good luck.