Forum home » Delegate support and help forum » Microsoft Access Training and help » If functions in Access 2007
|
|
|
The UK's most regular 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. |
If functions in Access 2007
Resolved · Low Priority · Version 2007
Reply Thu 23 Oct 2008, 17:21Delegate James said...
James has attended:
Access Intermediate course
If functions in Access 2007
Can I use an If function in a table (similar to Excel) or must I use a query and apend the results?
For upcoming training course dates see: Pricing & availability
RE: If functions in Access 2007
Hi James
Sorry for the delay in responding.
You cannot create any calculated fields or use functions directly into a table.
You need to create a query do the relavant calculations in it and if needed you can append the results back to the table or use the Make-Table query and create a new table
Hope this helps
Carlos
|