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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Kobayashi

    DLookup?

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

    DLookup?

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

    DLookup?

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

    DLookup?

    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?
  5. Kobayashi

    DLookup?

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

    DLookup?

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

    DLookup?

    ...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]...
  8. Kobayashi

    DLookup?

    ...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]...
  9. Kobayashi

    DLookup?

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

    DLookup?

    ...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]...
  11. Kobayashi

    DLookup?

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

    Query not working anymore?

    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!
  13. Kobayashi

    Query not working anymore?

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

    Query not working anymore?

    ...'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...
  15. Kobayashi

    Reporting/Chart Help - Contains latest max(date)

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

    Reporting/Chart Help - Contains latest max(date)

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

    Pivot table - issue using query parameter?

    Could still use some help with this.
  18. Kobayashi

    Pivot table - issue using query parameter?

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

    Pivot table - issue using query parameter?

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

    Pivot table - issue using query parameter?

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

Part and Inventory Search

Back
Top