Question regarding Query for a graph

[Sniper-BoOyA-]

Good Morning everyone,

I am currently working on a database to determine the compression strength of a sample.

The main idea is to have 6 samples in total. (3 sets of 2)

Each set has its own mixture content, moisture content and Dry density.

That data is used to calculate the compression strenght of the sample in question.

There are 2 types of calculations. One for a 7 day test, and one for the 28 day test. If the result is not sufficient after the 7 day test, a 28 day test will be needed. (thats why you need 2 samples in every set)

Both calculations will be in a query which will be the source of the graph.

The query for the graph looks like this:

Sample nr ---- Mixture content ---- 7 day test ---- 28 day test

--1 ---------------- 2 ---------------1.4--------------------
--2 ---------------- 2---------------------------------------
--3 ---------------- 3 ---------------------------------1.7--
--4 ---------------- 3---------------------------------------
--5 ---------------- 4 ---------------2.1--------------------
--6 ---------------- 4---------------------------------------

Both the 7 day and the 28 tests are the average of each set (1-2, 3-4, 5-6)

What i am trying to do is simply make a graph out of these results. But the problem is, i can only select one type of test to be on the X-axis.

So it either shows 2 results in the graph, or just 1 result.

Ive been trying several Iif statements to be able to get all the values in one column. But i keep getting syntax errors.

Does anyone have a solution for this?

Thanks in Advance!!

 

[Sniper-BoOyA-]

Aah i figured it out. And it was easier than i thought.

I simply used:

IIF(avgd7="";avgd28;avgd7)

DOH !

Thanks though