Criteria Filter

[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

 

[Jerry Whittle]

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?

 

[KARL DEWEY]

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.

 

[LTOSH]

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

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.

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

 

[KARL DEWEY]

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.

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

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.

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