Search results for query: *

Thanks, i am pretty sure that this would work within Access as what you are suggesting is a stepping through each record. But i dont think InfoPath will accept that kind of thing, or at least not at a basic coding level. Thanks anyway

I am a little unsure where i need to put the SQL statement? How do i use an unbound form, and then be able to control what information is submitted? The SQL for my query is as folows UPDATE Table2 SET Table2.[Date] = DateDiff("d",[Date1],[Date2]); I am not sure if i cant use this as the default...

The DateDiff function doesnt work in InfoPath, i am not worried about normalisation. Can it still be done??

Cheers ok here is a little more detail, i have two date fields need to find the difference between the dates entered and automatically display the difference. I am running the front end in infopath so that is why the table has to autoupdate. Using the function DateDiff Thanks Stu

I have an InfoPath form which submits and recieves data from an access table. I want to do the calculations in Access, i am using a datediff function to calculate the number of days between two dates. I want to have the query run whenever data is written to the table? Any suggestions...

I have an InfoPath form which submits and recieves data from an access table. I want to do the calculations in Access, i am using a datediff function to calculate the number of days between two dates. I want to have the query run whenever data is written to the table? Any suggestions...

is there a way i can make a macro/query run whenever there is a data change in my table?

Im actually working in InfoPasth, I have two date pickers and need to record the difference between the two dates selected using Jscript or VB Please help

I would like to find the number of days, between two dates choosen by the user, using jscript or vbscript. thanks Stu