add string and format decimal

[medic61]

Fairly new to Access 2000. I have a large database, I need to extract 5 fields from my products table. I then need to format them as to export to a .csv file to then upload to Froogle.

I need to add ie.

http://www.domain.com/store

in front of the image url field. This is need #1.

2. I need to format the price field, which is now 1995 to 19.95 How would I add the decimal 2 places in and not just add 00's to the end?

thanks!

 

[KenReay]

Hi

I need to add ie.

http://www.domain.com/store

in front of the image url field. This is need #1.

2. I need to format the price field, which is now 1995 to 19.95 How would I add the decimal 2 places in and not just add 00's to the end?

for point 2, make a query, include the coluns you want to export, for the Price, make it a calculated column eg MyPrice:CCur([Price]/100)

where [Price] is the name of the column in your table which holds the price

so do not understand your first point

Hope this helps

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[medic61]

I'll give your suggestion a try! Thanks.

To clarify the first point:
table: Products
Field: ImageURL

sample data /images/pic1.jpg

I need to add

http://www.domain.com/store

in front so that when I export as csv, it would show as:

http://www.domain.com/store/images/pic1.jpg

Would a trim command actually work even though I'm not trimming?

Thanks again.

 

[KenReay]

Hi

Why not just type it in?

OR if it applies to lots of records an update query

UPDATE MyTable SET MyCol = "

http://www.domain.com/store"

& [MyCol]

with a WHERE clause if required to limit the scopy of the update

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK