Pulling Active Suppliers by year

[Marc]

I have a database that holds suppliers data. In my my table I have radio
buttons "active", "inactive". If the supplier was active since 2005 and I
wanted all the active suppliers for the year 2007 and the supplier from 2005
was still active in 2007 how can I get the 2005 supplier to show up in a
query. I'm trying to avoid having to add the year on each active supplier
each year. This is kind of hard to explain but any ideas on the best way to
do this would be greatly appreciated. Let me know if I need to clarify
anything.

Thanks
Marc

 

[John Spencer]

How do you determine if a supplier is active? Is this based on whether or not
you have ordered from the supplier within a certain time frame, a field that
is checked or a date that is entered? Or ????

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[KARL DEWEY]

Using only the radio button you can only tell if they are active at the
present time but not when they became active or went inactive. You need two
datetime fields - ActiveDate & InactiveDate.

 

[Marc]

Using the active Date and inactive date makes sense but if the active date
started in 2005 and the supplier was still active in 2007 and I wanted to see
all suppliers that are active in 2007 how should I write a query for that.

 

[KARL DEWEY]

SELECT Report_Date: [Enter report year]
FROM YourTable
WHERE [Enter report year] Between [ActiveDate] And [InactiveDate];