473,386 Members | 1,758 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

problem with between function?

283 100+
Hello everyone,

I am having trouble with a query I have set up to check for a number range, but when you run the query which goes to a report the range is off by a lot.

To go in to more detail. I have a form set up with two text boxes. One for the start number and one for the end number. Then I have a button set up that runs a report printing out the records in the number range. For some reason when i do a number range starting with 1 - 9 and ending with any other number it pulls every record. But if i start with 10 and end with any number it works fine.

Any ideas or help with this would be greatly appreciated.

Thanks so much!
Nov 10 '10 #1
1 1079
TheSmileyCoder
2,322 Expert Mod 2GB
Is the field setup as numerical? I.e. its not simply numbers stored as text?

Post the SQL of the report (if that is where you reference your form, to perform the range selection)
Nov 11 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: melissa.lombard | last post by:
I would like to add dynamic text sizing to a website. There will be three text sizes. When the default is used, only the "Increase text size" button is shown. When the maximum size is used, only...
1
by: Faz | last post by:
i have a DB which allows users to allocate trainers to course sessions, they fill out date, start time , end time and other fields and when they click on the trainer field I have a pop up which...
14
by: digital | last post by:
hello anyone... pls explain me , how different between function and procedure for C/C++ and Pascal. Thankx......
3
by: Marc | last post by:
Hi, I am trying to serialize a data structure -- a list (of custom class) -- in one application, then read it in with another application. My serialize and deserialize subs are in a module that...
1
by: anuragshrivastava64 | last post by:
Like the Date Between Function , Is there any function or any procedure to find out whether the time entered falls between two time ranges
3
by: viki1967 | last post by:
Hi there. I have a problem with function updateSum(id). The code is this: <script language="javascript" type="text/javascript"> <!--
4
by: sunil samal | last post by:
What Is The Difference Between Function And Method
2
by: valvos007 | last post by:
Hi All, Can anyone please explain about difference between function pointers and pointers to function with an example?
3
by: JCM82 | last post by:
I have an SMS database that keeps track of any Safety Issues within the company. The query that I have now allows me to select all records for a certain month and year. What I want to be able to do...
1
by: bhavanik | last post by:
The Postgresql have stored procedures or not.If postgres contain stored procedures what is the difference between function and stored procedures in postgresql?
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.