"Teresa Anderson" <
[email protected]> escreveu na mensagem
| Thanks Tim...so if I want -1 to be something else how can I change it?
| --
| Teresa B Anderson
|
|
| "Tim Johnson" wrote:
|
| > Access stores the value True (or checked in a checkbox scenario) as -1,
and
| > False as 0.
| >
| > "Teresa Anderson" wrote:
| >
| > > Thanks for your help. I have set up the query but I am still unclear
on what
| > > you mean by If checkbox = -1 then I'm not sure how to put that in
the
| > > query. I am very new to access and I really need you to furture
explain.
| > > --
| > > Teresa B Anderson
| > >
| > >
| > > "Wayne-I-M" wrote:
| > >
| > > > Yes it possible but you shouldn't do it. This would mean you have
the same
| > > > data stored in the same record twice.
| > > >
| > > > You should create a query and then base a form on this use IIf
checkbox = -1
| > > > then (after this add the calculation that you need)
| > > >
| > > > The method you are mentioning sounds like an excel calculation and
this is
| > > > not the best way to use access.
| > > >
| > > > If you have problems post a question and someone will be able help
| > > >
| > > >
| > > > --
| > > > Wayne
| > > > Manchester, England.
| > > >
| > > >
| > > >
| > > > "Teresa Anderson" wrote:
| > > >
| > > > > Is it possible to Create a Check Box on a table and relate it to
other data
| > > > > types in the same table? I am trying to set up a table that list
Zones,
| > > > > Blocks, Gallons Per Minute of Water, Check Box and Total Columns.
I want to
| > > > > to be able to put aa check box in a column beside the GPM column
so that if I
| > > > > put a check in the check box it will transfer the GPM total over
to the Total
| > > > > Column. Is this possible?
| > > > > --
| > > > > Teresa B Anderson
