M
Mark
Anyone have an idea why the following is not working for me? I have an open form, which launches a process that runs queries. In one of the queries, I want to populate a field with the value from a text box on the form. (I have an end date field on form that user selects, want to list that same selected date in an 'as of date' column in query.) The query allows the syntax I'm using, but always returns an empty value. (And yes, the form is still open when query runs.
Open form and field on it: [Forms]![iFrmRptSel]![txtEnd
SQL of query: "SELECT "dB" AS Source, [Forms]![iFrmRptSel]![txtEnd] AS [As of], tblName.QUANTITY_ORDERED*tblName.LIST_PRICE_PER_UNIT*1.12 AS [Total Amount
FROM tblName;
Why does this not return the date value that is present in the form's field? Just returns empty cells, for the 'As of' column
Open form and field on it: [Forms]![iFrmRptSel]![txtEnd
SQL of query: "SELECT "dB" AS Source, [Forms]![iFrmRptSel]![txtEnd] AS [As of], tblName.QUANTITY_ORDERED*tblName.LIST_PRICE_PER_UNIT*1.12 AS [Total Amount
FROM tblName;
Why does this not return the date value that is present in the form's field? Just returns empty cells, for the 'As of' column