Honda-Acura.net

Notices
The Basement Non-Honda/Acura discussion. Content should be tasteful and "primetime" safe.

Anyone help with MS access?

Thread Tools
 
Old May 7, 2003 | 05:10 PM
Share
  #1  
ManInCamo's Avatar
ManInCamo
Thread Starter
Old School Crew
 
Joined: May 2000
Posts: 5,251
Likes: 0
Default Anyone help with MS access?
I'm trying to do a query, and specify some criteria.

its an account balance, and i need to show accounts greater to or = to $10000


what do i type in the criteria field to get that?

I tried:
>$10000
>=$10000
=$10000
=>$10000
>"$10000"
>="$10000"
="$10000"
=>"$10000"

each time i get "data type mismatch in criteria expression"
Reply
0
Old May 7, 2003 | 05:11 PM
Share
  #2  
flipped cracka's Avatar
flipped cracka
BOOM goes the dynamite!
 
Joined: Mar 2003
Posts: 27,571
Likes: 1
From: in a van down by the rive
Default
does the field actually have $ or is it just a number? if it's actually a number, you wouldn't want the $ (the $ might be just for display).
Reply
0
Old May 7, 2003 | 05:12 PM
Share
  #3  
flipped cracka's Avatar
flipped cracka
BOOM goes the dynamite!
 
Joined: Mar 2003
Posts: 27,571
Likes: 1
From: in a van down by the rive
Default
actually, it would have to be for display since $ is text, and you can't have something > text... only has to do with pure numbers.
Reply
0
Old May 7, 2003 | 05:14 PM
Share
  #4  
Nightshade's Avatar
Nightshade
un-Touch'd krew
 
Joined: May 2001
Posts: 51,774
Likes: 1
From: My own level of hell
Default
>1000

Isn't it??
__________________
"I'll keep my money, guns and freedom. You can keep the "Change."
Reply
0
Old May 7, 2003 | 05:19 PM
Share
  #5  
ManInCamo's Avatar
ManInCamo
Thread Starter
Old School Crew
 
Joined: May 2000
Posts: 5,251
Likes: 0
Default
gives me the same errors w/o the $
Reply
0
Old May 7, 2003 | 05:21 PM
Share
  #6  
Nightshade's Avatar
Nightshade
un-Touch'd krew
 
Joined: May 2001
Posts: 51,774
Likes: 1
From: My own level of hell
Default
Man its been a long time.

I can't remember anymore.

SUM= >10000 doesnt seem right either
__________________
"I'll keep my money, guns and freedom. You can keep the "Change."
Reply
0
Old May 7, 2003 | 05:21 PM
Share
  #7  
ManInCamo's Avatar
ManInCamo
Thread Starter
Old School Crew
 
Joined: May 2000
Posts: 5,251
Likes: 0
Default
started a new query from scratch... got it to work....


no clue what was up before.

Thanks for the help
Reply
0
Back to Subforum
The Basement
View Next Unread
My favorite new smilie is this one...




Advanced Search
Reply Closed Thread Share
Forum Jump

All times are GMT -8. The time now is 07:04 PM.