Query - ies - Questions

[Bianca]

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

 

[scubadiver]

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?

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

 

[Bianca]

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

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?

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

 

[scubadiver]

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

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

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?

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

 

[Bianca]

Ok thank u very much for that I will try it that way!

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

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

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?

:

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

 

[Bianca]

Hi I just tried it and I get an empty datasheet - what do u think I am doing
wrong here?

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

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

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?

:

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

 

[scubadiver]

I suggest you create two copies of the query.

one with JUST the status criteria to make sure you are only getting 'valid'
records.

A second query with just the dates to make sure you are returning the
records you want ***BUT check the status column to ensure you are return
'valid' records***. If you are getting no records then you have no 'valid'
records for the dates you are returning.

Hi I just tried it and I get an empty datasheet - what do u think I am doing
wrong here?

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

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

:


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?

:

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