Check Box Question in Query

  • Thread starter Thread starter Joe Cilinceon
  • Start date Start date
J

Joe Cilinceon

I've been having a problem using a check box work from a query. Let me
explain it this way. I have a payment screen for units rented that shows the
unit # the paid thru date and any charges pertaining to that unit. Now a
single tenant could have several units which they may not pay at the same
time. I would like to have a will pay check box added that will exclude any
unit from the amount owed and only pay for those set to yes. I've tried
several ways to do this but the check box seems to only work if it exists in
an underlying table which it isn't in this case. Any suggestions on where I
might find some more information on check boxes other than the help files.
Any help would be greatly appreciated.
 
Checkboxes are a UI tool that represent a Yes/No or True/False condition.
They can be linked to a field(column) in a table that has a boolean(binary)
datatype.

As far as your current app, I don't know what functionality already exists,
so I can't really suggest that you do anything.
 
I'll try to explain this a little better Steve. What I want to do is have a
payment screen that just deals with what is owed at the moment a tenant
pays. Now they might have multiple units we will say 2 here for example.

I have a query based on the ledger table that figures the last paid thru
date and move it to the next month. This table is named Balance Due. It
figures how much is owed at this moment and will add fees and other charges
based on dates etc. Now the query works perfectly as far as getting the
data.

My problem is I want to use it on a subform that will list the Units the
tenant has, be it 1 or 10 and have a check box in the first field. This
check box will default to Yes and the total on the main form will show a
total due. If I uncheck the box for say 1 unit I want it to refresh the
total fields and give a total for those units that are checked. My problem
is the checkbox itself. I add it to the query and default it to yes but when
added to a form it is a text box and no way I've found to change it as
Yes/No isn't an option shown. I set it in the format on the properties
Yes/No but can't select a check box as the Lookup is blank.

I guess what I was wondering if I would have to add this to the table under
all of these queries which is the Ledger Table for it to work. I hope that
is a little clearer.

--
Thanks

Joe Cilinceon
 
Back
Top