Search results

Alas, this is a situation where the date is part of a narritive in a text field. And while the date appears in the same place, and I can extract it, if someone puts in say 3/12/200Q by accident, I have no way to account for it.

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...

Would I need to change that if I wanted to group that count by location? The query returns the number of days difference for each location The query I use to run the report (Admin1), uses this query (Narr_Days) along with others to house all the data I am using. I use that query in the...

I am not sure... I have about 1200 locations, and I only want the total number of records for each location where the Narr_Date is >2

I am using it in a report with about 5 others. The data comes from one query which has about 8 other queries on in it. I want the field on the report just to count the total for each location if it is greater than 2. I am trying to run it on the sub query that I have too, just to see if I can...

Data types Narr_Date is the result of a DateDiff, so I am assuming it is a number This is the field I am using. Narr_Date: (DateDiff("d",[case_d],CDate(Left(Mid([si_narr_t],InStr([si_narr_t]," ")+1),InStr(Mid([si_narr_t],InStr([si_narr_t]," ")+1)," ")-1))))

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...

Working This seems to have worked nice and clean. Much thanks

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...