Editing Table data with a function?

[Guest]

I have been dropped in at the deep end on access- I think the reasoning was I can do excel vba... Looks like i'll be doing the bookshops in london tomorrow....

Anyway, I have a db that imports a txt file but the currency amounts in the import file are in cents/pence etc ie 100.00 pounds comes through as 10000 pence. When I go to retrieve the data later on through a query i want the data to be displayed with the decimal point

I think i'm guitly of thinking in xl when i say is it possible to add a column to the table following/during import that has a value of [IMPORT AMOUNT] / 100 to get the figures back to having the decimal

Any assistance would be appreciated, at least to get me going where I should be looking to achieve this before I buy a book

Thanks

 

[Douglas J. Steele]

No need to. Just add the computed field to your query that does the
calculation, and use the query wherever you would otherwise have used the
table.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

I have been dropped in at the deep end on access- I think the reasoning

was I can do excel vba... Looks like i'll be doing the bookshops in london
tomorrow.....

Anyway, I have a db that imports a txt file but the currency amounts in

the import file are in cents/pence etc ie 100.00 pounds comes through as
10000 pence. When I go to retrieve the data later on through a query i want
the data to be displayed with the decimal point.

I think i'm guitly of thinking in xl when i say is it possible to add a

column to the table following/during import that has a value of [IMPORT
AMOUNT] / 100 to get the figures back to having the decimal.

Any assistance would be appreciated, at least to get me going where I

should be looking to achieve this before I buy a book!

 

[Guest]

Never knew you could put a function on a query..... this is going to be a steep learning curve i fear

Cheers