Criteria Filter

  • Thread starter Thread starter LTOSH
  • Start date Start date
L

LTOSH

I have a database with a column that figures delinquent payment by how many
months delinquent based on their last payment.

now i am wanting to run a report where i tell it to give me a list that are
3 months delinquent but i want to be able to have a pop-up window to ask me
'by how many months' do i want to search.

how do i put this in the criteria of my query? I have tried "> [type
number]" but it does not give me correct results. if i just put in the
criteria ">3" it gives me the right results but i want to be able to type in
other month ranges.

I hope i made sense.
Thanks!
LTOSH
 
How are the results incorrect?

What data type is the field that stores the delinquent information?

What does the data in that field look like?

Have you defined the [type number] parameter as the same data type as the
delinquent information field?
 
Try >=[type number] and it should work. If not then >=Val([Type number])
should.
Or declare the parameter by opening in design view and clicking on Parameter
and entering [Type number] and Data Type as number. To make sure I do
not make a mistake in typing I copy from the criteria and paste in the
parameter row.
 
Great!!! Thanks for quick response...the >=Val([Type Number]) worked
perfectly!!!

If i wanted to make it a range criteria..say for example >2 <4 how would i
write that??

Leslie

KARL DEWEY said:
Try >=[type number] and it should work. If not then >=Val([Type number])
should.
Or declare the parameter by opening in design view and clicking on Parameter
and entering [Type number] and Data Type as number. To make sure I do
not make a mistake in typing I copy from the criteria and paste in the
parameter row.

--
Build a little, test a little.


LTOSH said:
I have a database with a column that figures delinquent payment by how many
months delinquent based on their last payment.

now i am wanting to run a report where i tell it to give me a list that are
3 months delinquent but i want to be able to have a pop-up window to ask me
'by how many months' do i want to search.

how do i put this in the criteria of my query? I have tried "> [type
number]" but it does not give me correct results. if i just put in the
criteria ">3" it gives me the right results but i want to be able to type in
other month ranges.

I hope i made sense.
Thanks!
LTOSH
Click to expand...
Click to expand...
 
Best way --
Between [Enter start] AND [Enter end]
You can enter the same number at both prompts for single digit requirement.

--
Build a little, test a little.


LTOSH said:
Great!!! Thanks for quick response...the >=Val([Type Number]) worked
perfectly!!!

If i wanted to make it a range criteria..say for example >2 <4 how would i
write that??

Leslie

KARL DEWEY said:
Try >=[type number] and it should work. If not then >=Val([Type number])
should.
Or declare the parameter by opening in design view and clicking on Parameter
and entering [Type number] and Data Type as number. To make sure I do
not make a mistake in typing I copy from the criteria and paste in the
parameter row.

--
Build a little, test a little.


LTOSH said:
I have a database with a column that figures delinquent payment by how many
months delinquent based on their last payment.

now i am wanting to run a report where i tell it to give me a list that are
3 months delinquent but i want to be able to have a pop-up window to ask me
'by how many months' do i want to search.

how do i put this in the criteria of my query? I have tried "> [type
number]" but it does not give me correct results. if i just put in the
criteria ">3" it gives me the right results but i want to be able to type in
other month ranges.

I hope i made sense.
Thanks!
LTOSH
Click to expand...
Click to expand...
Click to expand...
 
Back
Top