Queries vs Look up tables

[jaf893]

In terms of calculations, searching etc are there anythings that you can do to a query that you can't do to a look up table?

 

[maxmangion]

if you're planning to have calculations in your database, you should use a query rather than a lookup table, because it is not ideal to store your calculations in a table field.

 

[Mile-O]

I query my look up tables and use the queries as a lookup - ergo it's a moot point.

 

[jaf893]

if you're planning to have calculations in your database, you should use a query rather than a lookup table, because it is not ideal to store your calculations in a table field.

There are going to be a lot of calculations so I will use a query
Does Access see the ouput of a query as being pretty much the same as a table? The reasons I ask is that for a lot of things such as reports it asks you to select a Table or a query.