A
Abbey Normal
Hi. I am trying to write a sub query for an Audit Log that shows only the
most current change for this sku. I have to pass the sku in, and it works
fine for getting all the records associated with this sku. I have looked at
the subquery examples, but can't figure out where to add it. Can anyone show
me how to add it? Thank you,
Here is the original query:
SELECT AuditLog.Reason, AuditLog.user, AuditLog.chgdate
FROM Glass INNER JOIN AuditLog ON Glass.SKU = AuditLog.Sku
WHERE (((AuditLog.Sku)=[Forms]![Glass]![sku]))
ORDER BY AuditLog.chgdate DESC;
most current change for this sku. I have to pass the sku in, and it works
fine for getting all the records associated with this sku. I have looked at
the subquery examples, but can't figure out where to add it. Can anyone show
me how to add it? Thank you,
Here is the original query:
SELECT AuditLog.Reason, AuditLog.user, AuditLog.chgdate
FROM Glass INNER JOIN AuditLog ON Glass.SKU = AuditLog.Sku
WHERE (((AuditLog.Sku)=[Forms]![Glass]![sku]))
ORDER BY AuditLog.chgdate DESC;