Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
MS-Access Count distinct not workin
Name: anil.channegowda Date: March 20, 2008 at 12:53:42 Pacific OS: XP CPU/Ram: 1GB
Comment:
Hi,
I'm trying to run a query similar to the following: Select category, count(distinct names) from tableA AA inner join tableB as BB on AA.ctr#=bb.ctr# where aa.datecol > 1/1/2008 and bb.type='yes'
But, MS-Access is not allowing me to do a Count(distinct ).
Summary: I have created an MS Access db, 2 of the fields relate to time...StartTime & EndTime. From this I have created a query to display the attendance time ([EndTime]-[StartTime])*24 which gives me the dif...
Summary: I have read a few of the responses here, and am impressed with the replies. In that regard I'd like to ask this question. I am attempting to implement an MS Access 2003 solution involving Treeview MS...
Summary: I have an old DOS program that saves data to a .dbf database file. I would now like to add data to the .dbf file through MS Access. I have successfully created a link to the table in Access and have...
