Hello I have attempted to create a date range report from a query called qrycustomerinfo rmation. The field that contains the value of my date is called Followup. When i run a report on this it is fine. But I have decided I would like to pull this report for a specific date range. Ive attempted to use the method on allen brownes page http://allenbrowne.com/casu-08.html. I would like to also mention the followup field also uses this code to generate a date three months from the date the record is entered =DateAdd("m",3,[Date]). When enter a date range for the report it accepts the range but opens the report with no information on it. When I open the report without the date range method it show me all my records just fine. Im thinking that for some reason that the date range form is not pulling from the field followup. I hope you can understand. What can I do to fix this or is there another method that I can go about creating this date range report?
19 3926
Hi, I think I just had the same issue you are having now. Look at this and tell me if its similar to what your trying to do.
http://www.thescripts. com/forum/showthread.php? p=2771747#post2 771747
Scotter
I am trying to do a similiar thing, but when I pull my reports they come up blank.
Ok, so your report is based on a query correct? And are you putting the date into a form and then runing the report, or no?
If you are using a form, are you doing the same kinda thing where your building your SQL within the form? and what is your querries SQL?
Scotter
Ok, so your report is based on a query correct? And are you putting the date into a form and then runing the report, or no?
If you are using a form, are you doing the same kinda thing where your building your SQL within the form? and what is your querries SQL?
Scotter
Yes my report is based on a query. Is this what your asking for
SELECT tblcustomerinfo rmation.Custome rID, tblcustomerinfo rmation.[File Status], tblcustomerinfo rmation.[Contact Number], tblcustomerinfo rmation.First, tblcustomerinfo rmation.Last, tblcustomerinfo rmation.Street, tblcustomerinfo rmation.State, tblcustomerinfo rmation.City, tblcustomerinfo rmation.[Zip Code], tblcustomerinfo rmation.Verific ation, tblcustomerinfo rmation.Consult ant, tblcustomerinfo rmation.Closer, tblcustomerinfo rmation.Opener, tblcustomerinfo rmation.Date, tblcustomerinfo rmation.Followu p
FROM tblcustomerinfo rmation;
Yes my report is based on a query. Is this what your asking for
SELECT tblcustomerinfo rmation.Custome rID, tblcustomerinfo rmation.[File Status], tblcustomerinfo rmation.[Contact Number], tblcustomerinfo rmation.First, tblcustomerinfo rmation.Last, tblcustomerinfo rmation.Street, tblcustomerinfo rmation.State, tblcustomerinfo rmation.City, tblcustomerinfo rmation.[Zip Code], tblcustomerinfo rmation.Verific ation, tblcustomerinfo rmation.Consult ant, tblcustomerinfo rmation.Closer, tblcustomerinfo rmation.Opener, tblcustomerinfo rmation.Date, tblcustomerinfo rmation.Followu p
FROM tblcustomerinfo rmation;
Ok, try adding WHERE ((([tblcustomerinfo rmation].[Followup])>mydate)); so the last line will look like -
FROM tblcustomerinformation WHERE ((([tblcustomerinformation].[Followup])>mydate));
-
Now when you run the report a box should come up asking what mydate is, put in a date that comes before a certian date of one of the records you are looking for and you should get some results. Try that and well see what happens, I'm pretty new to this myself so lets see if we can struggle through :)
Ok, try adding WHERE ((([tblcustomerinfo rmation].[Followup])>mydate)); so the last line will look like -
FROM tblcustomerinformation WHERE ((([tblcustomerinformation].[Followup])>mydate));
-
Now when you run the report a box should come up asking what mydate is, put in a date that comes before a certian date of one of the records you are looking for and you should get some results. Try that and well see what happens, I'm pretty new to this myself so lets see if we can struggle through :)
I did that and it did not prompt for any date?
you put it into the SQL view of the Query the report is based on?
Yes I did insert it into the sql view.
Thank You
Yes I did insert it into the sql view.
Thank You
Please indicate the exact results you got after placing the code that Scotter suggested. Did the query run? Did you get an error message?
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Garyrek |
last post by:
Hi
I have a requirement where I need to make a report for each auto dealer how many hits they got on specified date range, so for each car detail page I increment the counter and total it while doing that I store the last hit date, this gives the total hits for the dealer BUT does not facilitate date range
How do I give the user a date range so that he can check how many hits the dealer got lets say for last week OR last couple of days?
...
|
by: BlackFireNova |
last post by:
Using Access 2002
I am writing a report which draws data from several different tables. I
can't link all the tables in a query, as some can not be related without
truncating the data. I plan to use sub-queries and sub-reports to
filter and display the data in the unrelated tables in my report. The
common information is a user-inputed date range.
I want to avoid having the user prompted for the and
variables repeatedly. Somehow I...
|
by: Sara |
last post by:
I have followed instructions on the http://allenbrowne.com/tips.html
for limiting a report to a date range. At the bottom there is a note
that says
You will end up using this form for all sorts of reports. You may add
an option group or list box that selects which report you want printed,
and a check box that determines whether the report should be opened in
preview mode.
I have tried several times to do this but can't figure it out....
|
by: Cyberdyne |
last post by:
Here is the problem,
I have a form with a field named Occurence with a Short Date Value, once entered it subsequently appears in 3 fields SOL1 which adds one year, SOL2 which adds 2 years and SOL6M which adds 6 month to the date entered in the Occurence field, this is done with the following Controls:
=DateAdd("yyyy",1,)
=DateAdd("yyyy",2,)
=DateAdd("m",6,)
The problem is that the data in the SOL1, SOL2, and SOL6M does not show up...
|
by: irfanali |
last post by:
Hallo All,
This is a Tool i m tryin to develop at work.
I will explain how it works and then the Q
I download a report from my ERP Tool on a daily basis and upload it into the Access Tool. This report gives me the accounting bookings made on a daily basis. So it has fields like Invoice Nr, Invoice Amount, and Date.
Well, then i have a Duplicate Query set up to give me a report for all Duplicates...and then i download it into an...
| |
by: kmnotes04 |
last post by:
Could anyone tell me how to restrict the date range for items that
appear on a report? Old items from previous years appear on the
report. I was asked to have only this year's items (and beyond) listed
on the report. How do I do that?
|
by: dozingquinn |
last post by:
Hello,
Is there any way to auto populate the user defined date range into a report? I currently have the criteria "Between And " for a date range field. This prompts the user to enter a date range before the report is visible.
Is it possible to capture this date range and display it on the report?
I am using Access 97
Thanks!
|
by: jambonjamasb |
last post by:
I am wanting to create a report that summarises the number of items within a date range.
For example I have a FIELD called System_Change.
This is a drop down COMBOBOX that uses words like unix, polfs etc.
I know how to query a date range, but not how to count number of fields within this date range.
I would like the report to show date range filtered then list all changes and number of times they appear.
Thanks in advance anything...
|
by: smithj14 |
last post by:
I have a form to enter start and end dates then select a worker name to filter a report. This all works fine and when the report is open in preview mode it shows the date range in the txtboxes on the report header, but when I print the report the value for these txtboxes are #Name?
Here is the code
Date Range Form:
Private Sub cmdViewErrorReport_Click()
Dim stDocName As String
Dim stDocName2 As String
Dim stWhere As String...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |