Search results for query: *

If anybody can help then I should probably mention that I'm also trying to add the columns: Top1, Top2, Top3, Top4 etc. each of which will show the 1st, 2nd, 3rd etc. largest 'Broker Group' totals. It will look something like: Exchange Name Total sum.... Top1 Top 2 Exchange X...

I would now like to add another field that shows the 'Broker Group' name that has the largest 'Total Fee 2010 (excl RBS)' total? I've looked through lots of threads and can achieve this with a simple query on it's own but not nesting into the sql string below? Any ideas? Below is the current...

Apologies, getting lazy! Had a play around and have resolved it. Thanks.

Is there a way to now group by the 'Exchange: exch' field? Tried to query this query from another query using totals but getting an 'overflow' error?

To try and gain more understanding I've rebuilt the query without the variables and I've done the left joins from the 3 ccy fields all to the one CCY field in the FX table. I now have different results? Again, just for my understanding, why is this? Here is the code if it helps: SELECT...

I need to validate but that seems perfect! I tried using left joins (honest) but couldn't use more than one of them? Is it your variables that has allowed this to work or did I just miss something big time? Would be good to know so that I can, hopefully, understand where I went wrong so as to...

I'm only getting two records? The inner joins work when I have just one value to calculate but they seem to filter out more and more records? I've added your condition with the previous code and it seems to be more like what I'd expect? Thank you very much for your help! SELECT...

Ah, that was the next step.... I've taken it out and the adjusted code (1st set) below works again. However, the second set of code is what I'm trying to do; add another criteria but this returns ambiguos outer joins. Which is why I was reversing my steps to try and get it to work. So, in...

I just want to display them via the calculated expressions in the select query, I don't need to update any values in a table.

As you can see, if it was just one field conversion I could make an inner join and be done but because there are 3 fields that all have to be converted I have the below. It was working, albeit, taking forever to run, but now it's not even doing that... You'll also see that I have an expression...

Hi, Apologies, it's been a while since I've done anything in Access and my brain has turned to mush! I'm sure this is very simple.... I have a table with some amounts with differing local currencies. I have another table with the currencies and the GBP equivalents. I need to run a query to...

PHV, Sorry, it's early and I'm not with it yet! I forgot to change the =Null to is null! I've now changed that too and it is working perfectly! I can't believe I missed that but sometimes you can't see the wood for the trees! Many thanks for your help!

PHV, Many thanks, I really appreciate your help. However, although the SQL has been tidied up and now looks like: SELECT * FROM tblConfirmsHistory WHERE [Next Approver]='Adrian Zanelli' AND [AckSent] = Null; ...the query is still not returning any results? If I go into the query grid and...

I have the below code which used to work perfectly well in Access 97 some years ago but now doesn't, either in Access 97 or 2003. The problem is, once the query is created it just doesn't retrieve the recordset? If I go into the query after it has been created and retype one of the values then...

Thanks kjv. Sounds a little complex but I'll have a go and let you know how I get on....

Access 2000. I have a report, based on a query, based on a simple table, that shows a list of individuals, a number field, and a date field. I want to show the historical trend (in a chart which I've done) whereby the x axis is date, y axis is number, for each individual. Now, and here is the...

Could still use some help with this.

Ph, I have added the parameter to the SQL but I am still 'Unable to obtain data' when I edit the pivot table and try to refresh? Any ideas? Thanks, Adrian

PHV, Many thanks but could you expand a little please? Both queries??? Thanks, Adrian

Using Access 2000: I have created a pivot table based on a pretty basic select query. However, I need to filter the query by certain dates. Now, if I hardcode the dates into the query, for example, 'Between 01/01/2004 and 01/01/2005' then the pivot will run fine. However, if, as I would like, I...