Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
multiple counts one record
im trying to get 2 counts onto one record in MS access I currently have 2 queries to generate the 2 counts and then join them but with to combine this all into one. The first query gets a count like this: SELECT Count(sttdstud.student_id) AS [Actual Attendances], Mid$([SchoolDept],1,1) AS... -
Can this be run faster (NOT EXISTS)
I have a table Full Register List containing about 8000 registers along with each of the weeks they are run in the fields are register_id, register_group, WeekNo which are combined to make the primary key. So for each register_id and register_group there is usually a record for each week the... -
get a week range to record for each week?
Im trying to find unmarked registers from two existing tables. Registers contains register_id, start_week, end_week so start_week could be 7 and end_week 36 this is all registers setup with unique register_id. Then marked which conatins register_id, week signifying the register has been... -
concatenate strings from different records
Hi im wondering if there is a way to concatenate a set of strings when field1 is the same hopefully with a comma seperating each part. E.G Field1 Field2 abc 122qq def 456ww abc 789rt ghi 999zt def 873gh EQUALS Field1 Field2 abc 122qq, 789rt def... -
Get other rows from DISTINCT satement
I am trying to display a set of records based on a SELECT DISTINCT Field1 statement, however I would like to display other fields in the record without it being assessed if they are distinct from another record or not. (i.e NOT DISTINCT Field1, Field2). I should note it doesn't matter at all... -
Compare a field with itself on same database
Hi i know the basics of sql but have struck a problem. I am trying to write a query to display records from a database where the field1 is the same as another records field1 in the same file but field2 is different any help would be great. ps. These are text fields so I am using the like...
