Add selected data from a subform to another subform base on criteria

[calvinle]

Hi,

I am having trouble to figure how to do the query to group items together, and sum the cost of a the group field based on the selected item only.

I have a subform that has a list of all item and selection box.
I have a subform with a subform that list the selected item but in a group, mean no duplicated item.

The group item is based on:
[item_num][item_name][item_id] then sum the [item_cost].

Here I join the sample of the access:
View attachment AddItem.accdb

Hope someone can help. Thanks

 

[calvinle]

The database I am creating is huge and I cannot pull out the sample so i am creating this small sample which gives the same idea of my actual database.

The listing item are generated from our mainframe server and the user have to select the desire item to add to the member profile.

 

[calvinle]

Because the difference here is I want the query to update after the selection and not before the generation of item.

 

[calvinle]

There is no query because that is what I need to do? I tried the query wizard but it doesnt give me the result I wanted so I deleted it.

 

[calvinle]

In our database, we are creating a profile for each customer of their order. The items are generated via our mainframe server which result in a table (tblItem). Because the result generated from the server cannot be changed, thats how the IT programmed it, raw data. Usually, we will select each items that matches the id, name, and we sum the total amount into 1 line of record for the member. Then we will have to do the same for each item. I am trying to find a way to select all the item and add it to the subform 1 time and done.

Does this explain well?