Prev: Spammer Top 25 Web Design Tips How to desing Simple Web site
Next: Changing font size in html view (FP 2000)
From: 116 on 9 Dec 2009 08:51 I am looking for a count of items meeting certain criteria. I am using this < Between DLookUp("[Date]","t_Heat_Treat_Oven_Log","[PC]='THERM'") And Date() > to retrieve the data, but have been unable to get a count. I had to put the above in a sub query, and create one just for the count. Is there a way to do this in one query? Thanks David
From: Tom Willett on 9 Dec 2009 09:53 If this is an Excel question, you need to post in an Excel newsgroup, not Frontpage. -- Tom [Pepper] Willett Microsoft MVP - FrontPage Since 1997 --------------------------- "116" <116(a)discussions.microsoft.com> wrote in message news:332F3668-0E94-4543-A380-8C15EA0584A7(a)microsoft.com... :I am looking for a count of items meeting certain criteria. I am using this : < Between DLookUp("[Date]","t_Heat_Treat_Oven_Log","[PC]='THERM'") And Date() : > to retrieve the data, but have been unable to get a count. I had to put : the above in a sub query, and create one just for the count. Is there a way : to do this in one query? : : Thanks : David
From: 116 on 9 Dec 2009 15:53
Sorry all. I posted to the wrong group. David "116" wrote: > I am looking for a count of items meeting certain criteria. I am using this > < Between DLookUp("[Date]","t_Heat_Treat_Oven_Log","[PC]='THERM'") And Date() > > to retrieve the data, but have been unable to get a count. I had to put > the above in a sub query, and create one just for the count. Is there a way > to do this in one query? > > Thanks > David |