G
Guest
Help. I have a simple query that displays selected fields for non delivered
items from a table of deliveries. We use julian dates stored as numbers and
times stored as text fields (I didn't create it this way, I inherited it).
The fields "Delivered Date" and "Delivered Time" are usually updated from a
handheld scanner device, but some items don't get scanned. "Delivered Date"
contains a zero and "Delivered Time" is empty until updated by the scanner
data.
I select records by using zero in the criteria for the "Delivered Date" and
want the users to manually enter a date and time for items that didn't get
scanned. The query looks good and shows the correct records, but I can't
enter any data from the keyboard, it just beeps when you press a key.
I can open the table and enter data, but can't enter it using the query.
items from a table of deliveries. We use julian dates stored as numbers and
times stored as text fields (I didn't create it this way, I inherited it).
The fields "Delivered Date" and "Delivered Time" are usually updated from a
handheld scanner device, but some items don't get scanned. "Delivered Date"
contains a zero and "Delivered Time" is empty until updated by the scanner
data.
I select records by using zero in the criteria for the "Delivered Date" and
want the users to manually enter a date and time for items that didn't get
scanned. The query looks good and shows the correct records, but I can't
enter any data from the keyboard, it just beeps when you press a key.
I can open the table and enter data, but can't enter it using the query.