Adodc, Access Qry and round 
Author Message
 Adodc, Access Qry and round

Can anyone tell me, how can I use a Access Qry in a VB6 Adodc, or use the
Round function in VB6.

...
IIf([SCEmpTxJurosMora]>0,[SCEmpTxJurosMora],[SCContTxJurosMora]) AS [Taxa
Juro], Round(([Valor Divida]*([taxa juro]/100)/12),0) AS [Valor Calculado]
FROM SCEmpresa, SCClientes ...

Regards
Joao



Wed, 30 Jul 2003 00:53:14 GMT  
 Adodc, Access Qry and round
.....vc brasileiro?



Quote:
> Can anyone tell me, how can I use a Access Qry in a VB6 Adodc, or use the
> Round function in VB6.

> ...
> IIf([SCEmpTxJurosMora]>0,[SCEmpTxJurosMora],[SCContTxJurosMora]) AS [Taxa
> Juro], Round(([Valor Divida]*([taxa juro]/100)/12),0) AS [Valor Calculado]
> FROM SCEmpresa, SCClientes ...

> Regards
> Joao



Wed, 30 Jul 2003 01:20:21 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Append Qry In Access 2000

2. can you use an access qry with CR?

3. Round buttons round forms

4. How can i use INDEX in ADODC - Como usar indices em ADODC

5. ROUND function missing in Access 97???

6. Access 97 and converting to integer (rounding function)....

7. Rounding to two decimal places (Access 97)

8. Rounding problems with Access

9. Access vs. Netware 4 (seconds out, round one)

10. Rounding in Access - problems - Very Urgent !

11. Access Rounding!

12. round up currencies in Access

 

 
Powered by phpBB® Forum Software