Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-18-2012, 11:28 AM   #1
Tango
DB/Application Dev Newbie
 
Join Date: Jun 2011
Location: Sumter, South Carolina
Posts: 141
Thanks: 27
Thanked 1 Time in 1 Post
Tango is on a distinguished road
Form textbox (percent) as query criteria?

I have a query that returns a percentage in one column. I have an open form with a text box that has a format set to percent and for some reason when I set the query criteria to point to the open form field using a >= it just ignores it.


The criteria I am trying to use is as follows.
>=[Forms]![Start Page]![text377]

Unfortunetly my query results return full records as if EVERYTHING matched that criteria.

The form field I set a value of 75 to test it but I am getting records back that read everything from 0% to 100%

Anyone have a pointer?

__________________
---------------
If I helped you, please click thanks or the balance scales on my post.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Tango is offline   Reply With Quote
Old 12-19-2012, 03:59 AM   #2
Tango
DB/Application Dev Newbie
 
Join Date: Jun 2011
Location: Sumter, South Carolina
Posts: 141
Thanks: 27
Thanked 1 Time in 1 Post
Tango is on a distinguished road
Re: Form textbox (percent) as query criteria?

Ok, I solved it myself. I had to keep the data type for both fields as a "Fixed" data type. I converted it to a percentage in a 2nd query after the filter operation was complete.
__________________
---------------
If I helped you, please click thanks or the balance scales on my post.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Tango is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Query criteria (empty form textbox) KenP Queries 2 10-17-2010 11:45 AM
Query Criteria from Form textbox not working. Ideas? Vigilante001 Modules & VBA 2 12-28-2009 08:46 AM
Textbox with percent and null values odrap Modules & VBA 2 03-04-2009 11:45 AM
textbox as criteria for query Batten Modules & VBA 4 11-18-2008 09:28 PM
[SOLVED] Enter Query Criteria In Form textbox DeltaT Forms 1 01-21-2004 09:55 AM




All times are GMT -8. The time now is 05:24 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World