Hi everyone,
I have two questions, and would appreciate any help you can give me.
1. I have a crosstab query, that lists job number vs date vs a number of items. I want to make the criteria for the job number the openargs from a form. However when I put in [Forms]![IssueForm].[OpenArgs] as the criteria in my query design box, I get the following error message: The Microsoft Jet Engine does not recognise [Forms]![IssueForm].[OpenArgs] as a valid field name or argument.
2. I cannot figure out how to limit the query to the top 12 dates (which are the column headings.
Here is my SQL code if it helps:
TRANSFORM First(JoeTest1.Copies) AS FirstOfCopies
SELECT JoeTest1.JobID, JoeTest1.[Company Name], JoeTest1.Contact
FROM JoeTest1
GROUP BY JoeTest1.JobID, JoeTest1.[Company Name], JoeTest1.Contact
ORDER BY Format([Date of Issue])
PIVOT Format([Date of Issue]);
Thanks,
Joe.
I have two questions, and would appreciate any help you can give me.
1. I have a crosstab query, that lists job number vs date vs a number of items. I want to make the criteria for the job number the openargs from a form. However when I put in [Forms]![IssueForm].[OpenArgs] as the criteria in my query design box, I get the following error message: The Microsoft Jet Engine does not recognise [Forms]![IssueForm].[OpenArgs] as a valid field name or argument.
2. I cannot figure out how to limit the query to the top 12 dates (which are the column headings.
Here is my SQL code if it helps:
TRANSFORM First(JoeTest1.Copies) AS FirstOfCopies
SELECT JoeTest1.JobID, JoeTest1.[Company Name], JoeTest1.Contact
FROM JoeTest1
GROUP BY JoeTest1.JobID, JoeTest1.[Company Name], JoeTest1.Contact
ORDER BY Format([Date of Issue])
PIVOT Format([Date of Issue]);
Thanks,
Joe.