Make table query on Crosstab query basis (1 Viewer)

litpost

New member
Local time
Today, 02:46
Joined
Nov 6, 2009
Messages
6
I am on migration from MS Access 2007 to SQL Server 2012 express. Recently I am faced with strange Access frontend behavor.

In one of our Apps based on MS Access I simulate Excel style to enter Employee working hours data on continuous form. On Open event subroutine prepares recordset for this form. In Soubroutine I have three MakeTable queries where I pass four parameters to each of them. All queries are based on Crosstab queries accordingly. I have saved all queries so I call them in subroutine by names (set querydef and pass all parameters).

But may problem is not actually related to Subroutine:

All MakeTable queries executes without error. However, only first table has records. Other two are empty.

- If I pass parameters manualy to each Crosstab query I see records in all three of them.

- If I pass parameters manualy to each MakeTable query I see records only in first made Table. Two others are empty!

And most interesting is that it appiers only with SQL Server BackEnd. If I do all steps with MS Access BackEnd all works just fine!
 

litpost

New member
Local time
Today, 02:46
Joined
Nov 6, 2009
Messages
6
Solved! Placed GROUP BY clause in 2 MakeTable queries. :)
 

Users who are viewing this thread

Top Bottom