I recently converted from using MS Access to MS SQL Server 7. One of my queries groups by a T/F field (now a bit field in SQL Server). Access allowed this, but Server doesn&#039t seem to. I get the error:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)<BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot group by a bit column.<BR><BR>Any workarounds? besides converting it to a char(1) field and using T or F, which I may end up doing anyway.<BR><BR>TIA,<BR>Matt