Formula field

[vidplaylist]

I am using linked excel sheet as table in Ms Access.



The problem is that i want to create a field in query which tell me that a particular field has formula.

For example IF [amount] field has formula then "Calculated", "Manual".

[orange]

What happens when you display the field in a query?

[vidplaylist]

For example if [Amount] field has formula in excel sheet then query tell me that this amount field has formula

[orange]

Create a SELECT query against the table.

Display the Amount field in the query.

What values do you get?