By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,299 Members | 1,384 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,299 IT Pros & Developers. It's quick & easy.

Simple MS Access Update ... Wont Update

P: n/a
Hi,

For some reason, when I put this query in all it does is give me the
old value and doesn't subtract the value by 1. I'm not new to SQL but
this is quite odd.
UPDATE Rental_Line_Items SET Rental_Line_Items.Days_Left =
(Rental_Line_Items.Days_Left-1)
WHERE (((Rental_Line_Items.Returned_Date) Is Null));

Dec 6 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
nvm ... somehow the exact same query that didn't work 2 seconds ago ...
works now

thanks though

Dec 6 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.