Search results

This is the error message when you attemt to submit the form: Now, domain\facilitydoej is accurate, but there is also a domain\facilitydoej2 and a domain\facilitydoej3. But domain\facilitydoej IS the one I want to send to. This is VERY irritating.

I am attempting to send an email via Outlook from an InfoPath 2010 form. It is working successfully except when there is more than one similar AccountID (generated by the Person Picker), such as "FacilityDoeJ". In the backgound, it will pull "FacilityDoeJ", "FacilityDoeJ1", and "FacilityDoeJ2"...

Thanks for your reply! Actually, I AM calculating the qualifying visits each time I need that information. I'm sorry I was not clear. I am merely writing a query to pull data out of the data base. The query uses a series of temporary tables to arrive at a final temp table I can paste into...

I am trying to mark the "qualifying visits" in a list of patient visits by putting "Yes" in a particular field. The qualifying visits are the 1st 10 visits during the time frame. BUT, only up to 5 of the 1st 10 visits can have a particular CreditDSSID (179). So visits 11 and 12 could count...

I have a lengthy report I must import into Excel from a legacy Dos-based program. I can import it just fine using column width, but many of the rows have trash in them I do not want. I want to remove rows with headers, page numbers, groups of "------------", etc. I have written this to delete...

I *FINALLY* got back around to this. I tried your banana trick. The word BANANA did not show up ANYWHERE in the printed report. Any other suggestions would be greatly appreciated. Thanks!!! BTW...the report WILL let you hit cancel...cancel...cancel to skip the LastName field when you run...

I have a report in Access 2007 that is based on a query that has: ...in a Date field. The report has several subreports that are based on crosstab queries based on the original query. We used to tweak the date field of the primary query manually, but today I changed it to a the text above...

Got it! Thanks so much!!! drop table #ESI go select prname,pcpteam,hfactname,count(distinct ptien)Uniq, case when len(cast(datepart(mm,EDdate) as varchar(2))) =1 then '0' + cast(datepart(mm,EDdate) as varchar(2)) + cast(datepart(yyyy,EDdate) as varchar(4)) else cast(datepart(mm,EDdate) as...

Year 1st gave me this... 200810 20094 200810 200812 20092 20096

Thank you!!! Got that to work this way... drop table #ESI go select prname,pcpteam,hfactname,count(distinct ptien)Uniq, convert(varchar(2),datepart(mm,visitdate)) + convert(varchar(4),datepart(yyyy,visitdate))as EDdate into #ESI from #fh group by hfactname,pcpteam,prname,visitdate go select *...

I'm getting these... 2018 2013 2018 2020 2011 2015 2019 2017 2018 2020 2010

Thank you. This is close, but it is adding them instead of putting them into a date. drop table #ESI go select prname,pcpteam,hfactname,count(distinct ptien)Uniq, datepart(mm,visitdate) + (datepart(yyyy,visitdate)) as EDdate into #ESI from #fh group by hfactname,pcpteam,prname,visitdate go...

I have an Transact SQL query that returns a field with a date in it within a temp table. How can I get it to convert this date (in the temp table only, of course) to display ONLY month & year, no day... mmyyyy or yyyymm or some variation thereof. The resulting data generated by the query...

Guaranteed. They always select the spokesperson who can scare the public most toward their views. Right now the American Public is getting scaremongers on ALL sides. Some are praising the British & Canadian Systems, and some are blasting them. I would say more are blasting them, probably b/c...

Here is a question for those of you "Across the Pond" from the Yankee side. The question is for Canada too, for that matter. You may be aware that here in the US there is a VERY big deal in the news now about whether the Federal Government should nationalize health care. Currently, most...

Will do. Thanks! I'll report what I find. Here is the sample table again. Maybe it will like periods better than spaces. Treating Specialty.....CountOfTreating Specialty....Yes....No Med........................25....................................23.....2...

I will have to look at the columns for those with NO date. It is time to go so I will look into it tomorrow. Thanks!!!

That was it. I had lined it up with spaces, but they were removed when I posted. 5 rows, 4 columns.

Interestingly, I just tried to print the thing. It went through the errors AGAIN, and then, it said it could not open any more tables, and THEN, it gave error messages that the Recordsource for six of the crosstab queries did not exist. THEN it gave the original error messages a few more...

Thanks for your reply. I'm confused. Why is it an issue? None of the crosstabs utilize the PatientLastName field, only the counts that are in the other fields that have nothing to do with the patient's names (they are all based on ward or clinic name data). Even if I totally remove the...