All forms with ticked box.

  • Thread starter Thread starter BruceM
  • Start date Start date
B

BruceM

Firstly I opologise to experts.

I have a database of ALL businessess in a town with many fields including
postage address, phone number, propietor etc etc.
I also have a checkbox to indicate if they are a member of a certain
organisation.
I want to have a form that lists only those records that have a tick in the
checkbox.
Is this possible?
Thankyou in advance.
 
Guess I can change my whole system over to "yes" & "no" & then I can select
the criteria as "yes" ?
Just not sure what criteria to put for a ticked check box.
Anyone?
 
Yeah........... thanks.
forget it.


Chris2 said:
BruceM,

Untested:

SELECT B1.Business
FROM Businesses AS B1
WHERE B1.Organisation = -1


Sincerely,

Chris O.

PS Although meant for an sqlserver newsgroup, the
following link is still applicable for MS Access:
http://www.aspfaq.com/etiquette.asp?id=5006, and
is excellent when it comes to detailing how to
provide the information that will best enable
others to answer your questions.
Click to expand...
 
Much better.
Thankyou so much Chris. Worked like a charm. I searched everywhere I could
think of including google but just couldn't seem to come up with something
so simple.
Once again thankyou.
10 points....
 
BruceM said:
Firstly I opologise to experts.

I have a database of ALL businessess in a town with many fields including
postage address, phone number, propietor etc etc.
I also have a checkbox to indicate if they are a member of a certain
organisation.
I want to have a form that lists only those records that have a tick in the
checkbox.
Is this possible?
Thankyou in advance.
Click to expand...

BruceM,

Untested:

SELECT B1.Business
FROM Businesses AS B1
WHERE B1.Organisation = -1


Sincerely,

Chris O.

PS Although meant for an sqlserver newsgroup, the
following link is still applicable for MS Access:
http://www.aspfaq.com/etiquette.asp?id=5006, and
is excellent when it comes to detailing how to
provide the information that will best enable
others to answer your questions.
 
BruceM said:
Guess I can change my whole system over to "yes" & "no" & then I can select
the criteria as "yes" ?
Just not sure what criteria to put for a ticked check box.
Anyone?
Click to expand...

BruceM,

In Access, 0 = False/No, -1 = True/Yes.


Sincerely,

Chris O.
 
Back
Top