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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional field selection

Status
Not open for further replies.
ceej

ceej

IS-IT--Management
Joined
Jun 20, 2001
Messages
46
Location
US
Is it possible to do something like this?

For i = 1 to 10

Qty = SalesPeriod(i)

Next i

Where the actual field names are SalesPeriod1, SalesPeriod2, etc.
 
Sort by date Sort by votes
You should be able to make a statement like this
For i = 1 to 10

Qty = SalesPeriod& totext(i)

Next i
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

D
  • Locked
  • Question Question
Dynamic field height in crosstab?
Replies
0
Views
170
doodledump
D
B
  • Locked
  • Question Question
Difference of a field between 2 variable dates
Replies
1
Views
625
hilfy
hilfy
socalvelo
  • Locked
  • Question Question
Extract Phone Numbers from Text Field
Replies
0
Views
714
socalvelo
socalvelo
inkbird01
  • Locked
  • Question Question
Filters > Record Selection for dates between
Replies
4
Views
868
pmax9999
pmax9999
Cpreston
  • Locked
  • Question Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
690
Cpreston
Cpreston

Part and Inventory Search

Sponsor

Back
Top