Query results that includes rows for missing data points

[Wombat]

I am trying to build a tool that creates financial graphs. I will have a "PriceTime" table with fields <Price> and <PTime>, this field contains second-by-second prices. Another table will be "EventTime" and have an Event and an <Etime> field.



My problem is that for the graphs, if a second is missing, I want a blank record for that second so that my graph doesn't look like it had a drastic change when really there are just data points missing.

Is it possible to do something where the query says:

For each second in X time range (for example, + 10 minutes and - 10 minutes of an event time)
Select Time, price
and if there is no record for that second, give me the Time and a Null in the price?


I hope this was clear.

[June7]

Why would a second be missing? Cannot display data that doesn't exist. Query cannot create the record. You can use VBA code to loop through a recordset of the data and determine if a second is missing and if it is, insert a record in table with that time.