Answer the question
In order to leave comments, you need to log in
How to bind a field value from a form to a query in MS Access??
There is a form. It is based on a request with a parameter. You need to run this form and when you select a parameter, the query should change. If I just put the parameter > 3 in the request, then everything is displayed. But if I put a parameter in the query > field values in the form, then it shows that the value is not recognized by the Access core as valid
. This is how it works:
TRANSFORM Sum(dataT.Production) AS [Sum-Production]
SELECT ProductT.ProductName, Sum(dataT.Production) AS [Sum-Production1]
FROM monthT INNER JOIN (ProductT INNER JOIN (factoryT INNER JOIN dataT ON factoryT.ID = dataT.FactoryID) ON ProductT.ID = dataT.ProductID) ON monthT.ID = dataT.MonthID
<b>WHERE (((dataT.MonthID)>3))</b>
GROUP BY ProductT.ProductName
PIVOT factoryT.FactoryName;
TRANSFORM Sum(dataT.Production) AS [Sum-Production]
SELECT ProductT.ProductName, Sum(dataT.Production) AS [Sum-Production1]
FROM monthT INNER JOIN (ProductT INNER JOIN (factoryT INNER JOIN dataT ON factoryT.ID = dataT.FactoryID) ON ProductT.ID = dataT.ProductID) ON monthT.ID = dataT.MonthID
<b>WHERE (((dataT.MonthID)=[Формы]![Spravka]![InputDate1]))</b>
GROUP BY ProductT.ProductName
PIVOT factoryT.FactoryName;
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question