In Access: group of records and assign conditional group ?

Dong Lam Trien

In Access I want to group and assign data according to conditions with 2 values 0 and 1 (true or false) and with the condition NGAYGIAO>= #01/01/2019# and NGAYGIAO <=# 31/01/2019# me How to write commands ? The data I put in the excel file consists of two sheets: Original data and Result, where Original data is the original data sheet that is the result of the problem I need, when running the access issue, ask you to help me with the problem. http://www.mediafire.com/file/hkkw519bw2k3o9h/baitap_data2.xls/file

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dong Lam Trien7y ago
How do you write the query ?
0
Mario Scheeren7y ago
First in your sheet there is no grouping, second you claim 2 contitions to be used, but declare only the date between #01/01/2019# and #31/01/2019#

So Explain What are the TWO conditions. Which Field / Fields you want to group by ... or just sum up ? Average ?
0