Query returns "-1" instead of actual values.

[Steff_DK]

Check the attached mdb file.

Can't figure out why the query returns -1 instead of the letters that are stored in the table

Many thanks!

Steff

 

[Fear Naught]

The syntax of the subquery in each day is wrong. You need to construct the subquery for each day like this (Day 6 is the example as it returns a positive result):

(SELECT tblvagter.label
FROM tblusers INNER JOIN tblvagter ON tblusers.user_id = tblvagter.user_id
WHERE (((Format([start_plan],'dd-mm-yyyy'))='06-04-2006') 
AND ((tblvagter.position)="FA"))) AS Day6

HTH

 

[Fear Naught]

A second thought is that you might like to play with Crosstab queries for something like this.