automatically having a field filled in based on another field's criteria

[bjsbrown]

Saw a similar recent post but it just sorta ended so couldn't use.



Within a table, I have a field named date and a field named qtr. On the form, I want to automatically fill in the qtr field based on the date field. for ex: if date=>01/01/2010 and date=<03/31/2010; qtr=1. Then if date=>04/01/2010 and date =<06/30/2010, qtr=2, etc, etc. Is this possible? If so, please point me in the right direction. Thanks.

[llkhoutx]

Your on the right track, consider a different column for each quarter.

This must be a problem for a class. I answered a similar post tonight.

[bjsbrown]

No class for me. So do I do this in a query with sql or what. How do I begin. Thanks for responding.

[llkhoutx]

For simplicity, do it in multiple append queries to a temporary stack table, one query for each date interval. Store data in appropriate columns.

Multiple queries may seem to make the solution onerous, but it keeps the solution simple and easy to understand and support.

[bjsbrown]

That's way beyond my beginner's level. Anyway to restate in simplier terms or give examples. Thanks.