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!

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

Help Please

Status
Not open for further replies.

LittleBeaner

Programmer
Dec 8, 2002
2
US
Help Me Please, I am doing a program in school and the program is running right but the 0 i need in it are not coming up on the sample.dat. Help me please.

Here is what i need to do.

I need to creat a sequential file on my disk with the following data.

Item Number Salesperson Price Units Sold Commission
Number Rate

001 3 1.10 100 .50
001 2 1.10 210 .50


When i find the file its coming up like this

1, 3, 1.1, 100, .5
This file must be interactive, the user should be asked to enter each field which it does and i do enter it but its not coming up the way it should.Please help me as soon as you can. i have been trying to figure it out but can't.
thanks Cindy
 

Don't confuse the way data is actually stored in the database table for the way you want it to look on the screen or in a report. The data is stored in the most efficient manner in the table but you are responsible for formatting the data to display to the user. Use the Format() function to manipulate the display characteristics:

Format(.5, ".00") ' displays .05
Format(1, "000") ' displays 001



Mark
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top