Report range by a specific data

[jppigao]

Hello and a blessed day!

I have created a database in our office and i am kinda stock because
in the report i want to have a range of data and not a date. I want to
specify a certain number from and to, it goes something like this:

Specify range of numbers:
Start: (user will define), ie. 9000
End: (user will define), ie. 9100

and when the user press the Ok button a report that i have created
will display the result only the Delivery Note Numbers from 9000 to
9100.

If you can provide me a code that will be more appreciated.

Thank you!

John Paul A. Pigao

 

[Al Campagna]

John,
There are several ways to do this. Probably the most simple method
would be to use a "parameter" query.
Use a query as the RecordSource of your report.
In Query Design mode, use this criteria against the DeliveryNoteNo
field...
Between [Enter Starting Number] And [Enter Ending Nuimber]
When the report is run, the query realizes that it has no idea what
[Enter Starting Number] And [Enter Ending Nuimber] are, so it opens a Input
box for each undefined value. You enter a statrting number (9000) in one
input box, and 9100 in the second Input box.
Those enetered values will filter the query's recordset, and the report
will only display records that meet that criteria.

--
hth
Al Campagna
Microsoft Access MVP
Candia Computer Consulting

http://home.comcast.net/~cccsolutions/index.html

 

[jppigao]

Thanks Al that was perfect indeed.

Al i have an addition to my question maybe i forgot to tell you this.
I have created a small dialog box where the user will input the
starting number and the ending number and what i want is that when i
press the ok button in that dialog box that's the time the report will
open and display the range of numbers that i wanted. Is that possible?

I appreciate your help sir if you can provide me a code for this.

Once again thank you.

John Paul

John,
There are several ways to do this. Probably the most simple method
would be to use a "parameter" query.
Use a query as the RecordSource of your report.
In Query Design mode, use this criteria against the DeliveryNoteNo
field...
Between [Enter Starting Number] And [Enter Ending Nuimber]
When the report is run, the query realizes that it has no idea what
[Enter Starting Number] And [Enter Ending Nuimber] are, so it opens a Input
box for each undefined value. You enter a statrting number (9000) in one
input box, and 9100 in the second Input box.
Those enetered values will filter the query's recordset, and the report
will only display records that meet that criteria.

--
hth
Al Campagna
Microsoft Access MVP
Candia Computer Consulting

Hello and a blessed day!

I have created a database in our office and i am kinda stock because
in the report i want to have a range of data and not a date. I want to
specify a certain number from and to, it goes something like this:

Specify range of numbers:
Start: (user will define), ie. 9000
End: (user will define), ie. 9100

and when the user press the Ok button a report that i have created
will display the result only the Delivery Note Numbers from 9000 to
9100.

If you can provide me a code that will be more appreciated.

Thank you!

John Paul A. Pigao- Hide quoted text -

- Show quoted text -

 

[Al Campagna]

John Paul,
Are you saying that you have a dialog form opened (ex. frmMyDialog), with
2 fields (ex. StartDeliveryNo and EndDeliveryNo)?
If so, change the criteria (against DeliveryNoteNo) in your report query
to...

Between Forms!frmMyDialog!StartDeliveryNo And
Forms!frmMyDialog!EndDeliveryNo
(all on one line..)

When you open the report, the query behind your report will run, and it
will look to the Open frmMyDialog for the 2 values.
it needs. The report will only display records that lie within those 2
values.
While you're building and testing this setup... use

DoCmd.OpenReport "YourReportName", acViewPreview

--
hth
Al Campagna
Microsoft Access MVP
Candia Computer Consulting
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."

Thanks Al that was perfect indeed.

Al i have an addition to my question maybe i forgot to tell you this.
I have created a small dialog box where the user will input the
starting number and the ending number and what i want is that when i
press the ok button in that dialog box that's the time the report will
open and display the range of numbers that i wanted. Is that possible?

I appreciate your help sir if you can provide me a code for this.

Once again thank you.

John Paul

John,
There are several ways to do this. Probably the most simple method
would be to use a "parameter" query.
Use a query as the RecordSource of your report.
In Query Design mode, use this criteria against the DeliveryNoteNo
field...
Between [Enter Starting Number] And [Enter Ending Nuimber]
When the report is run, the query realizes that it has no idea what
[Enter Starting Number] And [Enter Ending Nuimber] are, so it opens a
Input
box for each undefined value. You enter a statrting number (9000) in one
input box, and 9100 in the second Input box.
Those enetered values will filter the query's recordset, and the
report
will only display records that meet that criteria.

--
hth
Al Campagna
Microsoft Access MVP
Candia Computer Consulting

in message

Hello and a blessed day!

I have created a database in our office and i am kinda stock because
in the report i want to have a range of data and not a date. I want to
specify a certain number from and to, it goes something like this:

Specify range of numbers:
Start: (user will define), ie. 9000
End: (user will define), ie. 9100

and when the user press the Ok button a report that i have created
will display the result only the Delivery Note Numbers from 9000 to
9100.

If you can provide me a code that will be more appreciated.

Thank you!

John Paul A. Pigao- Hide quoted text -

- Show quoted text -

 

[Al Campagna]

John Paul,
Also... if (e-mail address removed) is a real email address, then you're
leaving yourself wide open for spammers to harvest your email address.
In your newsgroup account in your email program, use a dummy return
email... like
jp@newsgroups
--
hth
Al Campagna
Microsoft Access MVP
Candia Computer Consulting
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."

Thanks Al that was perfect indeed.

Al i have an addition to my question maybe i forgot to tell you this.
I have created a small dialog box where the user will input the
starting number and the ending number and what i want is that when i
press the ok button in that dialog box that's the time the report will
open and display the range of numbers that i wanted. Is that possible?

I appreciate your help sir if you can provide me a code for this.

Once again thank you.

John Paul

John,
There are several ways to do this. Probably the most simple method
would be to use a "parameter" query.
Use a query as the RecordSource of your report.
In Query Design mode, use this criteria against the DeliveryNoteNo
field...
Between [Enter Starting Number] And [Enter Ending Nuimber]
When the report is run, the query realizes that it has no idea what
[Enter Starting Number] And [Enter Ending Nuimber] are, so it opens a
Input
box for each undefined value. You enter a statrting number (9000) in one
input box, and 9100 in the second Input box.
Those enetered values will filter the query's recordset, and the
report
will only display records that meet that criteria.

--
hth
Al Campagna
Microsoft Access MVP
Candia Computer Consulting

in message

Hello and a blessed day!

I have created a database in our office and i am kinda stock because
in the report i want to have a range of data and not a date. I want to
specify a certain number from and to, it goes something like this:

Specify range of numbers:
Start: (user will define), ie. 9000
End: (user will define), ie. 9100

and when the user press the Ok button a report that i have created
will display the result only the Delivery Note Numbers from 9000 to
9100.

If you can provide me a code that will be more appreciated.

Thank you!

John Paul A. Pigao- Hide quoted text -

- Show quoted text -

 

[jppigao]

Al this is extremely perfect and i got to thank you a million times
for me to finish this task. I think i need to focus myself studying
more about query since query module is very powerful. Do you have any
link or website where i can find different tags on query criteria? or
it is just a matter of defining a specific data that you wanted to
have? Is there any code to be followed for it to work?

Hey Al good job! God bless!

John Paul,
Also... if (e-mail address removed) is a real email address, then you're
leaving yourself wide open for spammers to harvest your email address.
In your newsgroup account in your email program, use a dummy return
email... like
jp@newsgroups
--
hth
Al Campagna
Microsoft Access MVP
Candia Computer Consultinghttp://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."

Thanks Al that was perfect indeed.

Al i have an addition to my question maybe i forgot to tell you this.
I have created a small dialog box where the user will input the
starting number and the ending number and what i want is that when i
press the ok button in that dialog box that's the time the report will
open and display the range of numbers that i wanted. Is that possible?

I appreciate your help sir if you can provide me a code for this.

Once again thank you.

John Paul

John,
There are several ways to do this. Probably the most simple method
would be to use a "parameter" query.
Use a query as the RecordSource of your report.
In Query Design mode, use this criteria against the DeliveryNoteNo
field...
Between [Enter Starting Number] And [Enter Ending Nuimber]
When the report is run, the query realizes that it has no idea what
[Enter Starting Number] And [Enter Ending Nuimber] are, so it opens a
Input
box for each undefined value. You enter a statrting number (9000) in one
input box, and 9100 in the second Input box.
Those enetered values will filter the query's recordset, and the
report
will only display records that meet that criteria.
--
hth
Al Campagna
Microsoft Access MVP
Candia Computer Consulting
in message

Hello and a blessed day!
I have created a database in our office and i am kinda stock because
in the report i want to have a range of data and not a date. I want to
specify a certain number from and to, it goes something like this:
Specify range of numbers:
Start: (user will define), ie. 9000
End: (user will define), ie. 9100
and when the user press the Ok button a report that i have created
will display the result only the Delivery Note Numbers from 9000 to
9100.
If you can provide me a code that will be more appreciated.
Thank you!
John Paul A. Pigao- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -

 

[Al Campagna]

John Paul,
Any Access reference book would probably give you the basics on how to
create queries, and develop criteria that effectively limits, or filters,
the records that you will deliver to the report.
Use the Access Query Design mode to select the tables and the field data
you want on your report, and use the query criteria to control the records
output to the report. Query Design insulates the new user from having to
create SQL statements.
You could try searching the web for more information on queries
("Microsoft Access" "query design"), or you could search these newsgroups
for solutions to questions on criteria... but probably any Access reference
book would be just as good.

--
hth
Al Campagna
Microsoft Access MVP
Candia Computer Consulting
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."

Al this is extremely perfect and i got to thank you a million times
for me to finish this task. I think i need to focus myself studying
more about query since query module is very powerful. Do you have any
link or website where i can find different tags on query criteria? or
it is just a matter of defining a specific data that you wanted to
have? Is there any code to be followed for it to work?

Hey Al good job! God bless!

John Paul,
Also... if (e-mail address removed) is a real email address, then you're
leaving yourself wide open for spammers to harvest your email address.
In your newsgroup account in your email program, use a dummy return
email... like
jp@newsgroups
--
hth
Al Campagna
Microsoft Access MVP
Candia Computer
Consultinghttp://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."

Thanks Al that was perfect indeed.

Al i have an addition to my question maybe i forgot to tell you this.
I have created a small dialog box where the user will input the
starting number and the ending number and what i want is that when i
press the ok button in that dialog box that's the time the report will
open and display the range of numbers that i wanted. Is that possible?

I appreciate your help sir if you can provide me a code for this.

Once again thank you.

John Paul

John,
There are several ways to do this. Probably the most simple
method
would be to use a "parameter" query.
Use a query as the RecordSource of your report.
In Query Design mode, use this criteria against the DeliveryNoteNo
field...
Between [Enter Starting Number] And [Enter Ending Nuimber]
When the report is run, the query realizes that it has no idea
what
[Enter Starting Number] And [Enter Ending Nuimber] are, so it opens a
Input
box for each undefined value. You enter a statrting number (9000) in
one
input box, and 9100 in the second Input box.
Those enetered values will filter the query's recordset, and the
report
will only display records that meet that criteria.

--
hth
Al Campagna
Microsoft Access MVP
Candia Computer Consulting

http://home.comcast.net/~cccsolutions/index.html<[email protected]>
wrote
in message

Hello and a blessed day!

I have created a database in our office and i am kinda stock because
in the report i want to have a range of data and not a date. I want
to
specify a certain number from and to, it goes something like this:

Specify range of numbers:
Start: (user will define), ie. 9000
End: (user will define), ie. 9100

and when the user press the Ok button a report that i have created
will display the result only the Delivery Note Numbers from 9000 to
9100.

If you can provide me a code that will be more appreciated.

Thank you!

John Paul A. Pigao- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -