I'm sorry if this is confusing, but I am relatively new to Access and I can't
figure this out through Help.

I'm creating a museum database with data entered through a form. The
pertinent information for this question are fields "Collections", "Date
Entered", "Session #", and "Item #". Each entry can be from only 1
collection. Each collection can only have 1 session per day, but does won't
have one every day. Each Item # is dependent on the session (i.e. Item# 6
from Session 2). There are duplicates of every field because every collection
has multiple entries, there are multiple entries each day, the Session #s
begin at 1 for each Collection and the Item #s begin at 1 for each Session.

What I need it to do is see what Collection it is, then: If the most recent
Session was from the current date, Session # stays the same and Item # is
plus 1. If the most recent session was not the current date, Session # is
plus 1 and Item# is 1. Then I need these results to automatically be entered
and stored through the form. Is this possible?

I've tried queries, filters and tried to under stand the Iif and Lookup
functions and I am lost.
Thanks for any help in advance.
-Ben Banyas