Search results for query: *

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.

I would like to display a watermark on a report (to grab the attention of the reader) if one box is checked. Note, I don't want the box to appear anywhere on the report, this is easy. But I want the image (preferably a watermark) to appear behind the text to catch the readers eye. It appears I...

I did not have the group header section set to keep together. I also set the Repeat Section property to Yes. Thanks a million

I am using Access 2007: I have a report that I have turned the "keep together" set to yes on the Group Header and on the Detail section. But my report still is randomly putting the detail onto the next page with most of the page with the Group Header being blank. Help!!

Doesn't this make the case for processing each code differently? If 4-313005 is the only one that there is a problem why can't I just leave it in its original format and only apply the formatting to the other messages that you provided a solution for?

Good point, I noticed that as I started separating that there were no consistent delimiters. I will check some other options out. Thank your for your help. I appreciate it