k table and currency question

[toddbingham]

I have a link table to a text file setup that contains a currency value (for example 163588) This dollar amount would actually be $1635.88

When it brings it over and I tell the database that the field is currency, it labels it as $163588.00

I cannot get around this. How can I force it to use the last 2 numbers as the cents??

Thanks.

 

[Mile-O]

Rather than base any forms or reports upon this table, use a query to sort the information from the linked table properly first.

You can then make a field:

NewField: CCur(Left([OldField], Len([OldField]) - 2))

 

[toddbingham]

Would this go in the criteria for that field.

 

[Mile-O]

No; it's a definition of a new field:

And I messed up the formula; it should be:

NewField: CCur(Left([MyMoney],Len([MyMoney])-2) & "." & Mid([MyMoney],Len([MyMoney])-1,2))

Look at the attachment:

 

[toddbingham]

Got it, thanks.

 

[toddbingham]

I do use an append query to append the data from the link file to the database. That is where i use the above code.
What does the code look like that you suggest?

Thanks.

 

[Mile-O]

[rhetorical question] Why do I always think in difficult terms? [/rhetorical question]