Search results

So i have 2 Queries i'm combining into 1 with a Union Query. Table 2 has a date field that Table 1 doesn't and so it needs to be created/defined in table 1 which i have done like this: ""as [fld_Date_trec] But this is making that column a text field and so the dates from table 2 don't act as...

so i have a Crosstab Query [qryTraining-Crosstab] to track who has done what courses. the column headings are Course Names..... course 1, course 2, course 3, etc the row headings are the people name [Fname] .... jim, john, jane, etc... and the values are there course status [fld_Name_stat]...