Update Query (Popular subject today!)

[AC5FF]

Lots of Update Query issues today.. So, let me throw another one into the mix.

Here's my update query:

UPDATE [Enterprise Repair Collaboration New Format] INNER JOIN [Enterprise Repair Status] ON [Enterprise Repair Collaboration New Format].LRU = [Enterprise Repair Status].LRU SET [Enterprise Repair Status].Contracted = [enterprise repair collaboration new format].quota
WHERE ((([Enterprise Repair Collaboration New Format].Month) Between DateSerial(Year(Date()),Month(Date()),1) And DateSerial(Year(Date()),Month(Date())+1,0)));

This works perfectly for what I have needed. I add new records at the beginning of each month to my [Enterprise Repair Collaboration New Format] table and this update query (along w/ a few others) fills out a temporary table with data for use in daily reports. Again; works like a champ!

Now I have been asked to add more information into the report. Instead of only listing items with quota data, I also want to list only certain other items that will not have quota data.

I originally thought that this would be simple. Since all I am doing is updating a table with data from another table - it shouldn't matter what was in the 'quota' field; as long as the item was listed w/the appropriate date value then if I enter in a quota of "0" it should work. ...

Well; since I am writing here it obviously did not work.

Can anyone see in my code above why items with a quota value of "0" would not update?

Thx!

 

[AC5FF]

I love this forum!

As I typed this I was thinking of other reasons this may not be working. Immediatly afterwards I looked at this from another angle and found my problem! This query above worked as required; the problem was in another update query that initially populated the temporary table... it had a condition of 'where quota>0' ....

This forum is just great - stimulates the mind into thinking of things that sometimes are just out of reach...