B
B
Brunetgk2020-02-25 11:09:16
Microsoft Access
Brunetgk, 2020-02-25 11:09:16

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;

And so no:
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 question

Ask a Question

731 491 924 answers to any question