Create a record where one doesn't exist

[Tara]

I am facing a situation in which I need to use the Nz function, or something
akin to that to *create* records that don't really exist. Essentially, I'm
using a start date and end date as parameters to pull employee withdrawls
from a fund and then subtracting that from the amount they earned for the
fund during the same specified time period in order to come up with a
"Beginning Balance" amount for another query. I can use the Nz function to
insert $0 for the amount requested and can also use it to insert a fake date
as the date of withdrawl. However, it makes the fake date a text field
rather than a date field which causes problems in subsequent queries. Is
there a different way to approach it?

Thanks,

 

[KARL DEWEY]

Post the SQL of your query.