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...

...monthly average rate],1),0)+Nz(A.tradingfee/Nz(Ft.[gbp monthly average rate],1),0)) AS [Total Fee 2010 (excl BBS)], Sum(a.bgnqty*a.bgnprice*a.confact) AS [Notional(qtyxpricexcf)] FROM ((((((tblBrokerageFeeDataAll AS A LEFT JOIN FX AS FC ON A.[Commission Currency] = FC.CCY) LEFT JOIN FX AS FB...

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?

...tblBrokerageFeeDataAll.prodtype AS [Product Type], Mid(["Site],2,1) AS Site, tblBrokerageFeeDataAll.exch, [tblBrokerageFeeDataAll].[commission]*Nz([Fx].[gbp monthly average rate],1) AS [Commission GBP], [tblBrokerageFeeDataAll].[brokeragefee]*Nz([Fx].[gbp monthly average rate],1) AS...

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...

...AS [Product Type], Mid(["Site],2,1) AS Site, tblBrokerageFeeDataAll.cptyname, tblBrokerageFeeDataAll.exch, [tblbrokeragefeedataall].[commission]*[fx].[gbp monthly average rate] AS [Commission GBP], [tblbrokeragefeedataall].[brokeragefee]*[fx].[gbp monthly average rate] AS [BrokerageFee GBP]...

...tblBrokerageFeeDataAll.prodtype AS [Product Type], Mid(["Site],2,1) AS Site, tblBrokerageFeeDataAll.exch, [tblbrokeragefeedataall].[commission]*[fx].[gbp monthly average rate] AS [Commission GBP], [tblbrokeragefeedataall].[brokeragefee]*[fx].[gbp monthly average rate] AS [BrokerageFee GBP]...

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.

...tblBrokerageFeeDataAll.prodtype AS [Product Type], Mid(["Site],2,1) AS Site, tblBrokerageFeeDataAll.exch, [tblbrokeragefeedataall].[commission]*[fx].[gbp monthly average rate] AS [Commission GBP], [tblbrokeragefeedataall].[brokeragefee]*[fx].[gbp monthly average rate] AS [BrokerageFee GBP]...

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...

...'Select Records Set MyQdf = MyDb.CreateQueryDef("qryACK_QDF_Confirms", _ "Select * From [tblConfirmsHistory]" & ("WHERE " + Mid(Where, 6) & ";")) The SQL looks like this once the query has been created: SELECT * FROM tblConfirmsHistory WHERE...

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...