Qry Assistance Please

[buck]

I have 3 separate queries . . . source is primary table. Each query has a parameter set for Status, L1, L2, or L3.



At the beginning of the new month, we change all status values to send out second and third reminders. The current process is to run each query and manually type the update from L3 to Loss, L2 to L3, and L1 to L2 so it updates the primary table.

Is there a way to accomplish this without having to manually type the updates?

Thanks for your help.

[ItsMe]

....
Is there a way to accomplish this without having to manually type the updates?

Thanks for your help.

Calculate the updates at the time they are needed and don't try to store calculated values???

[buck]

not sure what you are saying

[ItsMe]

It is not real clear to me why and what you are updating. Why do you need to transfer information from one table/field to another? What event takes place that you need to update a field to "Loss"? Is this event something that happens inside the DB that can trigger an event handler or function?

It seems that you have fields in a table populated with historical data. This data then goes through some sort of transition. The result of the transition is stored in another table/field. Is this a calculation? If the historical data does not change, why not apply a formula and use variables to represent the parts that do change. There probably is not any need to store the result.

[buck]

Why I need to update isn't relevent to my request for assistance. I need to know if there is a way to construct a query that will look at a field and if it contains specific values, change it to another designated value. If not possible, I'll work through it.

Regards

[orange]

If you are sending out reminders, what exactly happens if a recipient responds to a reminder between say L1 and L2. Surely you don't keep sending reminders after someone has responded positively.
I think there is a part of your process that you haven't mentioned.

As for your specific question--- paraphrased --- can I change the status of a record from L1 to L2--Yes.

Update MyTable Set Status = "L2" where status ="L1";

Good luck

[buck]

is this applied in the query itself or VBA or ???

Update MyTable Set Status = "L2" where status ="L1";

[orange]

This is the query SQL. Change the name MyTable to the name of your table (and the field name if it isn't Status)

This query will update the status field to L2 wherever the current status is L1--- Is that what you want?
Update queries, like Delete queries, are quite unforgiving. Maybe a good idea to backup your table before applying the update.

[buck]

ok thanks.