Update multple records simultaneously

[radshar]

Hello

I'm creating a database where I have a set of data imported from excel.
There are various fields in this table. Each record represents a client, which contains a group number that they pertain to.
For example:

Name: Jane Doe
Group #: SD123
Group Status: Completed

Name: Jack Black
Group #: FP947
Group Status: Review Pending

Name: John Smith
Group #: SD123
Group Status: Completed

Name: Vanna White
Group #: BN638
Group Status: In-progress

(sorry I did not know how to properly display a table)


Instead of having to go to each client and change the group status. I want to be able to run a query for the Group# and Group status, and then update status for the group and have that status apply to every client in that group.

is that possible? do I need another table??

thank!

 

[pbaldy]

I would expect a "Groups" table, with fields for GroupNum (don't use spaces or symbols) and GroupStatus. The status is an attribute of the group, not the individual records. When the status changes, you change it once, not on all the individual records.

 

[radshar]

The group information is not managed separately. the excel file that is uploaded contains the group numbers and status'. That said, is there a way for me to create an append query, that will take the group numbers from my cumulative table an move them to this new Group table, so I can manage the status there.

I tried to create an append query and its not picking up any records...

I would expect a "Groups" table, with fields for GroupNum (don't use spaces or symbols) and GroupStatus. The status is an attribute of the group, not the individual records. When the status changes, you change it once, not on all the individual records.

 

[radshar]

I was able to figure out the appending sorry!
now im going to try what you've said above

 

[pbaldy]

Glad you got it to work.

 

[radshar]

Question...
is it possible to do a vlookup in a table field to grab from another table.

Glad you got it to work.

 

[pbaldy]

In a table, no. Normally you'd use a query that joins the data table with the groups table, enabling you to return fields from both.

 

[radshar]

Ok so what you said here below, was just that I should have the need to only update the status at the group level, correct?
However, there is a little more to all of this, I need to see the new status at the client level also, so once I update my group table with the new status, I need to be able to see the status in my cumulative table.

I would expect a "Groups" table, with fields for GroupNum (don't use spaces or symbols) and GroupStatus. The status is an attribute of the group, not the individual records. When the status changes, you change it once, not on all the individual records.

 

[pbaldy]

I need to be able to see the status in my cumulative table.

Why? Most of us never let users see tables or queries. You present data in forms or reports, and base them on a query that joins the tables together.