Prev: Where I get an http:// address for Search Point in Access 2007?
Next: summary query
From: Bianca on 24 Jun 2008 05:23
Hello,
I have a table with credit cards and they have asked me to do a forecast for
the next year to see how many cards will be renewed- using the query wizard
thing to make my query - the first field is Status, then there is the
incoming date and the registration date.

For the Status I want it to show only the ones that are valid so I entered
in the critera field "Valid"
The incoming date which is the date the credit card is to be renewed - I
entered
>=[from date] AND <= [to date] - because this changes for every every month
The registration date is just that - and again I entered >=[from date] AND
<= [to date]

I am doing something wrong because the status is coming out all wrong it
shows everything - valid - cancelled etc and it does not ask me for both
dates just the incoming date.

If anyone can tell me what I am doing wrong I would truly appreciate it!
Regards to all
Bianca
From: scubadiver on 24 Jun 2008 05:49

For your 1st question, what is defined as 'valid'?

I noticed you are using the same parameter names for the incoming date AND
the registration date. Wouldn't this affect what rows you retrieve? Or are
the two dates the same anyway?

"Bianca" wrote:

> Hello,
> I have a table with credit cards and they have asked me to do a forecast for
> the next year to see how many cards will be renewed- using the query wizard
> thing to make my query - the first field is Status, then there is the
> incoming date and the registration date.
>
> For the Status I want it to show only the ones that are valid so I entered
> in the critera field "Valid"
> The incoming date which is the date the credit card is to be renewed - I
> entered
> >=[from date] AND <= [to date] - because this changes for every every month
> The registration date is just that - and again I entered >=[from date] AND
> <= [to date]
>
> I am doing something wrong because the status is coming out all wrong it
> shows everything - valid - cancelled etc and it does not ask me for both
> dates just the incoming date.
>
> If anyone can tell me what I am doing wrong I would truly appreciate it!
> Regards to all
> Bianca
From: Bianca on 24 Jun 2008 06:11
Hello scubadiver person and thanks for your reply,

in the status column a card is either valid or cancelled or blocked - so i
want it to show me the valid cards only.
for the second part I suppose I can enter incoming date from and incoming
date to and do the same thing for the registration date to and from - but can
u tell me if it matters if they are both in the same line (in their
perspective columns).
hope this helps - thanking u in advanc

"scubadiver" wrote:

>
> For your 1st question, what is defined as 'valid'?
>
> I noticed you are using the same parameter names for the incoming date AND
> the registration date. Wouldn't this affect what rows you retrieve? Or are
> the two dates the same anyway?
>
> "Bianca" wrote:
>
> > Hello,
> > I have a table with credit cards and they have asked me to do a forecast for
> > the next year to see how many cards will be renewed- using the query wizard
> > thing to make my query - the first field is Status, then there is the
> > incoming date and the registration date.
> >
> > For the Status I want it to show only the ones that are valid so I entered
> > in the critera field "Valid"
> > The incoming date which is the date the credit card is to be renewed - I
> > entered
> > >=[from date] AND <= [to date] - because this changes for every every month
> > The registration date is just that - and again I entered >=[from date] AND
> > <= [to date]
> >
> > I am doing something wrong because the status is coming out all wrong it
> > shows everything - valid - cancelled etc and it does not ask me for both
> > dates just the incoming date.
> >
> > If anyone can tell me what I am doing wrong I would truly appreciate it!
> > Regards to all
> > Bianca
From: scubadiver on 24 Jun 2008 06:21

I think for what you need the criteria for the dates should be on the same
line. Is the status criteria on the same line as well. If you put the status
on a separate line then you will get 'blocked' and 'cancelled' as well.



"Bianca" wrote:

> Hello scubadiver person and thanks for your reply,
>
> in the status column a card is either valid or cancelled or blocked - so i
> want it to show me the valid cards only.
> for the second part I suppose I can enter incoming date from and incoming
> date to and do the same thing for the registration date to and from - but can
> u tell me if it matters if they are both in the same line (in their
> perspective columns).
> hope this helps - thanking u in advanc
>
> "scubadiver" wrote:
>
> >
> > For your 1st question, what is defined as 'valid'?
> >
> > I noticed you are using the same parameter names for the incoming date AND
> > the registration date. Wouldn't this affect what rows you retrieve? Or are
> > the two dates the same anyway?
> >
> > "Bianca" wrote:
> >
> > > Hello,
> > > I have a table with credit cards and they have asked me to do a forecast for
> > > the next year to see how many cards will be renewed- using the query wizard
> > > thing to make my query - the first field is Status, then there is the
> > > incoming date and the registration date.
> > >
> > > For the Status I want it to show only the ones that are valid so I entered
> > > in the critera field "Valid"
> > > The incoming date which is the date the credit card is to be renewed - I
> > > entered
> > > >=[from date] AND <= [to date] - because this changes for every every month
> > > The registration date is just that - and again I entered >=[from date] AND
> > > <= [to date]
> > >
> > > I am doing something wrong because the status is coming out all wrong it
> > > shows everything - valid - cancelled etc and it does not ask me for both
> > > dates just the incoming date.
> > >
> > > If anyone can tell me what I am doing wrong I would truly appreciate it!
> > > Regards to all
> > > Bianca
From: Bianca on 24 Jun 2008 06:30
Ok thank u very much for that I will try it that way!

"scubadiver" wrote:

>
> I think for what you need the criteria for the dates should be on the same
> line. Is the status criteria on the same line as well. If you put the status
> on a separate line then you will get 'blocked' and 'cancelled' as well.
>
>
>
> "Bianca" wrote:
>
> > Hello scubadiver person and thanks for your reply,
> >
> > in the status column a card is either valid or cancelled or blocked - so i
> > want it to show me the valid cards only.
> > for the second part I suppose I can enter incoming date from and incoming
> > date to and do the same thing for the registration date to and from - but can
> > u tell me if it matters if they are both in the same line (in their
> > perspective columns).
> > hope this helps - thanking u in advanc
> >
> > "scubadiver" wrote:
> >
> > >
> > > For your 1st question, what is defined as 'valid'?
> > >
> > > I noticed you are using the same parameter names for the incoming date AND
> > > the registration date. Wouldn't this affect what rows you retrieve? Or are
> > > the two dates the same anyway?
> > >
> > > "Bianca" wrote:
> > >
> > > > Hello,
> > > > I have a table with credit cards and they have asked me to do a forecast for
> > > > the next year to see how many cards will be renewed- using the query wizard
> > > > thing to make my query - the first field is Status, then there is the
> > > > incoming date and the registration date.
> > > >
> > > > For the Status I want it to show only the ones that are valid so I entered
> > > > in the critera field "Valid"
> > > > The incoming date which is the date the credit card is to be renewed - I
> > > > entered
> > > > >=[from date] AND <= [to date] - because this changes for every every month
> > > > The registration date is just that - and again I entered >=[from date] AND
> > > > <= [to date]
> > > >
> > > > I am doing something wrong because the status is coming out all wrong it
> > > > shows everything - valid - cancelled etc and it does not ask me for both
> > > > dates just the incoming date.
> > > >
> > > > If anyone can tell me what I am doing wrong I would truly appreciate it!
> > > > Regards to all
> > > > Bianca
 |  Next  |  Last
Pages: 1 2
Prev: Where I get an http:// address for Search Point in Access 2007?
Next: summary query