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

S

S

shokw0w2017-08-29 09:30:28

Microsoft Access

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

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

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

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

A

Alex Andr2015-06-23 18:55:06

What is the best way to populate the database? 1Reply

I

Igor2017-06-21 02:35:32

How to transfer database from cronosplus to access? 0Reply

A

Alisa712021-06-02 11:35:12

How to find farms run by women in a query? 2Reply

S

shokw0w2017-08-22 06:34:51

Why does the checkbox give mixed status in response? 2Reply

M

Maksim Borisov2017-09-26 10:58:55

How to get response from Telegram Bot by condition from Access? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question