for while using the Dlookup function. I want to bring in a field from
another table that is not in my query.
Here's the SQL...can you see what I'm doing wrong?
SELECT [Current Mo Pace PO wPct 2-24-06].pctTotSales, IIf([pctTotSales]
<0.98,0,DLookUp("[PctPayout1]","matrixTotSales1","[PctSlsTarAchd1] =
[pctTotSales]")) AS value4
FROM [Current Mo Pace PO wPct 2-24-06]
GROUP BY [Current Mo Pace PO wPct 2-24-06].pctTotSales, IIf
([pctTotSales]<0.98,0,DLookUp
("[PctPayout1]","matrixTotSales1","[PctSlsTarAchd1] = [pctTotSales]"));
Thanks for your impending help!
Doreen
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
