Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Access 2003 Query


  • Please log in to reply
2 replies to this topic

#1 jgreg32

jgreg32

  • Members
  • 46 posts
  • OFFLINE
  •  
  • Local time:01:44 PM

Posted 30 April 2006 - 05:18 PM

Anyone good with access 2003? Im stuck at one aspect of a a query I'm trying to make. Lets say you have a field labeld Cost and another labeled Paid. If Cost is $5 and Paid is $5 it should not display in my query, but if Cost is $10 and Paid is $5 I would like this to show when I go to data view instead of design view. Can anyone help? I can't seem to make it work with a simple cost>paid statment. I'm designing this in the design view.

BC AdBot (Login to Remove)

 


#2 Christopher83

Christopher83

  • Members
  • 16 posts
  • OFFLINE
  •  
  • Local time:02:44 PM

Posted 08 May 2006 - 06:57 PM

Are the Cost & Paid fields numeric? Wont work well if they are strings with symbols.

#3 tos226

tos226

    BleepIN--BleepOUT


  • Members
  • 1,568 posts
  • OFFLINE
  •  
  • Gender:Female
  • Location:LocalHost
  • Local time:02:44 PM

Posted 17 May 2006 - 10:01 PM

Design view looks like a table.
Underneath the field names you can write expressions on the same line (AND) or on different lines (OR).
Otherwise, do it in a formula writing window where you can select tables, fields and operators. Basically what you want to write would come looking something like NOT ([table.COST]<[table.PAID])
Use Access Help for details about formulas or expressions in a query. I can't recall how to get there, but I think double click on the criteria rows will get you there. If not, well, there's always the SQL window to write it in the hard way.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users