Modify data using a query

[mattcdse]

Hi all,

Is it possible to modify data using a query.

Say for instance I have a whole load of IP's in a table in the form of A.B.C.*, where and and B are fixed, C varies slightly and * can be anything from 1-255. Can I use a query to look at an IP and the append an IP record to a different table in the form of A.B.C.0. Basically, modifying the data so that whatever the value of *, it is changed to 0.

Cheets,

Matt

 

[maxmangion]

if you change the data in your query, this will automatically reflect the change in your table, as the query is simply a view to your data.

 

[mattcdse]

Ay??