Query is not running in Macro

[horatiu00]

Hello guys, any idea why an update query is not running in macro but if i'm running it manually it works? is just one field that needs to be updated using and IIF formula.

Thank you in advance!!

 

[Joe4]

Can you show us what your Macro looks like (all the steps)?

 

[horatiu00]

Sure! Check below.

 

[Joe4]

Are any of the other queries running in this Macro also Update Queries?
Are those other ones working?

If they are, try creating a new query where you are just running this one Update Query, and see if that works.
If it does, then it may be the order of the queries you are running in your macro, that maybe it isn't finding anything at that point in time to update.

If that is the case, maybe try create a New Macro that runs ALL the steps up to that point, and stops there.
Then, go ahead and run that.
Now see if you can run your problem Update Query manually.

If not, inspect the query to see why the conditions are not being met (something in your other queries leading up to that point is probably changing the data in a way you may not be aware of).

 

[horatiu00]

I will try to split the macro. Thank you!

 

[Joe4]

Sounds good.

That is usually what I do when I have a big project with a lot of steps that is not working like I expect.
Break it down to smaller pieces and test it.
I often start of with just the first thing, and it that works, add in the next one, test it, etc.
Keep repeating those steps until you encounter the issue.

 

[horatiu00]

Yes. Is a big DB with a lot of steps and the query is not running for new added records.. I was thinking to use a calculated field to replace the query but i will try with the split first.