CODEWITHSUNDEEP
sqlms-accessvba
santanu
santanu

Reputation: 5547

MSAccess use of special character


I have got a very strange problem.
In the earlier version of programm i have found the following statement inside a query.

table1!field1 > table2!Field2

I ma not able to understand the meaning of the ! sign here.
Can any one able to help me in this regard
thank you in advance

Upvotes: 0

Views: 122

Answers (1)

Arvo
Arvo

Reputation: 10570

! means default property with String parameter type in VB/VBA. Apparently Table object has default property Field("fieldname") and Field object has default property Value, thereby instead of table1.Field("field1").Value you can use shortcut notation table1!field1.

Upvotes: 3

Related Questions