If logic??

[Dorianne J via AccessMonster.com]

I have a query that has a parameter of between [start date] and [end date].

1st qtr 2nd qtr 3rd qtr 4th qtr 1st qtr paid 2nd qtr paid 3rd qtr
paid 4th qtr paid
50.00 25.00 100.00 75.00 05/23/2005 09/12/2005 10/23/2005
02/16/2006

When I run this query, I need a way to have the corresponding amount paid to
only show up. EX. I enter start date of 09/01/2005 and end date of
09/30/2005. I would only want 25.00 to show up. Is there anyway to do this?
Does this make sense? Also, I'm not very experienced with Access so any help
in layman terms would be greatly appreciated.

Thank you in advance.

 

[Van T. Dinh]

If [1st qtr], [2nd qtr], ... are Fields in your Table then the database has
an incorrect Table Structure which makes it really hard to manipulate the
data in Access.

See the Microsoft Knowledge Base article:

http://support.microsoft.com/?id=283698

 

[Dorianne J via AccessMonster.com]

I read the article you attached, and the only thing that I got from it was
that same information should be in their own tables. Well, I have done that.
I have tables for bank information, insurance information, company
information as well as fee information. Our fees are paid quarterly to
different banks for different companies that need copies sent to different
state insurance companies. So, my fee table, I thought, was done correctly.
I have changed the field names to [first], [second], etc. Would this help in
being able to accomplish what my first thread asked? If not, I guess that I
am missing what it is that I am doing wrong with my tables. Please advice.

Thank you in advance,
Dorianne

If [1st qtr], [2nd qtr], ... are Fields in your Table then the database has
an incorrect Table Structure which makes it really hard to manipulate the
data in Access.

See the Microsoft Knowledge Base article:

http://support.microsoft.com/?id=283698

I have a query that has a parameter of between [start date] and [end date].

[quoted text clipped - 14 lines]

Thank you in advance.

 

[Van T. Dinh]

You have an incorrect Table structure in that you have repeating groups of
Fields (each group can consist of a single Field).

In addition, the 1st quarter, 2nd quarter, ... are data in your database and
data should be stored in Field values of Records and NOT Field names since
database engine cannot access/process data stored in Field names.

Check out database normalization from:

http://support.microsoft.com/?id=283878

and

http://support.microsoft.com/?id=324613

--
HTH
Van T. Dinh
MVP (Access)

I read the article you attached, and the only thing that I got from it was
that same information should be in their own tables. Well, I have done
that.
I have tables for bank information, insurance information, company
information as well as fee information. Our fees are paid quarterly to
different banks for different companies that need copies sent to different
state insurance companies. So, my fee table, I thought, was done
correctly.
I have changed the field names to [first], [second], etc. Would this help
in
being able to accomplish what my first thread asked? If not, I guess that
I
am missing what it is that I am doing wrong with my tables. Please
advice.

Thank you in advance,
Dorianne

If [1st qtr], [2nd qtr], ... are Fields in your Table then the database
has
an incorrect Table Structure which makes it really hard to manipulate the
data in Access.

See the Microsoft Knowledge Base article:

http://support.microsoft.com/?id=283698

I have a query that has a parameter of between [start date] and [end
date].

[quoted text clipped - 14 lines]

Thank you in advance.