I need to have a query return all the fields only in the case where the Date is the last/maximum.
In simple words, consider the following query where I need the latest record to be represented, but am receiving the error of
"Cannot have aggregate function in WHERE clause"
Harassment is any behavior intended to disturb or upset a person or group of people. Threats include any threat of suicide, violence, or harm to another.
Any content of an adult theme or inappropriate to a community web site.
Any image, link, or discussion of nudity.
Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect.
Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software.
Unsolicited bulk mail or bulk advertising.
Any link to or advocacy of virus, spyware, malware, or phishing sites.
Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct.
Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation.
Hi everyone!
I need to have a query return all the fields only in the case where the Date is the last/maximum.
In simple words, consider the following query where I need the latest record to be represented, but am receiving the error of
"Cannot have aggregate function in WHERE clause"
SELECT * FROM [FINANCIAL SUMMARY]
WHERE eDate = (SELECT Max(eDate) FROM [FINANCIAL SUMMARY)
Dirk Goldgar, MS Access MVP 2001-2015
Access tips: www.datagnostics.com/tips.html
Harassment is any behavior intended to disturb or upset a person or group of people. Threats include any threat of suicide, violence, or harm to another.
Any content of an adult theme or inappropriate to a community web site.
Any image, link, or discussion of nudity.
Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect.
Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software.
Unsolicited bulk mail or bulk advertising.
Any link to or advocacy of virus, spyware, malware, or phishing sites.
Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct.
Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation.
SELECT [FINANCIAL SUMMARY].*
FROM [FINANCIAL SUMMARY]
WHERE [FINANCIAL SUMMARY].[eDate]=(SELECT Max([eDate]) FROM [FINANCIAL SUMMARY])
---
Kind regards, HansV
https://www.eileenslounge.com
Harassment is any behavior intended to disturb or upset a person or group of people. Threats include any threat of suicide, violence, or harm to another.
Any content of an adult theme or inappropriate to a community web site.
Any image, link, or discussion of nudity.
Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect.
Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software.
Unsolicited bulk mail or bulk advertising.
Any link to or advocacy of virus, spyware, malware, or phishing sites.
Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct.
Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation.
