Copy/Insert a new record in a database

[Overkill32]

I'm trying to insert a new record in a database that is basically the last one i entered. Put in another way, if there was no data available for today for the item XYZ, i would need to take the data entered yesterday at 17h (there is a column in the database for the time and one for the date) and create a new record identical to it for today and change the time. Can anyone help me with the basic structure the code would have to take either in VBA or SQL? I will need to automate this process...

 

[jackd]

I don't follow why you must have a record for today --- if there is no data, seems like there is NO data. Why create an artificial record???

 

[Overkill32]

I need to have a price that reflects an "it didnt change" status. The price that i need to copy is therefore the last one i had yesterday. This is the methodology i need to follow for that database.

 

[jackd]

Something along these lines should do the job

INSERT INTO YourTable(fld1,fld2,fld3,fldx)
SELECT fld1,fld2,fld3,fldx FROM YourTble 
Where Item = "the item you are dealing with"  AND
TheDate = (SELECT max(theDate) from yourTable )

theDate represents the column Name of the date_field.
item = "XYZ" for example.

If there is a different Price for each Item, then you'd have to put this in some loop construct.