Recent content by epoh

What I want is to use the current address (T1.ADDR) that was entered when the customer visits using the latest APPT/VISIT date (T2.APPT_DATE) using the subquery you suggested. Finally taking only one SSN (T1.SSN) where T1.ACCTNO = T2.ACCTNO

Nothing. After further review I just found multiple entries for the same customer. That's because the ACCTNO changes with each visit. I overlooked that. So a 5 time visitor still appears multiple times in the list.

Okay, this is closer but not quite there. I'm trying to get a distinct/unique SSN based on the following: Latest VISIT_DETAIL.APPT_DATE AND VISIT_DETAIL.ACCT_NO & T2.ACCTNO = T1.ACCTNO & the DISTINCT T1.SSN that is in the same row as T1.ACCTNO T1.ACCTNO, T1.SSN, T1.FIRSTNAME, T1.LASTNAME...

I will try this tomorrow when I'm back at work

--CUSTOMER INFO TABLE SELECT T1.ACCTNO, T1.FIRSTNAME, T1.LASTNAME, T1.ADDR, T1.CITY, T1.ST, T1.ZIP, T1.SSN, --VISITOR DATE DETAIL TABLE T2.ACCTNO, T2.REP, T2.APPT_DATE FROM CUST_INFO T1, VISIT_DETAIL T2 WHERE T1.ACCTNO = T2.ACCTNO ORDER BY T2.APPT_DATE DESC What is throwing me off is getting...

Oops, I goofed. T1.FirstName, T1.LastName, T1.SSN, T1.Address, T1.City, T1.ST, T1.ZIP, T2.Date, T2.Rep

I am working on a query that has the following fields T1.FirstName, T1.LastName, T1.SSN, T1.Date, T1.Address, T1.City, T1.ST, T1.ZIP, T2.Rep sample data T1.FirstName, T1.LastName, T1.SSN, T1.Date, T1.Address, T1.City, T1.ST, T1.ZIP, T2.Rep John,Doe,500-22-1234,2010-12-10,123 N...

Well, I would but in the db there are two tables: tbl_SystemName tbl_Tasks There are multiple tasks here with different statuses of these tasks, I am looking for any unfinished task. the header is tbl_SystemName, the detail is a subreport of tbl_Taks

I am trying to clean up a report that displays information about a network resource (resources) and a subreport (tasks) with a basic to-do list. The two reports are linked together by ResourceID. Sample Report (how it looks now): Primary Domain Controller [Group Header] -Install updates...

I am trying to create a report that will skip the header, if there is no data in the detail section. I've looked and haven't found anything yet.

Update: I created a new Trusted location and the issue appears to be resolved.

Update: stranger still. I can run the report with no errors if I don't acknowledge the security warning. But if I run the report after I have enabled the content. I get the #Error in the same report. Any help would be appreciated :(

[Field1] = Field1 [Field2] = Field2 I renamed the Field2 textbox to txt_Field2 and now it works if I make a new textbox called TextBox3 with the formula below:=[txt_Field2] Obviously this works with the textbox [txt_Field2] on the report, however if I remove the textbox txt_Field2 from the...

This is really simple, but I can't figure it out. I am trying to concatenate to fields in an Access 2007 report. Both are text fields (size 255) This is what I have entered: =[Field1] & " " & [Field2] Every time I go to Print Preview it shows #Error Update: I can put [Field1] in an empty...

I would make a subreport with the detailed information (Students & classes) and place it in your main report which lists the classes.