Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

group variabel

Status
Not open for further replies.
Jeff98

Jeff98

Programmer
Oct 19, 2006
14
US
I have an Access table t1 which has a colum income, I want to create a new column group based on income.

0<income<10000 1
10000<income<20000 2
20000<income<30000 3
30000<income<40000 4
......
how can I do it wiht sql or vba?

ThX


 
Status
Not open for further replies.

Similar threads

feipezi
  • Locked
  • Question
How to detect dups and/or sum by group?
Replies
1
Views
350
Andrzejek
Andrzejek
remeng
  • Locked
  • Question
Excel VBA - User name in group
Replies
1
Views
214
RobertPhillips
RobertPhillips
jchewsmith
  • Locked
  • Question
export from multiple (or one grouped) crystal reports into an excel file on separate sheets 1
Replies
10
Views
299
jchewsmith
jchewsmith
feipezi
  • Locked
  • Question
How to make a thin underline by each group of values? 5
Replies
7
Views
115
SkipVought
S
mcelligott
  • Locked
  • Question
Selecting a Group Box Frame
Replies
8
Views
127
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top