RE: Display fields Limited on Values

The reason that I chose not to go beyond 2NF is that the number of people who
will be modifying this database is limited to myself and one other person,
everyone else will be read-only, and the combination of being busy and not
feeling like further complicating my queries has kept me from doing so.

Respectfully,
Paul

"Duane Hookom" wrote:

Your reply basically confirms my previous posting.

Is there any way that you would consider normalizing/correcting your table
structure?

--
Duane Hookom
Microsoft Access MVP


"lamartpm" wrote:

The reason that I went this route is that for them to be eligible to be sent
overseas they have tons of different requirements, so i chose to just use
booleans. There names are all just the names of classes that they must
attend. For classes there are 6 seperate classes that they must attend and
its pretty much a did they or did they not attend. And the other tables are
all pretty much the same way e.g. they have 15 different forms that we have
to have on record for them to be sent. All of the records in the different
tables are being joined on a automatically generated ID that is created in
the general info table.

"Duane Hookom" wrote:

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: Display fields Limited on Values
    ... "lamartpm" wrote: ... "Duane Hookom" wrote: ... boolean field names. ... I also made another query that displays the ...
    (microsoft.public.access.queries)
  • Re: Table selection in query
    ... Maybe I need to rethink the way that database ... the query could run against either the new table or the current table. ... "Duane Hookom" wrote: ... > Are you looking for a better method than using the union query? ...
    (microsoft.public.access.queries)
  • RE: I dont understand why this Delete Query fails?
    ... I can edit the names in tbl_Street_Names. ... "Duane Hookom" wrote: ... query to a select query, can you edit the records from tbl_Street_Names? ... The database was opened for read-only access. ...
    (microsoft.public.access.queries)
  • RE: Mail merge to Word using 1:m relationship
    ... I now get every row from the query. ... "Duane Hookom" wrote: ... "scubadiver" wrote: ... For some reason, when I open up the database source list in Word, the query ...
    (microsoft.public.access.queries)
  • Re: Structuring queries/reports so my employees can use the databa
    ... "Duane Hookom" wrote: ... I've got a basic database ... The product table lists about 200 names, the vendor ... Use a drop-down menu of product names, pick one, and query the database ...
    (microsoft.public.access.gettingstarted)