RE: Display fields Limited on Values

If you are using multiple boolean fields then I think your table structure is
wrong. You should not be using "requirements" as field names. Each
person/requirement should create a single record in a related table.

There is lots of good information on normalization on the web.

If you don't understand this, come back with some table, primary fields, and
boolean field names.

--
Duane Hookom
Microsoft Access MVP


"lamartpm" wrote:

Hey,

Sorry, I created the database yesterday. Well the basic layout is a
personal information table with pretty standard fields: Name, address, sex,
D.O.B., etc. The other tables (classes, lab reports, immunizations, and
forms) have boolean fields that indicate whether they have completed certain
requirements. I used a query to join all the tables (all joined on a
personal id (auto-generated)). I also made another query that displays the
names of everyone who has anything not completed. So I want to create a
report so I can say, John Doe, you need to complete this test, form, etc. I
think it would just be an expansion of the latter mentioned query, but I
don't know VBA well. I am pretty good in JAVA, so I know the basic structure
required, but I was hoping for further help.

Thanks,
Paul

"Maurice" wrote:

Well if you want us to think about it give us something to look at (what do
you have, what's the source etc.)

--
Maurice Ausum


"lamartpm" wrote:

I'm pretty fluent in MySQL but I ran into a problem. I have a database that
consists mainly of booleans. It tracks whether people did certain things and
the layout is pretty simple. However, I cannot figure out how to write a
query that will display the person's name and what requirements they still
must meet. I have created a rather lengthy query to display everyone who has
not, but I want to be able to generate a form that will show the people what
they still need to do.

Thanks,
Paul
.

Relevant Pages

  • Re: Query Help - How to total checked boxes?
    ... that keeps track of user login information so there will be many ... I have 5 boolean fields which are displayed ... How do I display the total of these boolean fields for ... Here is the query I have now: ...
    (microsoft.public.access.queries)
  • Re: Access migration to SQL Server
    ... >> about having to convert all your queries to views and stored procedures. ... >> using a named query parameter to look up a value from a form control and ... >> allowing editing of values from multiple tables in a query with a join. ... >> field, checking for NULL in Boolean fields, etc. ...
    (microsoft.public.access.conversion)
  • Re: Access migration to SQL Server
    ... >> about having to convert all your queries to views and stored procedures. ... >> using a named query parameter to look up a value from a form control and ... >> allowing editing of values from multiple tables in a query with a join. ... >> field, checking for NULL in Boolean fields, etc. ...
    (microsoft.public.sqlserver.server)
  • Re: How many nulls in each field?
    ... Boolean fields should always have a value, so there is really no way to count those that don't have a value. ... Think I'll have to have a go though as 24 different tables to query and all 60 fields at least and all different. ... "John Spencer" wrote: ... The idea of importing to an existing table is what I will do. ...
    (microsoft.public.access.queries)
  • Re: newbie - updatable query in asp
    ... Can I use these checkboxes also to display my query? ... I have the four boolean fields which are normally always set to false. ... >> So I need a asp form with a grid showing these records and have the ...
    (microsoft.public.inetserver.asp.general)
Loading