We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Microsoft Access Query problems
timbim_2
Posts: 1,292 Forumite
in Techie Stuff
I have a query on an inventory like table which collects all fields that have the "Taken?" Yes/No field set to Yes, and the "Returned?" field set to No, to trace any items out on loan, which have been collected and not yet returned. If I have an item showing as out in the query, then I set the returned field in the original table to Yes, the query does not update, even if I enter design view and run it again, or press the refresh all button. If I add a new field to the original table, then refresh, the query updates. I also have a report from the query, if I change one of the yes/no's in the original table, the report will update on a refresh, but if I change that for two records, and then refresh, only one will update in the report.
Access 2007, if that helps.
Thanks.
Access 2007, if that helps.
Thanks.
Ubuntu is an ancient African word, meaning: 'I can't configure Debian'.
0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.1K Reduce Debt & Boost Income
- 455K Spending & Discounts
- 246.6K Work, Benefits & Business
- 602.9K Mortgages, Homes & Bills
- 178.1K Life & Family
- 260.6K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards