Posted on 2004-09-29
I have a query that will append to a table. In the query I have some calculated fields that pull data from an unbound field on a form. For example I have a list of items to be ordered. Then I want the current customers ID to appear next to each item ordered and the date. But in the grid when I put...
PSDbID: [Forms]![Material Details]![cboname]
and the next column
DateOrdered: [Forms]![Material Details]![dateordered]
Here is the current SQL...
SELECT Materials.CategoryID, Materials.Title, Materials.Order, [Forms]![Material Details]![cboName] AS PSdbID, [Forms]![Material Details]![OrderDate] AS Orderdate
The problem is instead of getting the ID number that does exisit on the Material Details form I get a square. Then for the orderdate, I get nothing.
Can someone out there please tell me what I am missing? I hope this makes sense.