create macro

[Mark]

Hi,
My problem is I have table name "db461aa2". This table
contain invoice details like "IC" field contains "I"
or "C" data, "Qty" field contains quantity of unit sold.
Currently this table shows positive qty for "I" and "C".
Actually if the field "IC" contains "C", the qty should be
negetive value. How can I change the positive value to
negetive value for "IC" field type "C" by RUN the macro. I
never created macro before. Pls guide me step by step.
Pls help.

Mark

 

[Howard Brody]

You're better off using an Update query.

You will need to be very careful as an Update query
updates all the records in your table meeting the
specified criteria...and if your criteria isn't right you
could change every record in your table!

My recommendation is to build a standard SELECT query and
make sure you get your criteria correct. It will also
tell you how many records you should be updating. Then
convert it to an Update query and run it. You will be
prompted "Access is about to update x-amount of records.
Are you sure you want to do this?". If the number of
records is right, then let 'er rip. If not, cancel the
process.

Use "C" as your criteria for the [IC] field and, on the
update line, try ([IC]*(-1))

Hope this helps!

Howard Brody

 

[Mark]

Thank You so much Howard,
That exactly what I want & it works fine. I don't know how
to create update query before this even after try to learn
but now I know already after get help from you. I created
the update query & works fine. Thank You once again for
your help.

This problem is solved.

Mark

-----Original Message-----
You're better off using an Update query.

You will need to be very careful as an Update query
updates all the records in your table meeting the
specified criteria...and if your criteria isn't right you
could change every record in your table!

My recommendation is to build a standard SELECT query and
make sure you get your criteria correct. It will also
tell you how many records you should be updating. Then
convert it to an Update query and run it. You will be
prompted "Access is about to update x-amount of records.
Are you sure you want to do this?". If the number of
records is right, then let 'er rip. If not, cancel the
process.

Use "C" as your criteria for the [IC] field and, on the
update line, try ([IC]*(-1))

Hope this helps!

Howard Brody

-----Original Message-----
Hi,
My problem is I have table name "db461aa2". This table
contain invoice details like "IC" field contains "I"
or "C" data, "Qty" field contains quantity of unit sold.
Currently this table shows positive qty for "I" and "C".
Actually if the field "IC" contains "C", the qty should be
negetive value. How can I change the positive value to
negetive value for "IC" field type "C" by RUN the macro. I
never created macro before. Pls guide me step by step.
Pls help.

Mark
.

.