473,320 Members | 1,832 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to get values from Criteria through Query on Report?

43 32bit


I want to get both these Dates i.e. From Date and To Date on my report using criteria. How it possible??
Attached Images
File Type: jpg Corel.jpg (60.0 KB, 354 views)
Jul 4 '15 #1
1 1235
jimatqsi
1,271 Expert 1GB
One way is to add parameters to the query the report is based on. If the field to be tested is called SaleDate, in the query add
Between [From Date] and [To Date]
in the criteria row for SaleDate. Popup messages will ask for those date values when the report is run.

As with anything in programming, there's X other ways to do the same thing.

Jim
Jul 4 '15 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Faraz Ahmed | last post by:
is there a way to do inner join on null values in crystal report designer... in current scenario its not returing any rows if null values found.... as we can do that in query like x inner join...
2
by: bhavik | last post by:
hi i want to know how to hide the values in query string in ASP.net. here i want to send the values from one page to another page through query string with out explicitly visible the values in...
2
by: Miguel | last post by:
I have followed the advice noted throughout this group for capturing parameter values in a report header. It works, but the parameter dialog box appears twice,once for the query and once for the...
1
by: allie357 | last post by:
I am trying to add a form with a combo box to an existing parameter query report. I followed the directions from this link:http://office.microsoft.com/en-us/assistance/HA011170771033.aspx ...
3
by: sfjnet | last post by:
Hi I am relatively new to Access so I hope I am not embarrassing myself with this question. I have created a database showing contract details (contract number, contractors, dates, other...
6
by: pukhton | last post by:
Hello~ Just a quick question about Access Reports. I want to have a form for user where they will have two textbox and one combo box to pick from and run the query based on that. 1 txtbox is...
6
by: billelev | last post by:
This is probably very easy, but I can't see how you would do this... I have a table that is used as a source table for a report. The table contains percentage values. In the report, I would like...
6
beacon
by: beacon | last post by:
Hi everybody, I've created custom parameter dialog boxes before that will call a report, which calls the underlying query, and passes the parameters accordingly, but I'm having trouble with...
2
by: Jeffrey Tan | last post by:
Hi there.. So i am trying to email a parameter query report that takes in a date formatted to m/yyyy and compiles a report based on the specific month and year. however, when i click the...
5
by: jcrist30 | last post by:
I have a report with several fields/text boxes that are used to determine the values of various report/field totals. Everything is calculating and populating the fields correctly when I view the...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.