[MS_AccessPros] help with my query

 

I have the following query:

UPDATE DISTINCTROW crwksuma INNER JOIN MLTC ON crwksuma.[patient id] = MLTC.patientid SET crwksuma.insrcd = "   ", crwksuma.[billing type] = "M"

WHERE [mltc].[enrollmentdate]>[Forms]![zformcrwk]![pid to];

The query works, but '[mltc].[enrollmentdate]' can have multiple entries and I only want to use the lowest one. If I use the MIN() function, I get error 'cannot have aggregate function in WHERE clause.'.

Is there any way to do this in the above query or do I need to do it differently.

Thanks for your help.

Sarah

__._,_.___

---

Posted by: sarahk@schemesoftware.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (18)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___