SQL Problem, HELP!

[gbrian]

Access 2000- this query isn't working... any ideas??

SELECT DISTINCTROW LAWSON_DW_PSTRANS_V.ACCT_UNIT,
LAWSON_DW_PSTRANS_V.ACCOUNT, LAWSON_DW_PSTRANS_V.SUMMARY_TYPE,
Left([SUMMARY_TYPE],5) AS Expr1, LAWSON_DW_PSTRANS_V.AMOUNT_UNITS,
LAWSON_DW_PSTRANS_V.DESCRIPTION, LAWSON_DW_PSTRANS_V.POSTING_DATE,
LAWSON_DW_PSTRANS_V.SOURCE_CODE, LAWSON_DW_PSTRANS_V.REFERENCE,
LAWSON_DW_PSTRANS_V.COST_CATEGORY INTO tbl_ProjectActivityDetail
FROM LAWSON_DW_PSTRANS_V
WHERE (((LAWSON_DW_PSTRANS_V.SUMMARY_TYPE)=[Enter 5 Digit Project:])
AND ((LAWSON_DW_PSTRANS_V.POSTING_DATE) Between [Enter Period
Beginning Date:] And [Enter Period End Date:]) AND
((LAWSON_DW_PSTRANS_V.AMT_UNIT_TYPE)="A"))
ORDER BY LAWSON_DW_PSTRANS_V.ACCT_UNIT, LAWSON_DW_PSTRANS_V.ACCOUNT,
LAWSON_DW_PSTRANS_V.SUMMARY_TYPE;

 

[PHV]

this query isn't working
Sorry, cristal bowl in vacation today ...
Any error message ? Unexpected result ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[gbrian]

Sorry in a hurry.

It says Unexpected call to function.

 

[gbrian]

Undefined function 'Left' in expression.

That is the exact error message- it works fine in the Access 97 database it was built in, this error comes up in Access 2000 after converting the database.

I recreated the tables/fields from this query and ran it on a new database and it ran- I do not see any syntax errors or a problem with the Left function.

What could be causing this?

 

[buddafish]

i also have encountered some issues with intrinsic function calls after converting to 2k. i can't remember what i did to fix them at this moment, but will post a reply when my brain kicks in.

scottie

 

[gbrian]

Buddafish: UTILITY.MDA ring a bell? I found a post where someone had a similar problem and referenced this file.

I am going to have the user try this

 

[PHV]

Check the references:
While in VBE (Alt+F11), menu Tools -> References ...
Compile the project too (menu Debug).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[GingerR]

faq181-936