How to write conditional statements in an ACCESS query is as follows - Plastic Surgery and Aesthetics Network

How to write conditional statements in an ACCESS query is as follows

dim rst as dao.recordset

set rst = currentdb . open recordset(" select * from table name where user id = " &； "User ID" if the user ID is an integer field.

set rst = currentdb . open recordset(" select * from table name where user ID = ' " & UserID & amp； If the user ID is a character field.

Related articles

What plants are suitable for growing in ponds?

My thumb on my right foot is very short. Can it be extended by surgery?

A helmet used to correct baby's head shape has become popular on the Internet. Can this helmet really correct the baby's head shape?

The process of making pottery pots

Nose clip after rhinoplasty

What kind of face is the differential cover suitable for?

What are the methods of reducing nose, nose and nose wing in plastic surgery?

How about Anhui Meixi International Medical Aesthetics Education College?

What movies can Leshan Hualian watch today? It's almost ten o'clock.

There is a kind of "plastic surgery" called star tooth replacement. Hugh or Hugh, but Tang Yan seems to have changed.