var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Another query question
I am wanting to find the Project Name where the Job ID equals a known value and I want to assign the matching Project Name to a variable. Can anyone point me to an example?
dim MyProjectName as string
MyProjectName = SELECT * FROM Orders WHERE JobID=MyJobID;
Is this possible or will I have to open a recordset and find the first record that matches my criteria?
In the Orders table, the JobID field is unique, so the criteria should only match one record.
Try "SELECT * FROM Order WHERE(Jobid = " & "'" & MyJobID & "'" & ")"