appending records using start date end date (1 Viewer)

[mrrayj60]

thanks, well this will add a vrcfine for the date I enter, anydate, I want to get it to add multiple records for a date range so I need a second date prompt but cant get the logic to accept. I tried >=[date] and <=[date] its does not like that, is there a "thru" phrase

INSERT INTO vrcfines ( ubl, Name, [vrccase#], complaintid, complaint, fineamnt, finedate )
SELECT vrc.UBL, vrc.NAME, vrc.[VRCCase#], vrc.Complaintid, vrc.COMPLAINT, vrc.Fine, [date] AS Expr1
FROM vrc
WHERE (((vrc.Complaintid)=132));

 

[mrrayj60]

Let me ask the question different. If you wanted to add 7 records from vrc to vrcfines with the same data 7 times with the exception of finedate how you would build your query?

Appending one record at a time works ok, you just have to enter the exact Fine date each time.

I've seen this but it wont accept it in an append query in the field:
Between [Start Date] And [End Date]

Ray