Hi Experts,
In a nutshell, I'm doing running an SQL statement based on criteria chosen by users that will be put into the WHERE statement in the SQL statement. The SQL statement works great with...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_21853788.htm...
Zones:
ASPDate Answered: 05/17/2006 Grade: A Views: 0
hi . i have the following sql in my query
SELECT TbMain.CountryID, TbMain.StateID, TbMain.KindID
, Avg(IIf([TBMain.Time]=Forms!FSalesStock!ReportDateStart,Price/Area)) AS [M2 Start]
, Avg(IIf([T...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23391477.html
Zones:
MS AccessDate Answered: 05/10/2008 Grade: A Views: 23