Access query criteria question

[marylipscomb]

I am going over code that I am now responsible for but did not write. Can someone tell me what this means? Thank you so much

Also this is on a query, criteria.

Like "*" & [Forms]![Switchboard]![county] & "*"

What does ! mean in this and the & sign mean in this..

[Rabbit]

Like is an operator telling it the SQL engine to return all records that match a text expression. The asterisk "*" means any number of characters.

Andy
Randy
Sandy
Andyn

Like "*Andy" will return all records except the last.

The ampersand & operator is a string concatenation operator.

"*" & "Andy" & "*" will return "*Andy*"

The exclamation mark ! operator access properties/objects of the originating object.

Forms!Form1!txtbox1 means from all the form objects, goto the object named Form1, on form one, return the value of txtbox1.

[marylipscomb]

Like is an operator telling it the SQL engine to return all records that match a text expression. The asterisk "*" means any number of characters.

Andy
Randy
Sandy
Andyn

Like "*Andy" will return all records except the last.

The ampersand & operator is a string concatenation operator.

"*" & "Andy" & "*" will return "*Andy*"

The exclamation mark ! operator access properties/objects of the originating object.

Forms!Form1!txtbox1 means from all the form objects, goto the object named Form1, on form one, return the value of txtbox1.

Thank you so much. Makes perfect sense!!!

[Rabbit]

Good luck.