[AccessD] Carry Forward in a query

I have a table of data that has a record about every 6 months. I would
like to generate a record for every month using the previous months data
until there is data for the current records month. I can do this in code
but had a coworker ask if it could be done in a query. I am not coming
up with an answer. Your thoughts please.

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.