Search results

Excellent. That works really well. Also you saying that running sums were easy to do on the report level, not the query level allowed me to find this on the internet: http://office.microsoft.com/en-us/access-help/calculate-a-running-sum-cumulative-total-HP005187388.aspx I didnt even...

No the report and sub report are not directly related. This is probably something I should have explained before. I have attached an example report for December as an image. Basically the main report (the top bit) runs between two set months and by market sector (in this case...

Ok I have Imported Market sector to the main report (not a sub report). I have added a group for MktSector. How do I then calculate running totals on the report. Presumably a formula is required. Thanks again for the help

Thanks for the reply. The SQL will ultimately be placed in a sub report shown on a main 'Orders Report'. It should show a summary of running totals of Order Value over the year. I usually make my SQL in QBE and then paste it into a report when it's working. Is there an easier way to do it...

Access Running Totals Query needs additional criteria Hi, I have included a screenshot of the query for reference. I am trying to create a running totals query in access. I have successfully managed this following guidelines on Technet (I forget the reference) and have come up with this...

Thanks for the explanation. I figured there must be a time and place for both but its just a case of learning when! Thanks again for the assist

Thanks a lot for that. It does work the same in my environment Thanks again for the assistance! :)

vbaInet Thanks for the reply. Ive attached a much slimmed down version of the database. It most likely explains an awful lot better than I ever could. I simply couldnt think of a way it could be done in just one query. However, I am open to improvements or suggestions if you fancy taking a...

No problems! Its good to have input anyway. Glad we both learned something from this :)

Hi, Thanks for the fast response. I'll certainly take a look at the link posted. I think the difference with mine is that it involves two nested queries. I am also unsure how to setup a relationship between the nested queries and the main query (which currently I have setup in the QBE). I...

Hi, First off I stress I have this working perfectly using 3 visual queries. I would really like to further understand SQL nested queries though and combine the three visual queries into one SQL query. (Hope that makes sense!) Basically I can insert the sub-query into the query as an...

Hi, Is this what you want. I found it on an EE article here: http://www.google.co.uk/#hl=en&biw=1916&bih=905&q=send+object+cmd+%3A+multiple%2C+send%2C+reports&aq=f&aqi=&aql=&oq=&gs_rfai=&fp=81aa0f6582b4550 (2nd result down) Function sndrpt() Rem <!-- Make sure the Microsoft Object xx.0...

Thanks for that I noticed when i first ran the code and checked for typos I still hang my head that I didnt notice the post sooner though :) Thanks anyway

Epic Fail! I clearly suck at searching! After googling a little more I finally found this: http://www.access-programmers.co.uk/forums/showthread.php?t=58212 Exactly what I wanted ...grrrr :) Hopefully this may point someone else on the right track!

On further searching it appears that I may be able to achieve this using the Docmd.sendobject method but loop though the recipients creating a comma separated string which is then put into the BCC field. I am slightly stuffed as to how though! Hopefully someone can help me out Thanks Dave

Hi, Hope you guys can help here. I have learnt a lot from this forum in the past. I would class myself as a VBA beginner. I am starting to learn the basics but most of my code is harvested from souces on the internet and then modified if necessary! I have a database that holds customer...

Haha Thanks a million. I couldnt get it to work at first, then tried it with a text box (which worked) and realised what I was doing wrong I had to change the relevent lines of code above to: Me!CboFilterFinancialPeriod.SetFocus Me!LstSearch.RowSource = "SELECT * FROM...

Haha! I was using something similar but with simgle quotes. Its good to know how to specify dates now so thanks.Unfortunately, when trying your method I realise that the reason it is not finding exact matches is that it by default is searching mm-dd-yyyy. All my dates are in format dd-mm-yyyy...

Hi, I have a combobox (CboFilterFinancialPeriod) containing a selection of dates in format dd-mm-yyyy. I have a listbox (lstsearch) on the same form (frmTenderEnquiryIndexFind) as the combobox that is based on a query (qrytenderenquiryindexfind). The idea is that when a user selects a date...

Elegantly simple! Thank you very much for this :-) Dave