[AccessD] Unmatched query problem

You might have to write a little noddy which would loop through a query
finding wells that were inactive on any date between two given dates. You
could output wither to another table in the database, or (simpler!) to a CSV
file that you then printed in a pretty Excel report.

On 21/09/05, Arthur Fuller <artful at rogers.com> wrote:
>
> I wonder if you've got enough data in the Wells_Active table. I'm thinking
> that a well has both a DateActivated and a DateTerminated column, but
> perhaps this is irrelevant to your needs. Assuming from your description
> that you care only about when the well was activated, flip the query
> around
> (of ease of comprehension).
> SELECT * FROM Wells_Active INNER JOIN Wells ON WellsActive.WellID =
> Wells.WellID
> WHERE Wells_Active.DateActivated < [Enter a date]
> If you have a DateTerminated column in addition (note the adroit avoidance
> of "as well"), then you want to compare against both dates.
>
> HTH,
> Arthur
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
> Sent: September 21, 2005 12:24 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Unmatched query problem
>
> I have one master table of well numbers. In another table I have well
> numbers of wells that are active by date. I need to gat a list of wells
> that are not active on each date. The unmatched query wizard does not
> care about the date. How might I do this? Thanks
>
>
>
> Chester Kaup
>
> Engineering Technician
>
> Kinder Morgan CO2 Company, LLP
>
> Office (432) 688-3797
>
> FAX (432) 688-3799
>
>
>
>
>
> No trees were killed in the sending of this message. However a large
> number of electrons were terribly inconvenienced.
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



--
--
Eoin C. Bairéad
Dublin, Ireland
Áth Cliath, Éire