Mail Sorting Query

[NeoPa]

qryNearest is now working. YEAH!!!!

qryFirstSeminar and qrySeminar are showing a type mismatch. I wonder if for both it has to do with the Date and Time fields in the All_Seminars table. Here is the more of the metadata for the fields and a sample of the data.

Field Name Data Type Sample Data
Date Date/Time 11/21/2006
Time Text 11:00 AM

Let me know if this helps. Thanks......... .

So, the query fails when you apply it to a table with just this one record in it? That seems unlikely.
From my earlier post, it's important to find a (relatively small) dataset which fails. I'm guessing there's a record or two somewhere that doesn't follow format rules for the date or the time. If you can do that, and the database is self-contained, then you can PM me with your e-mail address (trawler proof preferably - '.'s or '@'s replaced by the words should do it) and I will e-mail you with mine. At this point you can e-mail me with a compressed version of your cut-down database. This will involve some work on your part too as I will expect non-relevant stuff to be removed before doing a Compact and Repair then compressing the results (Zip is fine as are various other types).

[NeoPa]

HANG FIRE!
Are you saying your date is a Date/Time but your Time is Text?
In fact, please go back to post #5 and repost your MetaData (in a [CODE] box) with all the info if you would. That would be simplest.
This could well help us to resolve this problem without all the other, more complicated, stuff.

[mkuberski]

Further Info:
It would be helpful if you could list your tables' metadata (Table name on top line followed by field names, types and PK/FK where indexed, one field per line).
This would just make it a whole lot easier to see what I'm working with.

Table Mailing List

ID - AutoNumber - PK
NameID - Text - FK
Item - Text - None
First Name - Text - None
Last Name - Text - None
Address 1 - Text - None
Address 2 - Text - None
City - Text - None
State - Text - None
Zip - Text - None
ZipPlus4 - Text - None
County Code - Text - FK
County Name - Text - None
Title code - Text - FK
Barcode - Text - FK
Keycode - Text - FK
Barcode Compressed - Text - None
Exact Age - Text - None

Table Proximity_Results
ProximityID - AutoNumber - PK
LocationID - Text - FK
NameID - Text - FK
Distance - Number - FK

Table All_Seminars
ID - AutoNumber - PK
Template - Text - None
LocationID - Number - FK
County - Text - None
GA Code - Text - FK
Phone Number - Text - None
Seminar Location - Text - None
Date - Date/Time - None
Time - Text - None
Address 1 - Text - None
City - Text - None
State - Text - None
Template - Text - None
Zip - Text - None
Field14 - Text - None
Field15 - Text - None
Max Capacity - Number - None

This is based on how Access imported this data. I can try reimporting the data and setting the seminar date and time fileds to date/time type manually.

[NeoPa]

This is based on how Access imported this data. I can try reimporting the data and setting the seminar date and time fileds to date/time type manually.

That shouldn't be necessary Mike. I can work with these.
This should actually be easier to work with (I was treating both as text fields) - it was just a surprise. I suppose it makes sense really but it blind-sided me.
As before, will have to work on this after work.

[NeoPa]

Try grabbing the first query (qrySeminar) again.
I've 'fixed' it so it should work now.
Let me know after you test it please.