When i put in the interval 3-4 it puts in mar-4???HELP

  • Thread starter Thread starter Guest
  • Start date Start date
i know that u have to do something to the 3-4 but i dont know what

Depends on the context. 3-4 is a valid date - March 4, just as 12-25
is Christmas Day.

If you want to search a numeric field for a range of values from 3 to
4 inclusive, the correct syntax is

BETWEEN 3 AND 4

Since you don't give ANY clues about what kind of field you're
searching, or what results you expect, I'm groping in the dark here a
bit...!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Excel Help with dates 2
Making Oxygen on Mars 4
Creating A Report using Pivoted Query 10
PowerPoint Help needed with VB 1
News Raspberry Pi 4 Released 9
INDEX MATCH SMALL 12
project progress 1

Back
Top