Anyone can help on this ? Total Date In Access (1 Viewer)

[STEFANNIE]

1/7/2024
2/7/2024
3/7/2024
4/7/2024
5/7/2024
6/7/2024
9/7/2024
10/7/2024
11/7/2024
12/7/2024
13/7/2024
15/7/2024
16/7/2024
17/7/2024
18/7/2024
19/7/2024
20/7/2024
22/7/2024
23/7/2024
24/7/2024
25/7/2024
26/7/2024
27/7/2024
29/7/2024
30/7/2024
31/7/2024
26 Counta(A:23,B:24)

How to do on this in Ms Access?How to Total all the diff date in access?

 

[GaP42]

Counta in excel counts the number of non-empty cells. Is that what you want? Can you do a query of the table containing the records of interest
SELECT Count(*) AS RecCOunt
FROM yourtablename
WHERE (Not yourdatefield) Is Null;

Or use the Dcount function

 

[Pat Hartman]

@STEFANNIE Welcome. I moved your question to a more appropriate thread. The FAQ is just what it sounds like. WE tell you stuff. You don't ask questions there.