2. ASPRunnerPro General questions
  3. Access query expression to DAL
This topic is locked

Access query expression to DAL

 		3/12/2010 03:53:56
ASPRunnerPro General questions
A
 agruspe author

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")
Sergey Kornilov admin 3/12/2010

You need to explain what kind of query (select, update, insert) you talking about.
A
 		agruspe author 3/18/2010



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.
Sergey Kornilov admin 3/19/2010

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