I have a main form with 3 subforms. On the main form is an employee. In (Coder Reviews subform2) the Reviewer would pick a record. When picked another subform (tblReviews subform1) shows a list ...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23172744.html
SELECT
DISTINCTROW Person.Name,
ActionDesc.ActionName,
Action.Time
FROM Person INNER JOIN ([Action] INNER JOIN ActionDesc ON Action.ActionID = ActionDesc.[Action#]) ON Person.WindowsID = ...
http://www.experts-exchange.com/Microsoft/Applications/Q_23229519.html
i have a set of data (below)
Name TASK QTY Month_Year
X LETTERS 21 Jan-08
Y LETTERS 42 Jan-08
X LETTERS 71 Jan-08
Z LETTERS 41 Jan-08
X LETTERS 43 Jan-08
Z LETTERS 12 Jan-08
X LETTERS 53 ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_232...
Is there a single step process to query Access when my database stores information as different units of measure?
That is to say, I have a Customer table with two records as follows:
Customer...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23669078.html
I am sending a series of reports by e-mail, with an Excel attachment. So I am looping through my code using DoCmd.SendObject followed by an update query that tracks and records when the report has ...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23670930.html
I am running a select query in Access and I need to calculate the sum of a value but show a different format depending on the Unit of Measure.
For example, If the sum of the numerical value in t...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23673041.html
Hi,*!!!
SELECT
CCZ_CCZ450_INVOICE.INVOICE_ID,
CCZ_CCZ450_INVOICE.INVOICE_NO,
Max(CCZ_CCZ050_STATUS_HIST.STATUS_DT) AS STATUS_DT, CCZ_CCZ050_STATUS_HIST.STATUS_CD_ID
FROM
CCZ_CCZ050_STATUS...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23236247.html
