Recent content by pbuethe

It should have, but now I do not need it.

Once the ReviewDate in the source table was changed to a Date/Time data type, I was able to easily join on that field; I added Time fields to the query which were also changed from Text to Date/Time; I didn't have to go through contortions and the query worked perfectly as follows: INSERT INTO...

No, I am not completely sure the date is the issue, but I thought it was the most likely. The ReviewerID and CaseNbr look like numbers, but the data type is Text.

I discussed it with my supervisor and the creator of the source table. The result is that that person is going to make the date field into date/time type, which should help me a lot. We also discovered some other revisions that are needed, so it was very productive. I will keep you posted on...

Just a typo, there is nothing after the semicolon. Thanks.

Good suggestion, although your revision is not quite right . It should be: Iif([Admission] IN ("Reversed","RV"), "RV", Left([Admission],1) AS ADM I will revise the query accordingly, then continue working on the problem.

Right. So I am using CDate(). So why wouldn't this work? Or is something wrong with the criteria?

I am not joining a string field to a number field. I only mentioned the number field since I am using it in criteria. My query qrytbl011_Level1_8_CDate is to convert the ReviewDate in tbl011_Level1_8 (text) to RevDate (Date) so I can link it to ReviewDate (Date) in tblRevResults...

My source table is tbl011_Level1_8. CaseNbr, ReviewLevel, ReviewerID, ReviewDate are all of type Text. Column is type Number. There is no primary key. My destination table is tblRevResults. CaseNbr, ReviewLevel, and Reviewer are of type Text. ReviewDate is of type Date/Time. These four fields...

Well, when I tried it today, it worked the way I wanted it to, at least in terms of showing all the specialties. It doesn't seem to be showing the right number of cases. But I will work on that myself. Thanks anyway.

I have a report which was working fine with one grouping level, on the field Specialty, with CaseNbr listed in the detail. I am now trying to add another grouping level above this, on the field SampleNbr. The problem is that the report now shows only the specialty "Cardiology". How can I get...

That did the trick! I did not need dbOpenDynaset + dbSeeChanges. It is FAST!

OK, I have a pass-through query that works now, basically by following your first two steps! But it is working with a hard coded CaseNbr. How do I use it as a parameter in the pass-through query? How do I run the pass-through query in code?

Either way, it still says "Syntax error in JOIN operation" and does not say where the error is.

I believe I do not have SSMS, since I don't have rights to use SQL Server directly. I have only Access. Is there a way I can use my stored query in/as a pass through query?