Search results

vbaINet Thanks for your input. I am going to need a little more help. see the code below and see how I will be able to accomplish this strQuery = "SELECT [Detail].[Menu Item] AS ItemSold, Sum([Detail].[Quantity]) AS TotalQty, Sum([Detail].[Item Price]) AS TotalSale, " strQuery = strQuery &...

Hello again all. First see this website /forums/showthread.php?t=218472 thread for the beginning of my trouble. I managed to find out the above problem was the data in my array was causing problems with the code. In the array was a series of ==== signs. When I changed the data to all 'a'...

Ok I seem to have figured out why I was having problems with the above code. I had a series of ====== in the data array varResults. When I replaced the ====== the code worked perfectly. So my next question is How do I keep the '=====' in the data array and not have the formulaArray throw an...

I saw that but I'm not sure how the formula is being parsed into the objExcel.Transpose(). Can you help me find out where in debug|local window it is and I can count the characters for the different date sets that I may be using with the example data? Thanks again for all your assistance.

I've seen some restrictions on Application.transpose. I don't know how they would impact my formula. This is definitely a problem with Array and the transposition. Anybody help ? The example database will give example data.

*Attached is an access datase in zip format. Hold down shift when running as there is a form that runs on startup.* I have a database that I use to generate excel spreadsheets from sql statements based on date. For some reason It woks with some data but not other data. Here is the scenario...