query parameter data types

The set of data types for a field in a parameter query. A Microsoft Access database has 14 query parameter data types.

Category Data type
Table fields Currency, Date/Time, Memo, OLE Object, Text, and Yes/No correspond to the same data types in table fields.
Number Byte, Single, Double, Integer, Long Integer, and Replication ID correspond to the five FieldSize property settings of the Number data type in table fields.
Generic Value is a Generic data type that will accept any type of data.
Binary Although not recognized by Access, you can use the Binary data type in parameter queries directed to linked tables that do recognize this data type.