Hey,
I'm trying to build a simple query to display some records based on their status.
The problem is, the record with the status field, the status references a table called STATUS.
My table as follows:
PROJECTS table
ID Project Name Status 1 Proj1 DRAFT 2 Proj2 DRAFT
STATUS table
ID Name Description 1 DRAFT The proj is still being drafted 2 SUBMITED the proj has been submitted.
My problem is, when I want to list the projects that have a status of DRAFT for example, I cannot reference the status field directly.
This is my current SQL select statement:
SELECT *
FROM PROJECTS
WHERE Status="DRAFT";
I'm new to Access 2010, is there special syntax that I need to use to access a field that references another table?
Any help would be greatly appreciated.
SRILes