Re: Check Box Question in Query
From: Joe Cilinceon (jfc_at_direcway.com)
Date: 11/24/04
- Next message: C White: "Re: query involving dates"
- Previous message: Darrell Childress: "Re: How to round off to nearest 0.25"
- In reply to: [MVP] S.Clark: "Re: Check Box Question in Query"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 24 Nov 2004 15:14:38 -0500
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 "[MVP] S.Clark" <steve.clark_NOSPAM@FMSInc.com> wrote in message news:OOv$Rdl0EHA.3120@TK2MSFTNGP12.phx.gbl... > 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. > > -- > Steve Clark, Access MVP > FMS, Inc. > www.fmsinc.com/consulting > > "Joe Cilinceon" <jfc@blueone.net> wrote in message > news:e725VOi0EHA.1392@TK2MSFTNGP14.phx.gbl... > > 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. > > > > -- > > Thanks > > > > Joe Cilinceon > > > > > >
- Next message: C White: "Re: query involving dates"
- Previous message: Darrell Childress: "Re: How to round off to nearest 0.25"
- In reply to: [MVP] S.Clark: "Re: Check Box Question in Query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
