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".

[animaimmortale]

syntax for the if statement would be,

IIF([amount] = "YOUR CRITERION","Calculated","Manual")

IIF([Field Name] = Criterion, Then do, Else)

If it is just one formula then input the formula where it says your criterion. If there are multiple formulas try:

IIF([amount] Like "=*", "Calculated", "Manual")

For more info see
http://www.access-programmers.co.uk/...291#post471291