Help with Update statement
Posted on 2013-11-14
Hello, I have a table called tblMDRStatusReports where I first insert a row of zeros like this:
Insert into tblMDRStatusReports (QTYMDR, OpenMDR, ClosedMDR, MDRwRMA, MDRwShipperID, MDRSentToAccounting, MDRScrap) Select 0, 0, 0, 0, 0, 0, 0
I now want to come back and update the row with several update statements to populate the row with the correct data
For example I want to use the following statement to update the QTYMDR of the row previously inserted:
Update tblMDRStatusReports Set QTRMDR = ( SELECT COUNT(*) FROM [DMR Tracking] WHERE [Date Issued] between #07/22/2013# And #07/22/2013# And Supplier = 'LEPLM')
The first thing that occurs is that I'm asked to provide QTRMDR
Then I get the following error:
operation must use an updateable query.
What is wrong with my update statement. I just want to update the existing row with a count of rows that fall within where parameters.