98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Acess
Acess
Resolved · Urgent Priority · Version 2007
Melissa has attended:
Access Introduction course
Acess
If you base a query on a form, and you change the query why does it not reflect in the form? How can this be done?
RE: Queries and Forms updating
Dear Melissa
Thank you for attending Access Introduction course. I hope you enjoyed the course and found it useful.
You can create a query from existing tables or queries but not from Forms. You can create a form from existing tables or Queries. Please remember that Forms are just a pleasant way of viewing and entering your data. It is mainly used for Screen Input purposes.
If you create a query from a table and then decide to create a form based on that Query you will get all the records that meet the specific criteria in that query. If you, however, change the criteria in the original query and reopen the Form the No. of records will automatically be updated.
I have uploaded an Access file. Please note that I have create a Query called
Attached files...
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:DsumYou can create percentage values based on individual products / items by using a Dsum function (used with a grouped query) |