mrrayj60
Registered User.
- Local time
- Today, 05:49
- Joined
- Sep 3, 2009
- Messages
- 103
Let me see if I can explain my need. I've been adding a recording to a fines table one record at a time. I enter the fine date (txtfinedate) on the form and an amount (txtfine1) and the append qry copies this data to the fines table. It works ok, what I would like to do is add each record if I use a date range. This way if fines should have been posted each day but they didnt enter them I can catch up with a bunch. The fines say are from 1/1/10 to 1/6/10 so hopefully it will add 7 recorded fines. I would need a date prompt but not sure how to get it to append multi records with the seperate dates.
This does one record ok, any thoughts would be helpfull. access 2003.
Thanks Ray
INSERT INTO vrcfines ( finedate, ubl, Name, [vrccase#], complaintid, complaint, fineamnt, posted )
SELECT forms!vrcedit!txtfinedate AS Expr1, forms!vrcedit!txtubl AS Expr2, Forms!vrcedit!NAME AS Expr3, Forms!vrcedit!txtvrccase AS Expr4, Forms!vrcedit!txtcomplaintid AS Expr5, Forms!vrcedit!txtcomplaint AS Expr6, Forms!vrcedit!txtfine AS Expr7, False AS Expr8;
This does one record ok, any thoughts would be helpfull. access 2003.
Thanks Ray
INSERT INTO vrcfines ( finedate, ubl, Name, [vrccase#], complaintid, complaint, fineamnt, posted )
SELECT forms!vrcedit!txtfinedate AS Expr1, forms!vrcedit!txtubl AS Expr2, Forms!vrcedit!NAME AS Expr3, Forms!vrcedit!txtvrccase AS Expr4, Forms!vrcedit!txtcomplaintid AS Expr5, Forms!vrcedit!txtcomplaint AS Expr6, Forms!vrcedit!txtfine AS Expr7, False AS Expr8;