Search results

I am importing a spreadsheet with the following code: Sub ImportExcel() Dim strXls As String strXls = "UNC Address Removed For Post" DoCmd.TransferSpreadsheet acImport, , "tblStockImport", _ strXls, True, "Delivery Volumes!" End Sub This works fine, however, the issue is that my...

Hi all, I am having a small issue with an update query - hopefully you will be able to help. I am trying to update a table that has column headings as follows: Gas Day|Gas Hour|Sitename|Avaliability The raw data is received in such a form, so for each day I will have 24 rows of data...

Hi all, I was just wondering if it was possible to create a cross tab query that has sub column headings. For example, I would like a parent column, with a site name, and under that, have other options i.e _________________________________________________________________________________...

Hi all. I will try and set the scene to help you understand what I am trying to acheive. I currently have an access database that has data for a variety of gas storage sites. Ultimately I output a table to excel, with the following headers | SiteName |...

Hi all, I have a form that filters a query. From that form there are multipe listboxes. At the moment, in my query, I filter the results using the following in the query criterea i.e. [forms]![search]![cboarea] etc. etc. However, I would now like to add amultiple selection list box...