98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » If functions in Access 2007
If functions in Access 2007
Resolved · Low Priority · Version 2007
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?
Mon 10 Nov 2008, 16:47Trainer Carlos said...
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
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:Combo box for finding recordsYou can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it |
