"Effective Date" Criteria for Rates
Van,
I have it figured out, I used a combination of 3 queries.
Jason
"Van T. Dinh" wrote:
Jason
I have been very busy with the contract work (which pays!) so I haven't been
on Utter Access. I am surprised that no one in Utter Access replied to
your question with the test database. "DougY" actually did a fair bit of
work with the thread I referred to previously. Unfortunately, your question
is not something that we can answer quickly. Generally, the SQL needs to be
tested to be sure it works correctly.
If I have a chance tonight - Friday (not a promise as we are implement a new
version of the database), I have a look at your database. Paid work, of
course, comes first.
--
HTH
Van T. Dinh
MVP (Access)
"Jason V" wrote in message
...
Van,
I have posted a thread with my DB attached like you suggested I do. I
don't
mean to pressure you, I just hope that you haven't forgotten about
me.....you
are my last hope and I am running out of time to complete this darn thing.
I
would really appreciate any feedback.
Thanks,
Jason
|