SELECT * FROM AuctionName WHERE AuctionDate >= #CreateODBCDate(Now())# OR ToDate >= #CreateODBCDate(Now())# ORDER BY AuctionDate, ATime

#DateFormat('#AuctionDate#', 'dddd, mmmm d, yyyy')# - #ATime#

#CompanyName# #CompanyName#

#Location#
#StreetAddress#
#City#, #State#

Brief Auction Description:

#ShortItemList#

#DateFormat('#AuctionDate#', 'dddd, mmmm d, yyyy')# - #ATime#

#CompanyName# #CompanyName#

#Location#
#StreetAddress#
#City#, #State#

Brief Auction Description:

#ShortItemList#

#DateFormat('#AuctionDate#', 'dddd, mmmm d, yyyy')# - #DateFormat('#ToDate#', 'dddd, mmmm d, yyyy')# - #ATime#

#CompanyName# #CompanyName#

#Location#
#StreetAddress#
#City#, #State#

Brief Auction Description:
#ShortItemList#

#DateFormat('#AuctionDate#', 'dddd, mmmm d, yyyy')# - #DateFormat('#ToDate#', 'dddd, mmmm d, yyyy')# - #ATime#

#CompanyName# #CompanyName#

#Location#
#StreetAddress#
#City#, #State#

Brief Auction Description:
#ShortItemList#

#DateFormat('#AuctionDate#', 'dddd, mmmm d, yyyy')# - #DateFormat('#ToDate#', 'dddd, mmmm d, yyyy')# - #ATime#

#CompanyName# #CompanyName#

#Location#
#StreetAddress#
#City#, #State#

Brief Auction Description:
#ShortItemList#