Form/Query "how to" question

[Guest]

I'm setting up a db to keep track of my checkbook (debits/deposits, future
scheduled debits, what's cleared the bank and what hasn't, and the dates
items clear, etc).
I'm trying to create a form to enter the dates that items clear the bank. I
want the form to only show records (in a sort of list format) for the items
that I haven't previously entered a "cleared date" for. And then next to
each record a text box for me to type in a cleared date.
How do I create a form that pulls up records with blank "cleared date" fields?
And then how would I design the form so that the records are sort of
"listed" with a box next to each where I enter the cleared date for that
transaction?
Thanks a lot for your help.

 

[Debra Farnham]

Create a query using the fields desired for the form. The criteria for the
"cleared date" will be Is Null. That will return only records where you
have not filled in a date.

Next create a tabular form based on the query. The Form Wizard should be
able to adequately achieve what you are desiring.

Hope this helps.

Debra

 

[Guest]

Thank you.