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 Mike Lewis 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
Jun 20, 2001
46
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

socalvelo
  • Locked
  • Question
Extract Phone Numbers from Text Field
Replies
0
Views
171
socalvelo
socalvelo
inkbird01
  • Locked
  • Question
Filters > Record Selection for dates between
Replies
4
Views
222
pmax9999
pmax9999
Cpreston
  • Locked
  • Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
183
Cpreston
Cpreston
SarahSCPDAdmin
  • Locked
  • Question
Can I format data in a memo field? 1
Replies
5
Views
212
SarahSCPDAdmin
SarahSCPDAdmin
jchewsmith
  • Locked
  • Question
Formatting an embedded field in Crystal 2016 Support Pack 5 1
Replies
3
Views
190
BobSuruncle
BobSuruncle

Part and Inventory Search

Sponsor

Back
Top