I got a table of 7 numbers (between 1-45) on a certain datel. Now I want to get them in to a query with a date row and row numbers from 1-45 now would like to mark those numbers picked on a certain date marked with an X. I tried this with IIF but can't get it. I managed to make a query where the dates of '1' are being submitted but I can't seem to get them in my in my collum of '1' I'll post a snapshot with it
this is what i'd like to see in the end as an example:
numbers on certain date in one table :
now i want to get them in a different query in this way depending on what is on first table offcourse
Marked the X's by hand offcourse
this is what i'd like to see in the end as an example:
numbers on certain date in one table :
Date | nr1 | nr2 | nr3 | nr4 | nr5 | nr6 | nr7 |
06/10/2001 | 2 | 5 | 6 | 8 | 22 | 41 | 42 |
now i want to get them in a different query in this way depending on what is on first table offcourse
date | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9....45 |
06/10/2001 | x | x | x | x | .....45 |
Marked the X's by hand offcourse