473,703 Members | 2,898 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Report Trouble

I currently have a form "VIEW ALL ASSIGNMENTS" containing a subform
with record source "qryVIEWALLASSI GNMENTS. This query filters the
database based on two combo boxes on the form containing dates ([DATE1]
& [DATE2])

The idea is: "Please show me all assignments from [DATE1] through
[DATE2].

Here is my SQL Code for that:

SELECT ProjectInformat ion.EventType, ProjectInformat ion.ProjectName ,
ProjectInformat ion.ProjectDesc ription,
ProjectInformat ion.ProjectStar tDate, ProjectInformat ion.ProjectEndD ate,
ProjectInformat ion.Status, ProjectInformat ion.ProjectOwne r,
Sum(HoursWorked .HoursWorked) AS SumOfHoursWorke d
FROM HoursWorked INNER JOIN ProjectInformat ion ON
HoursWorked.Pro jectName = ProjectInformat ion.ProjectName
GROUP BY ProjectInformat ion.EventType, ProjectInformat ion.ProjectName ,
ProjectInformat ion.ProjectDesc ription,
ProjectInformat ion.ProjectStar tDate, ProjectInformat ion.ProjectEndD ate,
ProjectInformat ion.Status, ProjectInformat ion.ProjectOwne r
HAVING (((ProjectInfor mation.ProjectS tartDate)>=[DATE1] And
(ProjectInforma tion.ProjectSta rtDate)<=[DATE2]))
ORDER BY ProjectInformat ion.ProjectStar tDate,
ProjectInformat ion.Status, ProjectInformat ion.ProjectOwne r;

The form and query work great! Now I am trying to create a "Printer
Friendly" report of the same information. However, when I try to
"Preview" the report, it creates a pop-up box asking for [DATE1] and
[DATE2]. For lack of words, it seems the report is not referencing
[DATE1] and [DATE2] in the query which is not referencing [DATE1] and
[DATE2] in the form.

Any suggestions would be greatly appreciated!

Feb 7 '06 #1
3 1334
Gox
dr******@gmail. com wrote:
I currently have a form "VIEW ALL ASSIGNMENTS" containing a subform
with record source "qryVIEWALLASSI GNMENTS. This query filters the
database based on two combo boxes on the form containing dates ([DATE1]
& [DATE2])

The idea is: "Please show me all assignments from [DATE1] through
[DATE2].

Here is my SQL Code for that:

SELECT ProjectInformat ion.EventType, ProjectInformat ion.ProjectName ,
ProjectInformat ion.ProjectDesc ription,
ProjectInformat ion.ProjectStar tDate, ProjectInformat ion.ProjectEndD ate,
ProjectInformat ion.Status, ProjectInformat ion.ProjectOwne r,
Sum(HoursWorked .HoursWorked) AS SumOfHoursWorke d
FROM HoursWorked INNER JOIN ProjectInformat ion ON
HoursWorked.Pro jectName = ProjectInformat ion.ProjectName
GROUP BY ProjectInformat ion.EventType, ProjectInformat ion.ProjectName ,
ProjectInformat ion.ProjectDesc ription,
ProjectInformat ion.ProjectStar tDate, ProjectInformat ion.ProjectEndD ate,
ProjectInformat ion.Status, ProjectInformat ion.ProjectOwne r
HAVING (((ProjectInfor mation.ProjectS tartDate)>=[DATE1] And
(ProjectInforma tion.ProjectSta rtDate)<=[DATE2]))
ORDER BY ProjectInformat ion.ProjectStar tDate,
ProjectInformat ion.Status, ProjectInformat ion.ProjectOwne r;

The form and query work great! Now I am trying to create a "Printer
Friendly" report of the same information. However, when I try to
"Preview" the report, it creates a pop-up box asking for [DATE1] and
[DATE2]. For lack of words, it seems the report is not referencing
[DATE1] and [DATE2] in the query which is not referencing [DATE1] and
[DATE2] in the form.

Any suggestions would be greatly appreciated!


Instead [DATE1] use:
Forms![VIEW ALL ASSIGNMENTS]![DATE1]

and analogous:

Forms![VIEW ALL ASSIGNMENTS]![DATE2]

--
Gox
Feb 7 '06 #2
Which [DATE1] should be edited? In the Query?

Feb 7 '06 #3
Nevermind, I got that to work.

Here is something I would like to ADD. What if I want to further
filter by a ComboBox [CurrentUser]?

I tried the same logic, but will not work

Feb 7 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2862
by: Gudni G. Sigurdsson | last post by:
Hi. I am working on a program for the .NET Framework written in C# with Visual Studio .NET. With this program, one can print a report realized with the Crystal Report software included with VS .NET. This has all been working fine until recently, when I had to install and run the program on more computers. Then I suddenly start getting error messages like: 'Cannot find KeycodeV2.dll, or invalid keycode'. The .NET framework is, of...
1
17666
by: Nathan Bloomfield | last post by:
Does anyone know if there is any documentation which relates to Access2k + ? or can anyone help adjust the code? I am having trouble converting the DAO references. TITLE :INF: How to Create a Dynamic Crosstab Report PRODUCT :Microsoft Access PROD/VER:1.00 1.10 OPER/SYS:WINDOWS
15
13329
by: Mark C | last post by:
All, I have exhaustingly been looking through the newsgroups in search of a way to systemically output an Access 97 report to a pdf file using the full version of Adobe Acrobat. I want the user to be able to click a button and have the Access report saved as a pdf in a directory specified by me the programmer. I have seen a posting by John Baker promoting a web-sight that has an mde that one can reference in any database but after 30...
2
2203
by: Keith Wilby | last post by:
A97 I have a report/sub-report setup and for some records in the main report, the sub-report is blank. I want to set the height of the sub-report to zero where it is blank. I've set all the "Can shrink" properties to 'yes' but I'm having trouble with the syntax referencing the text boxes on the sub- report. I get run-time error 2445 (you entered an expression that has an invalid reference to the property form/report) on the first line...
15
4398
by: Richard Hollenbeck | last post by:
I tried to ask this question before on the 14th of January but I never got a reply. I'm still struggling with the problem. I'll try to rephrase the question: I have a crosstab query with rows of students and columns of activities and the data are the students' scores in each activity. No problem, almost. The problem is that there are five classes at the moment and will be more classes (or courses) in future semesters. I don't want...
3
4081
by: chrisse_2 | last post by:
Hey, In my database i have images, linked to the database, corresponding to different records. I am having trouble making them show in the report. At the moment i can only get the one picture to show everytime. There is a catch to the situation; the report is constructed in such a way in that it doesn't have anything in the record source field. I would greatly appreciate some help.
5
3352
by: David L. | last post by:
I'm running into a frustrating problem. ASP.NET 2.0 web application, against SQL'05, I'm trying to run a report against a 'table provider' (query) that excutes well within SQL MGT studio, and within the data environment. However, when the report is executed in a web report viewer, the report engine comes back with: An error has occurred during report processing.
3
2094
by: pv1 | last post by:
Hello, I am somewhat new to Access and vba, but am trying to complete a request that has been made of me. Access version 2002 WindowsXP. At this point these text boxes are bound to the table memo field. I have located Stephen Lebans code to limit enter of text field based on characters entered and code to limit text based upon width of a text box (this seems to be most applicable for single line text box). I am have trouble putting...
4
5881
by: Henrootje | last post by:
I have a REPORT with in it a subFORM Now I have this label (lblMonth) that I want to change. How should I do this? What would be the proper event to do this? The lblMonth should contain the name of the month as jan 07 Any ideas?
1
2090
by: dontbe | last post by:
Hi Guys, I'm newbie in this forum,.. and i'm having trouble with Data Report. I've been read about How to Create Dynamic Report (thanks to Creative1). But now i have some other trouble (sorry about my English). Here's the case: 1. I create a report for sales inventory, from two table Master_head an Mst_inv, heres the query SELECT I.`TANGGAL`, I.`PLU`, I.`Q_FIRST_I`, I.`Q_REC_I`, I.`Q_RET_I`, (I.`Q_KRP_I` - I.`Q_KRM_I`) As Koreksi,...
0
8749
marktang
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...
0
9243
Oralloy
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...
0
9109
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9002
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7853
agi2029
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...
1
6585
isladogs
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...
0
4420
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...
1
3113
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2057
bsmnconsultancy
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...

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.