Last post Apr 11, 2009 07:10 AM by ganaparthi
Apr 11, 2009 05:40 AM|ganaparthi|LINK
Hi this srinu,
iam working with MS ACCESS Database..
when iam trying to query with aggregate function i have found following error.
Query:SELECT max(StudentId) FROM Students WHERE Department='Computer Science'
Error : IErrorInfo.GetDescription failed with E_FAIL(0x80004005).
My StudentId Column data type is text,
Please Help Me.
Apr 11, 2009 06:57 AM|JohnAClee|LINK
Basically it is saying that you can't do aggregate functions (max, sum,...) on a text field. To do this your studentID field would need to be declared of number type. If it is an ID, you could set it to autonumber. This would automatically increment with
each new record, and also ensure that it is unique.
Hope that helps,
Apr 11, 2009 07:10 AM|ganaparthi|LINK
Hi Now its Suppoting with Text Field only,i have another Doubt ie
can we get the results From Table if i write Query like this
i have one table with replicationid equals to guid in sqlserver.
i wrote query like this select * from students where StudentId='357965A7-5878-4C26-A0F6-05403CBF426A'.(replication id).
in sqlserver its working but in msaccess its not working,
please help me