Recent content by Bopo

Hi Thanks for the help, sadly I've already tried the same thing, I always get the following error 'You tried to execute a query that does not include the following expression 'EmpNum' as part of an arrearage function.' Here's the query after applying the same from the DB above: SELECT...

Hey guys Well I've been playing with various queries for a while, basically I'd like a unique count of some records within a table, below is test data. EmpNum | FirstName 5 Bob 5 Bob 10 Harry 5 Bob 10 Harry 11...

Hey Guys I've tried to find an example of this, but sadly I haven't found one, therefore I'm questioning if it's actually possible. Is it possible to merge the following two queries using a union, if so syntax wise how would you write it? sqlQuery(0) = "UPDATE TblResource SET New = 'No'...

Hey Guys Well I'm really frustrated with this, despite having tried numerous different methods, I still can't simply add data to specific columns within my combo box. I'm looping through a recordset to do this, my code is awful, simply because I couldn't figure how to write those two queries as...

Thanks for the query, I've tried it and used trial and error, but sadly I still can't get this working. It doesn't return records with the description 'Laptop' which are not in TblRsrcEmp. I've been racking my brain, thinking of maybe creating a view and select records that != the Laptop ID and...

Hey guys Basically I have the following query, it's untested due to no data at the moment, but it looks fine IMO. Anyway my question is, would it be possible to return R.Description (TblResource.Description) where there isn't a inner join, e.g. where there is no corresponding value in the...