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