Some Explanation with Specific query

[firoz.raj]

can anybody tell me ?.Why this query is not is not working .Kindly let me know the idea.Any help would be highly appreciated.

SELECT AccessRole.emp_ID, AccessRole.FormID
FROM AccessRole
WHERE AccessRole.emp_ID='281' and AccessRole.Form_id='4';

 

[jdraw]

can anybody tell me ?.Why this query is not is not working .Kindly let me know the idea.Any help would be highly appreciated.

SELECT AccessRole.emp_ID, AccessRole.FormID
FROM AccessRole
WHERE AccessRole.emp_ID='281' and AccessRole.Form_id='4';

The first thing I notice is that fields have different spelling.
AccessRole.FormID vs AccessRole.Form_id

I doubt that both are in table AccessRole.

 

[vbaInet]

This thread appears three times Firoz.raj

Could you please delete the others and use just one.