Rusty access query

[rkbisme]

Ok, well I've been trying to help someone else, once upon a time I use to be working with access a lot, but years have past so I'm rusty or just old. So here is the issue..seems simple. I have two tables that have a relationship...now the query is basic..I just need to get all the records from both table put into a single line...so what I have is partnumber and attribute in one table and part number and attribute in another table. so I just want to see one partnumber and both attribute numbers.

it would look like partnumber attribute


.................................xyz....... 10
............................................. .15

and so on.

I don't know why my mind isn't working but I've lost my logic hat. any help would be great. thanks in advance.

[ranman256]

Start a query design, add both tables,
link the 2 tables by grabbing a field from 1 table and drop it on top of the matching field in the 2nd table (the join)
bring down your fields to the grid you want to see
run

[rkbisme]

Start a query design, add both tables,
link the 2 tables by grabbing a field from 1 table and drop it on top of the matching field in the 2nd table (the join)
bring down your fields to the grid you want to see
run

..lol I'm not that rusty...ha. the query does what it should, however I need the data to either go into excel and only list the part number once in one column but all the attributes into a single column with as many rows that there are attributes.

[June7]

Exporting a table or query cannot suppress repetition. Try building a report using Grouping & Sorting features and export the report. Report in Print Preview, right click > Export > Excel.

[ssanfu]

I have two tables that have a relationship...now the query is basic..I just need to get all the records from both table put into a single line

If you want to have the "PartNumber" and the "Attribute" fields from both tables in a single line, you would add the "PartNumber" and the "Attribute" fields from both tables.
It would look like

  partnumber   attribute    partnumber     attribute
.....xyz........... 10..........xyz........... 15

If you want to have one "PartNumber" and one "Attribute" from BOTH tables, you would need to use a Union query.
It would look like

 partnumber     attribute
......abc.......... 13  (From Table1)
......abc......... .16  (From Table2)
......xyz.......... 10  (From Table1)
......xyz......... .15  (From Table2)

Then use a report for grouping.

Or you could use the (sorted) union query as the source and use VBA create a CSV file which could then be imported into Excel in your format.
Loop through the query, writing the first line with the "PartNumber" and "Attribute", then a line with only the "Attribute" until the "PartNumber" changes.

[rkbisme]

Great thanks everyone...I had thoughts in my head that I had to use a report to handle this, just after a 3 year hiatus I've forgotten a lot more than I care to admit and not being sure of yourself means a whole lot of second guessing..thanks for the bailout.