Search results

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

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

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

Hi, I am trying to acomplish the following using VB (rather unsuccessfully at present I might add!) I have a combobox on a form that fetches values from the 'SalesCode' field of a lookup table. This lookup table also contains a 'Description' field. What I am after is when I select a value...

Hi, I have been stuck messing with IIf expressions for the past week with no success. Wonder if anyone can help me out! I have been given the onerous task of converting many of the spreadsheets we hold here at work to a database format (Access 2007). Therein I have encountered a problem! I...