How do i do this?

[bekyed]

Hi,

How can i reduce all my products prices by 7% and then add 17.5% vat included in the price on the website?

Wayne.

[I-CC]

best route would be to open the database within Access and run a macro or auto job on it..

[bekyed]

how do i do this ?

Is there not a way in catalog to do this?

Wayne.

[pinbrook]

there is no way in actinic to do this.

Techno's solution is the only one...but if you don't know how to do it, you will need someones help!! and make sure you have taken a backup of the mdb file

[bekyed]

autojob

What is an autojob?

Please explain

Bek

[I-CC]

An Access query, which will find the parts you want to change and conduct the changes as per your query instruction.

You will need to get into queries within Access to do it.

[bekyed]

and then?

thanks,

can you talk me through it, so i do not make a mistake.

Oner question

Can we import the database back into cvatalog as we now have a copy.

Thanks bek.

[bekyed]

more

we are talking about percentages can access do this?

Prices reduced by 7%

Thanks.

Bek.

[bekyed]

Any developers

Please help with the above question if you can

Bek.

[bekyed]

can catalog workj with access 2000

The problem we are having is we are using 95 database
can we convert this to 2000 and still run ac tinicn 4 with no problems?

Bek.

[I-CC]

Yes, you can safely convert it to Access 2000, but as with everything, take a backup of the database first of all so that you have something to revert to.

Best thing with queries is to read the manual about how to do it as per your needs, or the help/wizards that come with access 2000.

best of luck.