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?

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

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

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

    DLookup?

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

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

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