split currency / number

  • Thread starter Thread starter Kantor
  • Start date Start date
K

Kantor

Hello!
I am sorry but I have to place this question once more regarding the example
below. In my original question there were "seven spaces" between 1254 and 53.
When it was posted the server had minimized it to just one. NB! There shall
be a good bit of space between 1254 and 53 on the invoice.

Can anyone tell me how to split a currency or number?
I run a small company beside my regular job. I use access to generate
invoices. When my company grow bigger I will probably pay someone else for
this service, but for now, I need to handle this myself.

For the Invoices we have here in Norway printed sheets/forms. The
information in the invoice shall be placed out at particular places.
At the bottom I need access to give me the amount splitted - without the
currency symbol.
Example (NOK): Kr. 1254,53 Shall look like this: 1254 53
I have to add that this is not going to be used in further calculations. It
is only the total amount at the bottom of the invoice that shall fit into the
right places.
Can anyone tell me how to do that?
Best regards
Børge Sandal
 
Try this --
NOK: Int([CurrencyField]) & Space(7) & [CurrencyField] -
Int([CurrencyField])
 
Hello!
I am sorry but I have to place this question once more regarding the example
below. In my original question there were "seven spaces" between 1254 and 53.
When it was posted the server had minimized it to just one. NB! There shall
be a good bit of space between 1254 and 53 on the invoice.

Can anyone tell me how to split a currency or number?
I run a small company beside my regular job. I use access to generate
invoices. When my company grow bigger I will probably pay someone else for
this service, but for now, I need to handle this myself.

For the Invoices we have here in Norway printed sheets/forms. The
information in the invoice shall be placed out at particular places.
At the bottom I need access to give me the amount splitted - without the
currency symbol.
Example (NOK): Kr. 1254,53 Shall look like this: 1254 53
I have to add that this is not going to be used in further calculations. It
is only the total amount at the bottom of the invoice that shall fit into the
right places.
Can anyone tell me how to do that?
Best regards
Børge Sandal
Click to expand...

I would use 2 unbound controls for this.
As control source for the left hand control:
=Int([FieldName])

As Control source for the 2nd control:
=([[FieldName]-Int([FieldName]))*100
Set this control's Format property to
00

In both instances make sure the Name of the control is not
[FieldName].

Position these 2 controls where you would like to display it's value.
 
Beautilful :):)

Thanks

--
BS


fredg skrev:
Hello!
I am sorry but I have to place this question once more regarding the example
below. In my original question there were "seven spaces" between 1254 and 53.
When it was posted the server had minimized it to just one. NB! There shall
be a good bit of space between 1254 and 53 on the invoice.

Can anyone tell me how to split a currency or number?
I run a small company beside my regular job. I use access to generate
invoices. When my company grow bigger I will probably pay someone else for
this service, but for now, I need to handle this myself.

For the Invoices we have here in Norway printed sheets/forms. The
information in the invoice shall be placed out at particular places.
At the bottom I need access to give me the amount splitted - without the
currency symbol.
Example (NOK): Kr. 1254,53 Shall look like this: 1254 53
I have to add that this is not going to be used in further calculations. It
is only the total amount at the bottom of the invoice that shall fit into the
right places.
Can anyone tell me how to do that?
Best regards
Børge Sandal
Click to expand...

I would use 2 unbound controls for this.
As control source for the left hand control:
=Int([FieldName])

As Control source for the 2nd control:
=([[FieldName]-Int([FieldName]))*100
Set this control's Format property to
00

In both instances make sure the Name of the control is not
[FieldName].

Position these 2 controls where you would like to display it's value.
Click to expand...
 
Back
Top