create record with a query in the same table

B

Beans

Is it possible to create a record for a table with a query? I have a table
that has a moisture status (dry (1) and wet (2)) and color fields. The color
is ALWAYS the same for dry and moist. If I manually populate the dry color
and its associated color, can I query and make a new record for moisture
status 2 and populate the color with the color from moisture status 1? Thanks

Moist_Status Color
1 10 ----------manually populate
2 10 ----------query to populate
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match table shading (color) to Visio color/Transparency 1
Need help modifying code 0
Fill tringle in a cell with color 1
Copy previous record into form field 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Setting column width in a table with a macro is not working 0
table shading prints differently on different pages 0
Indenting every other paragraph in Word at the same time? 0

Top