RE: Report Query

Tech-Archive recommends: Speed Up your PC by fixing your registry

Sorry if I came across a little harshly. I still stand by what I said, but
maybe not how I said it.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Sandra P" wrote:

Thank you Jerry for your most humble opinion but that really doesn't solve my
problem. I have asked other questions within this forum before and you are
the only one that felt entitled to insult my intelligence for some reason.
Now, with that being said, short of rewriting my database, can anyone suggest
criteria I can use for my current dilemna?

"Jerry Whittle" wrote:

What are you going to do with your table and all the queries, forms, and
reports based on it when someone changes the business rules and adds a
Document4?

That problem and the one you describe now are due to your table not being
properly normalized. You are trying to "commit spread***". Your table has
serious normalization problems and just will NOT work correctly in a
relational database. Period.

I highly suggest getting some relational database training or reading
"Database Design for Mere Mortals" by Hernandez before proceeding any further
on this database.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Sandra P" wrote:

I have a table with the following fields: Document1IfRequired (text),
Document1Rec'd (yes/no), Document1Rec'dDate (date). There are 6 additional
fields which are for Document 2 & 3. I run a Missing Documents report based
on a query that has the criteria of: Document1IfRequired is not null and
Document1Rec'd is no OR if Document2IfRequired is not null and Document2Rec'd
is no OR if Document3IfRequired is not null and Document3Rec'd is no. This
lets me know which documents I'm missing of those that are required.

This is my problem: If Document 1, 2 & 3 are all required and I've received
say, 1 & 2, I want my report to only contain the Document3IfRequired field.
Right now it shows all 3 documents whether they have been received or not.
As a quick fix I added the Document1Rec'dDate (2 & 3 also) so at least it
would show up that they were received, but it appears cluttered and is
sometimes confusing to the recipient of the report. Can I make those lines
invisible if the documents have already ben received?
.

Quantcast