field is based on an expression

[gprzytula]

in a library access app, when they return books, I run a query and add a field based on date() when the book is returned


It could happen that we register the return tomorrow and so can not update the datasheet
is there any possibility to return current date and have the possibility to modify it if needed
thanks for all help
best regards, Guy

[Micron]

Perhaps use parameter prompt in query criteria for date field [Enter Return Date]. However, user must provide a valid date in the correct format otherwise errors can occur, so easy but not ideal. If you are entering/editing records via forms as you should be, then the date field on your form could show a calendar when user clicks in it - then choose the date. The query updates the table date field to the date chosen.
Others might chime in with more ideas also.

[gprzytula]

yes if I do
select col1, [IN] from ... and IN is a date type in table and empty = we can modify using the calendar, but manual intervention is to be done

I wanted the empty field from table, already be filled by current date and be modifiable if needed

if I do
select col1,date() as [IN] current date is displayed, but I can not modify if I want to register the movement to a different date


Best Regards, Guy

[Gicu]

If that would be a new record you could set the default value to Date() (in the table). But looks like you are editing the records in a query which is (usually) not recommended. You cannot have what you want unless you use some sort of temporary table. So the best way would be to use a form (in datasheet view if you like that) using the your first example in post # 3 as the record source and add a textbox in the header to select the IN date along with a button to run the update.

Cheers,

[CJ_London]

Note that IN is a reserved word and should not be used for a field name. It is a sql keyword and may cause strange errors