Select an Employee 1 114 (5/7/2007 6:06:40 PM)
I need to run a report from a query where I have EmpName, EmpShift, DateComp as fields among others containing information about safety hazards that employee has turned in. So far I have a dialog box set up so...
bhrosey

Calendar Reports 0 150 (5/7/2007 7:13:01 PM)
The department I work in travels very frequently. I have a database that lists everyone in the department and when, where, and for how long they will be traveling in a table. Is there any way to report the ...
Utf

%Chg YTD vs LYTD 0 318 (5/7/2007 6:35:00 PM)
This is a followup to my 4/24 post of YTD Calc in Footer. I was able to modify the function referenced to give me a YTD in the footer. What I want to do is compare my current YTD to Last years YTD (So I am co...
Utf

Can't Assign Value 2 153 (5/7/2007 2:36:20 PM)
I'm trying to assiggn a value to an unbound textbox on a report but I keep getting an error message. Can't Assign Value.... Private Sub Report_Open(Cancel As Integer) If Forms!frmReportDates!TxtStart = F...
DS

Count Field Contents 0 129 (5/7/2007 2:06:01 PM)
Hello, I have four fields call Team1, Team2, Team3 & Team4. Each of the fields are linked to a lookup table that has 22 team names. The database consist of people that can be a part of up to four team. I wish...
Utf

Conditional tests in reports - a reprise 2 109 (5/4/2007 7:12:01 PM)
Let's say I have 3 facilities, and three workeers who share their time between them. I want the report to print out accoding to the example below but I can find no way to do this. Can anyone help? Don --...
Utf

I'm sure this is a stupid question. 6 129 (4/28/2007 1:29:54 PM)
I have a field in my report - =[lastname] & ", " & [firstname] I'd like to suppress the ", " when there is no first name... some of my contacts are offices/businesses/departments & don't have first names. A...
Sue

A lingering question about suppressing ", " in concatenated expression (=lastname&", "&firstname) 1 119 (5/6/2007 11:31:54 PM)
I'm a bit slow on the uptake. 8 days later this is still puzzling me... I love what Allen shared - truly - and it solved my problem, but I have another question. When writing an expression in Access, as I under...
Sue

How to show only the missing acitvity 3 144 (5/5/2007 2:35:06 PM)
I have a form that that lists Jobs with a [Status] field of : "Not Started", "In Process" or "Completed". A subform with 2 fields, [Activity] and [Date]. The [Activity] selections are: "Assigned", "Out on Proo...
Sunflower

Show most recent 2 108 (5/6/2007 4:13:47 AM)
Hi Groupies My database keeps track of training certifications. I need to keep a history of recertification, so I may have the same person listed for the same course but with a different date of training. M...
CJ