W
wdsnews
I'm hoping to find a shortcut that will allow me to fill the last four
months of data more quickly. I need to filter the people table on a Yes/No
field called 'Current'. For each match I need four entries in the Quantity
child table, one for each month. The quantity table has ID, People.ID,
Month, and quantity fields. My goal is to fill each entry with a default
value, different for each month, and then manually go back and correct the
exceptions.
where People.current = Yes
Quantity.month = 9
Quantity.quantity = 21
Quantity.month = 10
Quantity.quantity = 23
Quantity.month = 11
Quantity.quantity = 17
Quantity.month = 12
Quantity.quantity = 15
Can I do this with a query?
months of data more quickly. I need to filter the people table on a Yes/No
field called 'Current'. For each match I need four entries in the Quantity
child table, one for each month. The quantity table has ID, People.ID,
Month, and quantity fields. My goal is to fill each entry with a default
value, different for each month, and then manually go back and correct the
exceptions.
where People.current = Yes
Quantity.month = 9
Quantity.quantity = 21
Quantity.month = 10
Quantity.quantity = 23
Quantity.month = 11
Quantity.quantity = 17
Quantity.month = 12
Quantity.quantity = 15
Can I do this with a query?