Search results

I am using the following to extract date information from a text field as part of a query. Narrr_Date:CDate(Left(Mid([si_narr_t],Instr([si_narr_t]," ")+1), Instr(Mid([si_narr_t],Instr([si_narr_t]," ")+1)," ")-1)) Due to users not putting the correct information in I will get the #Error in the...

In reading examples of using DCount I am coming away confused. I have a query that gives me the number of days for a location. On the report i want to count how many each location has over 2 so in the Control Source for my report I have the following =DCount("Narr_Date","Narr_Days","Narr_Date...

I have a situation where I need to extract the date from a text field to use in a select query. The date in the text field is listed at the beginning of the text field like this. S12345678 3/21/2008 adittional text beyond here blah, blah... the first series of numbers can be either 9 or 10...