QBF Limit?

  • Thread starter Thread starter Con Giacomini
  • Start date Start date
C

Con Giacomini

A client wants an Access 2000 database to store about 300 records. The
single table will have about 55 fields. They want to use Query by Form to
specify the criteria for about 50 fields in the query. Is this possible?
Most of the data will use the CheckBox data type. Is there anything special
in setting up a fom to select checked boxes? Thanks for any information.
 
A client wants an Access 2000 database to store about 300 records. The
single table will have about 55 fields. They want to use Query by Form to
specify the criteria for about 50 fields in the query. Is this possible?
Click to expand...

Yes, though it's not sounding like a very good design. Is this a
PERMANENTLY STATIC list of 50 "fields", or are they storing data in
fieldnames? If the list of fields will vary over time, a "tall thin"
normalized design would probably be better.
Most of the data will use the CheckBox data type. Is there anything special
in setting up a fom to select checked boxes? Thanks for any information.
Click to expand...

Nothing special. A Checkbox is bound to a Yes/No field - checked or
Yes is stored as -1, unchecked or False as 0.
 
Back
Top