Linty Fresh
Registered User.
- Local time
- Today, 10:31
- Joined
- Mar 13, 2003
- Messages
- 20
Hi all
I'm running a query on street names, and I want to sort first by the name of the street and then by the number, which is in a string format. Because of the string format, I'm trying to use the val() function to sort it. My query looks like this:
SELECT Cases_interim.Case_Number, Cases_interim.Street_Number, Cases_interim.Street_Name, Cases_interim.Applicant, Cases_interim.Relief, Cases_interim.Result, Cases_interim.Comments
FROM Cases_interim
ORDER BY Cases_interim.Street_Name, Val([Street_Number]);
When I try to run this, I get a "Data type mismatch in criteria expression" error message, and it persists no matter what I try to do. Any ideas?
Many thanks
I'm running a query on street names, and I want to sort first by the name of the street and then by the number, which is in a string format. Because of the string format, I'm trying to use the val() function to sort it. My query looks like this:
SELECT Cases_interim.Case_Number, Cases_interim.Street_Number, Cases_interim.Street_Name, Cases_interim.Applicant, Cases_interim.Relief, Cases_interim.Result, Cases_interim.Comments
FROM Cases_interim
ORDER BY Cases_interim.Street_Name, Val([Street_Number]);
When I try to run this, I get a "Data type mismatch in criteria expression" error message, and it persists no matter what I try to do. Any ideas?
Many thanks