Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. brendanDATA

    greater than date

    I am trying to insert records where a field has a certain value AND the date is after 11/13/2004. When I run the query, it seems to ignore the DATE and just inserts all of the records where the other field has the certain value. The query currently looks like this: INSERT INTO New_table...
  2. brendanDATA

    If a data field has five characters...

    I am trying to insert data into a new table if the record has a five character zip code. It doesn't matter what the zip is, it just has to have five characters. I have the rest of the query, I just don't know what the where would look like to say where a field has five characters in it...

Part and Inventory Search

Back
Top