[Arnel]

Need help converting the following MS Access query expression into DAL

EllapseMinutes: DateDiff("n",[EventDate]+[EventTime],[EndDate]+[EndTime])
RunTime: [EllapseMinutes]\60 & Format([EllapseMinutes] Mod 60,"\:00")

[admin]

You need to explain what kind of query (select, update, insert) you talking about.

[Arnel]

admin, on 13 March 2010 - 11:57 AM, said:

You need to explain what kind of query (select, update, insert) you talking about.

I modified the EVENTS template to include 2 new fields. The duration in minutes and another in hours format.

The field expressions above, work in Access 2003 both in the Select and Update query.

How is it done in DAL so that the field can be updated when the user exits the form? Can you please assist.

[admin]

Calculated fields cannot be updated. You can add them to SELECT SQL Query though.