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

Formating numbers

Status
Not open for further replies.

Frank336

MIS
Aug 6, 2002
41
CA

Hi, (VB6, CR8.5(RDC), Access 2000)

I want to format numbers so i dont have decimal after the period.

Something like this :

3/4 instead of 3.0/4.0

The formula I use is :

Count ({ado.ID}, {ado.Group1}) & "/" & {ado.Nb_Members}


How can I do that ?


Thanks,
Frank

 

I found the answer...

cstr(Count({ado.Matricule}, {ado.Nom_Comite}), 0) & "/" & cstr({ado.Nb_Membres},0)


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top