I
I
Ilya2016-12-18 21:34:11
Microsoft Access
Ilya, 2016-12-18 21:34:11

How to count the amount of data in requests?

How to calculate the amount of data that will be received by this request?

SELECT [Журнал входящих документов].[Дата получения исполнителем], [Журнал входящих документов].[Код документа]
FROM [Журнал входящих документов]
WHERE ((([Журнал входящих документов].[Код документа])="Договор") AND ((DatePart("m",[Дата получения исполнителем]))=4) AND ((DatePart("d",[Дата получения исполнителем]))>15));

The request displays data to me, but it is necessary that it simply displays the amount.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ananiev, 2016-12-18
@nuBacuk

SELECT COUNT(*) FROM [table name] WHERE condition

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question