I can't edit a field's value in a query

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Is your table an Access table? What is the SQL view of your query? Are all
joins based on a primary and foreign key?
 
Thanks!
It is an Access 2000 table. I set a primary key on the linked table (I'm
not looking at all rows, just ones that match a specific list of part numbers
stored in another table) and now it works fine.
 
Back
Top