Author Topic: can anybody here use microsoft access?  (Read 1471 times)

0 Members and 1 Guest are viewing this topic.

Offline KNG P1N

  • humpin ya mumma since '85
  • post whore
  • *****
  • Posts: 2243
  • Karma: +42/-10
  • Gender: Male
  • dont hate the player.....hate the game
can anybody here use microsoft access?
« on: Mar 10, 2004, 01:37PM »
hey, i really need help with this assignment for uni.
query: have a whole table of info , name dob etc etc, i just need to make a query that shows only ppl who are 30 or older. in the criteria section its easy to make it show ppl who are younger eg: >=#1/1/74#   so i assumed it would be as simple as changing the > to <, but it isnt working. anyone her know wat im on about???????????????????????
And there's not much I can say
But we miss you every day
And I'm bitter 'cause it's unfair
We'll be drinkin' in the sun
Playing music having fun
Cause one day I'll see you there
R.I.P, M.M 1984 - 2005


Offline RichTRX

  • sth. oz local moderator
  • post whore
  • *****
  • Posts: 3798
  • Karma: +38/-17
  • Gender: Male
  • May the 4's be with you.
Re: can anybody here use microsoft access?
« Reply #1 on: Mar 11, 2004, 10:51AM »
err I used access in Info Systems last year but I do programming in 2 languages as well so I'm assuming 30 or older means

>= 30 ??

Probably won't help much, but try it anyway.
His: 2001 Audi S4 biturbo quattro 6sp, Nogaro Blue/black leather recaros, microsilver trim, bose 10sp, SSAC 2.5" twin turboback, RS4 rear sway, 25% tint

Hers: MY99.5 Audi A4 1.8T Quattro GP Edition AVANT 5-sp, phantom black, black leather buckets/walnut/sunroof, 2.5" D&T Turboback, K04-015, N75J, 710N DV

Bro driving: 1990 Nissan Pintara TRX 5sp Red, 16" Rozzis, Lukey 4-2-1 ext, 2.5" full exhaust, hi-flow cat, cone cai, stg 3 chip,  low Kings, GT Gas shocks, Urethane bushings, slotted front rotors, 398000k and still going strong; 0-100 in around 7.2-7.4 seconds

Offline KNG P1N

  • humpin ya mumma since '85
  • post whore
  • *****
  • Posts: 2243
  • Karma: +42/-10
  • Gender: Male
  • dont hate the player.....hate the game
Re: can anybody here use microsoft access?
« Reply #2 on: Mar 12, 2004, 01:04PM »
ill giv it a go, cheers
And there's not much I can say
But we miss you every day
And I'm bitter 'cause it's unfair
We'll be drinkin' in the sun
Playing music having fun
Cause one day I'll see you there
R.I.P, M.M 1984 - 2005