How to make a selection from the database in the ms access expression builder?

S

shokw0w2017-08-29 09:30:28

Microsoft Access

shokw0w, 2017-08-29 09:30:28

I want to select absent values where gradeid = 1 and display their sum. Withdrawed the total amount, but how to filter?
=Sum([dbo_attendance]![absent])

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

shushpanio, 2017-08-29
@shushpanio

Add where gradeid = 1
not?

Similar questions

P

Pixilys2021-03-14 18:38:52

Upgrading the functionality of a running Access database. Is it possible to? 1Reply

V

VMesser2017-05-04 20:55:45

Select first N records for each group, how does it work? 0Reply

S

shokw0w2017-05-10 05:40:27

How to group data so that they follow each other? 1Reply

Z

Zenko2017-05-17 17:13:48

Does not fulfill the input condition in MS Access 2007, what is the error? 0Reply

F

favbet2015-07-08 22:47:54

How to avoid losing pennies in calculated access fields? 2Reply

Didn't find what you were looking for?

Ask your question