So I'm working with a database that requires a calculation. That's not a problem. The thing is the calculation is pulling data from different tables. I know one way to do it is just to write it out like this:
ExtendedAmount: Sum([Order Details]![Quantity]*[Products]![UnitPrice])
But I gotta think there's a better way, or maybe some good online resources showing how to do calculated fields that pull fields from different tables. Any suggestions? I got roped into teaching a class on this, and the pre-fab material they're using gave them a quiz that included the need to do this...and of course none of the prep material ever addressed even one time.