Raport of values out of tolerance

[Wojtej]

Can I make an easy raport in MC Access that shows whitch dataset, that are not in norme?



For example i have three values: 10, 20, 30 and they have their own tolerances: 8-12, 19-33, 25-29

How can I extract to raport only the third value in the raport, and it would be nice to add some text to it?
Or I could extract based on a Yes/No box, how could I do it?

[xps35]

That could be easy. But we do not know your data structure. How are the values and tolerances stored? Please provide more details or a copy of your database.

[mike60smart]

Hi

Are you storing the three values: 10, 20, 30 as Records in a related table
or are they stored in fields in a table?

[Wojtej]

Hey, the values and normes are in the same table. It is value#1, value#2, value#3, and minimum#1, minimum#2, minimum#3, maximum #1, maximum #2, maximum #3 made this one simpler, but that's the gist of it
max and min both have basic value accordingly to the need

[Welshgasman]

Would be better as separate records.
Access is nothing like Excel.

[mike60smart]

Hi
OK so your table structures are wrong.
Can you upload a zipped copy of the database so we can see the table structures?

[Micron]

Ditto. Research db normalization, fix your tables and come back. If not, you will always struggle with what you have. Getting what you want from this

10

20

30

is more difficult than getting it from this

10

20

30

The second arrangement is the way it should be in a database. The first is how it's normally done in Excel.

[Welshgasman]

Ditto. Research db normalization, fix your tables and come back. If not, you will always struggle with what you have. Getting what you want from this

10

20

30

is more difficult than getting it from this

10

20

30

The second arrangement is the way it should be in a database. The first is how it's normally done in Excel.

Your tolerances should be in rows as well.