stevem

Please help. I am querying a database that has two datetime fields and other infomation. In the select statement I use the TIMEDIFF to calculate the difference and create a virtual field. When the dynamic table is displayed I then wish to calculate the average of the virtual time diff fields. the time diff field is in the HH:MM:SS format. Hope I have explained okay. Thanks

Just found the answer elsewhere on this site. Instead of using = in WHERE statement for all used LIKE and posted % for value in form.

Hi, New to this would appriciate some help. Using drop down list to select column from table. Can select either F for FULL or E for EMPTY. Would like third choice of A for ALL. When I select A it does not display any records from my recordset. not sure what I am doing wrong.