PDA

View Full Version : How do i do this?

bekyed
03-Jul-2003, 03:55 PM
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
03-Jul-2003, 06:19 PM
best route would be to open the database within Access and run a macro or auto job on it..
bekyed
03-Jul-2003, 07:37 PM
how do i do this ?

Is there not a way in catalog to do this?

Wayne.
pinbrook
03-Jul-2003, 09:39 PM
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
09-Jul-2003, 04:53 PM
What is an autojob?

Please explain

Bek
I-CC
09-Jul-2003, 05:05 PM
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
09-Jul-2003, 05:12 PM
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
09-Jul-2003, 05:13 PM
we are talking about percentages can access do this?

Prices reduced by 7%

Thanks.

Bek.
bekyed
09-Jul-2003, 05:43 PM
Please help with the above question if you can

Bek.
bekyed
09-Jul-2003, 06:08 PM
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
09-Jul-2003, 06:12 PM
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.