Search results

Thanks, but I figured it out. The REPORT_CLIENT is attached to an Oracle table of the same name and I am now using a PL/SQL UPDATE statement to write results to the Oracle table and simply open the Access table. Thanks for your response.

No, REPORT_CLIENT, HIST_MIS_CDS, HIST_CODE_TRANSLATION, etc. are simply tables in Access (attached to Oracle tables of the same name).

The Form's RecordSource property was pointing to a table (REPORT_CLIENT) that did not have all the fields I need to display. So I put this query in the RecordSource property of the Form: "SELECT * FROM (REPORT_CLIENT INNER JOIN HIST_MIS_CDS ON REPORT_CLIENT.ID = HIST_MIS_CDS.ID) INNER JOIN...

The Form's RecordSource property was pointing to a table (REPORT_CLIENT) that does not have all the fields I need to display. So I put this query in the RecordSource property of the Form: "SELECT * FROM (REPORT_CLIENT INNER JOIN HIST_MIS_CDS ON REPORT_CLIENT.ID = HIST_MIS_CDS.ID) INNER JOIN...

There is no space when I have it in Expression Builder. Somehow, when I paste it here, a space appears. I think the problem might be that the fields I am referencing ar not contained in the Record Source property of the Form.

I did, but got the same error.

No I don't have a space in the actual query. Somehow when I paste it here a space appears. Yes, I have tried it with square brackets as well. In fact, whenever I use any field in Expression Builder (eg., [tablename]![fieldname]), I get an error. If I have a query without a fieldname (=Trim$()...

I am getting the same error in the following query in the Expression Builder: =IIf(HIST_MIS_CDS!TYPGESS="","",IIf(HIST_MIS_CDS!TYPGESS<>HIST_CODE_TRANSLATION!SRC_CODE_DESC,"X","")) The queries don't have a space in Expression Builder. Somehow, when I paste it here, a space seems to appear. I...

No, there is no space in the actual query: =IIf(HIST_MIS_CDS!TYPGESS="","",IIf(HIST_MIS_CDS!TYPGESS<>HIST_CODE_TRANSLATION!SRC_CODE_DESC,"X",""))

I need to implement the following logic in a report column: IF hist_mis_cds!typgess = "", then calculated field= "" ELSE IF hist_mis_cds!typgess <> hist_code_translation! src_code_desc then calculated field= "X" ELSE calculated field= "" I have implemented the following query in Expression...

I need to implement the following logic in a report column: IF hist_mis_cds!typgess = "", then calculated field= "" ELSE IF hist_mis_cds!typgess <> hist_code_translation! src_code_desc then calculated field= "X" ELSE calculated field= "" I have implemented the following query in Expression...