S
Steven Sutton
I have a query that selects the Distinct paper combinations we used to print
the jobs in a weeks time. I display these distinct paper combinations in a
form set to Continous view. What I would like to be able to do is to enter
the price of each paper into the form and then update the appropriate records
in the Table.
For example, last week we printed 60 jobs. To print those jobs, we used 15
different papers. I would like to enter the prices for those 15 papers and
then update all 60 records in the table. I just don't know how to go about
this. Since the number of distinct papers will vary week to week, there is no
way I can know how many records will be displayed in the form. I am picturing
a loop that will create an SQL statement based on the paper specs (ie - for
22" 32# Newsprint, INSERT INTO ..... WHERE Size=22 AND Weight = 32 AND
Type="Newsprint") but I don't know how to cycle through all the records in
the form.
Any suggestins would be apprecisted.
Steven
the jobs in a weeks time. I display these distinct paper combinations in a
form set to Continous view. What I would like to be able to do is to enter
the price of each paper into the form and then update the appropriate records
in the Table.
For example, last week we printed 60 jobs. To print those jobs, we used 15
different papers. I would like to enter the prices for those 15 papers and
then update all 60 records in the table. I just don't know how to go about
this. Since the number of distinct papers will vary week to week, there is no
way I can know how many records will be displayed in the form. I am picturing
a loop that will create an SQL statement based on the paper specs (ie - for
22" 32# Newsprint, INSERT INTO ..... WHERE Size=22 AND Weight = 32 AND
Type="Newsprint") but I don't know how to cycle through all the records in
the form.
Any suggestins would be apprecisted.
Steven