Question Calculation Fields?

[wazawak]

Is there any way to add calculation fields to a data display screen? I'd like to calculate the quarter from the month and the weeks extant between two dates, and then display this data with the relevant form/report/document.

 

[David Eagar]

Create a query to do the calculations and then use a form wizard using that query

 

[wazawak]

While puzzling about with calculations, I learned that you can create a calculation in a text box more or less the same way as you could in Excel. But this is limited to basic numeric calculations, ie [=5+5]. I'm still working on trying to use other cells (such as RegularRetail and PromotionalRetail) in the calculation. For some reason Access doesn't recognize the fields I enter. Does anybody know the correct format for this or what I ought to be doing? Or should I just give up and devote all my energy to puzzling through queries?

 

[Pat Hartman]

You won't need VBA to do the calculations you mentioned. Access has date functions that you can use. And when all else fails, there is always the Format() function.