SQL to DCount

[DS]

I have this SQL statement that I need to convert to a DCount...
This is what I have So Far...

Me.TxtMenuCount = DCount("MenuID","MenuDetails",....?)

My SQL statement...

SELECT MenuDetails.MenuID, Menus.MenuName, MenuDetails.StartDay,
MenuDetails.StartTime, MenuDetails.EndDay, MenuDetails.EndTime,
Hour([StartTime]) AS Start,
IIf([EndDay]>[StartDay],Hour([EndTime])+12,Hour([EndTime])) AS [End]
FROM MenuDetails INNER JOIN Menus ON MenuDetails.MenuID = Menus.MenuID
WHERE (((MenuDetails.StartDay)=Weekday(Now())) AND
((Hour([StartTime]))<=Hour(Time())));

Any help apprecited,
Thanks
DS

 

[Ken Snell \(MVP\)]

No can do what you want. DCount works with either a single table or a single
query. In your case, the query that you want to "convert" to DCount uses
multiple tables, so you cannot convert directly. You'd need to store a query
that gives the results of your posted query, and then use DCount on that
query.

 

[DS]

No can do what you want. DCount works with either a single table or a single
query. In your case, the query that you want to "convert" to DCount uses
multiple tables, so you cannot convert directly. You'd need to store a query
that gives the results of your posted query, and then use DCount on that
query.

Thanks Ken, Is there any chance of using that SQL code with maybe a
Count(*) line added it to pass the count to a textbox?
Thanks
DS

 

[Duane Hookom]

The generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane will take
almost any SQL statement and return a value.

 

[DS]

The generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane will take
almost any SQL statement and return a value.

Thanks I'll give it a try!
DS