Query without chick days (1 Viewer)

Murad

New member
Local time
Today, 13:40
Joined
Jan 13, 2021
Messages
4
How can I create a query that does not contain the days specified in the form
 

Attachments

  • OutChickDays.accdb
    672 KB · Views: 66

Ranman256

Well-known member
Local time
Today, 07:40
Joined
Apr 9, 2015
Messages
4,339
if the days are in a table, create an OUTER join query.

in a query, join your 2 tables on the date fld,
dbl-click the join line,
chose SHOW ALL records in Tbl1, SOME in tbl2
OK
bring down the joined field in both tables.
run query
the items with NULL field are the missing ones.
you can filter ONLY missing ones with criteria: IS NULL
 

Murad

New member
Local time
Today, 13:40
Joined
Jan 13, 2021
Messages
4
What you mentioned was applied and the result was correct after three queries Can we do it with a pivot query?
 

Attachments

  • OutChickDaysNew.accdb
    736 KB · Views: 59

Users who are viewing this thread

Top Bottom