Summary Query

[dmenger]

Hi All,
No one seems to be able to answer my question. Please Help :banghead:

I have a query run that gives me a list of records that I view on a continuos form. What I want is to press a button and run a macro/Append Query to add a Single Summary record to another table.

For example my query spits out this data
Part # Quantity Serial Number
GO2 1 123
GO2 2 456
GO2 2 789

What I'm looking to get is
Part Number Total Quantity Serial Number 1 Serial Number 2 ..
GO2 5 123 456


I'm stuck on a couple of things.
1. Getting a new single row to append.
2. Getting Serial Numbers from several records to save on to a single record.

 

[Mihail]

No one seems to be able to answer my question

Because, in a well normalized database, is not necessary to do what you are asking for.

Upload the database (A2003 or 2007) and I'll try to help you.

 

[dmenger]

Well I'm open to other ideas, but I think this is what I need.

The function of the database is to track defective parts as they go through the process of rework. So parts come in at different times and quantities, but don't get touched until enough of them has accumulated to run a full load. Then they get grouped together by a case number and that case has to get approved by the customer. And each part may have actions assigned to it and the case record itself may have a list of action items that I want to track.

So this may be two databases in one. One to track parts and one to track the case records.

 

[Mihail]

Can't open (A2007)

 

[dmenger]

Can't Save it as 2003 file type, and doesn't give me the option to so 2007