Deleting Dates with criteria!

[Martian262002]

Hola everyone!

I need to know how to delete dates using the criteria field in an delete query!
This is how the table looks:

Field1
Smith, Mike J
09/26/2005
11/16/2005

The date range is wide, so doing a between is not a good option.

Field1 is filled with information like the above. How do I delete the record with the dates from this field? I tried using a Like, but was unsure on how to represent the (2 spaces/) the 1st three characters.

Can anyone help????

!Mucho Gracias! In Advance!

 

[Vassago]

Do any of the fields you want to keep have a "/" in them? If not, do this:

"*/*" to delete all values with a "/" anywhere in the field.

HTH

 

[raskew]

Hi -

Are we reading this correctly? You have a field that may contain either a name or a string representation of a date? If so, would have to say that that's just not going to fly. Need to reconsider proper table structure.

Bob

 

[Vassago]

Hi -

Are we reading this correctly? You have a field that may contain either a name or a string representation of a date? If so, would have to say that that's just not going to fly. Need to reconsider proper table structure.

Bob

I gathered that was the problem. He probably imported a spreadsheet or something that was in that format and now is trying to piece it apart.