Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access database course - calculations access

Forum home » Delegate support and help forum » Microsoft Access Training and help » access database course - Calculations in Access

access database course - Calculations in Access

ResolvedVersion Standard

Maria has attended:
Access Introduction course

Calculations in Access

How do you transfer Excel calculations into an Access database

RE: Calculations in Access

Maria

You cannot transfer formulas from an Excel spreadsheet to Access.

However when you import an Excel table into Access the results of calculated cells are imported and stored in a field of an appropriate data type.

Regards

Carlos

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.