Create Calculated Fields in Access. Open Microsoft Access. Create a table or an existing table. Create a Query. To create a Query, go to the Create tab and click Query Design in the Queries group.

Select a field and drag it to the tabbed page. 3] Add other controls to the page. In Microsoft Access, there are a variety of controls that you can add to your forms, such as Textbox, Labels ...

I have tried a lot of different solutions I found on the web (event procedures, macros etc.) to this problem and am obviously missing something.Basically, in this DB, there is a form called Order ...