Search results for query: *

I have a key text field (created in Cache)i.e., 1||987, 2345||2, 567||24. What I want to extract are the number (characters) after the || pattern. So I want to return 987, 2, 24. A little help would be appreciated.

Okay, I got it, "the alias." This works to a T. Thanks very much PHV. I was beginning to tweak.

What does the M represent?

Thanks PHV for the effort but it returned nothing. I extrapolated from your offering as: SELECT CC_HazardLevel.Name, Main_FacilityType.Name, Main_Facility.Name, Main_Facility.Customer, Main_Facility.PrimaryAddress_Number, Main_Facility.PrimaryAddress_Street1, CC_Survey.FacilityData...

How would I rearrange or rewrite this query to perform the AdminSurvey filter before it grabs the Max Date between dates? As written, it Selects the Max Dates in the date range and then filters out the AdminSurvey and I loose data. What I want is to find all records that are not AdminSurveys and...

Thanks HiTechUser, All is fine now, Any ideas as to the cause? jim

I have DB created with Access 2000 and I am opening it with Access 2003. I am getting Visual Basic Error message: An error occurred while loading 'Form_Bose'. Do you want to continue loading the project? If I press no, I get the message repeated. If I press yes it goes away. This form no longer...