Recent content by NikToo73

No, it's just how the company is structured. It's a very large one, so the concerns of one lowly code-monkey isn't going to change their view... (as I'm the code-monkey...)

No, because I only want 2, 3, 4 and 5, and there's 1, 6, and 7 too... They do these things to complicate it... It's also querying on several different columns, so it will be [SalesTeamPosition1].[TeamCode], the next one [SalesTeamPosition2].[Team Code], hence why I can't do different tables.

My lovely and foresightful organisation has reorganised itself in a way which is most likely entirely aimed at screwing up as much my job as possible. Hence I need to adjust some queries in Access. We have three teams now where before there was one, all named ABC1, ABC2, etc., with sub-teams...

Solved it! Thanks again.

Thanks, that actually runs and makes the table. However... The second half of the ID (after the /) isn't pulled through and the ID field is blank for those. Almost there...

Still get "Data type mismatch in criteria expression".

The single quotes are from me, he didn't have any... Thanks, will try it.

One of my colleagues is having issues with the following bit of code. Not quite sure how he came up with is, but the problem is as follows: In a table, there's a column, "Siebel or Sales Ref". Some of these will have a long sales reference number or an ID from a Siebel sales system (pants), in...

Thanks CJ, that's fixed it. I'm doing it in Excel VBA so don't know if that makes a difference but I needed to keep the single quotes. And yes, it is just Top 5 I want to display, from a certain date. But that date format fixed it all wonderfully. Thank you very much. :)

Hello, new here but have used the forums many time for various issues. Finally come up against one I can't find a solution for. I have an Excel workbook which I use to extract data from an Access database using VBA. A requirement has popped up to show things from the last week. Unfortunately, I...