Search results

Hello, the code below basically runs some Access Queries, then copies them in to a NEW excel workbook in .XLS. What I want to do instead is open an existing .XLSM wokrbook delete or update the 7 sheets it creates and replace them with the new query results from access. I love this code below...

Hello, I need to do figure out a couple options: This query returns a running asset balance for 60 months. Each month is 1 column. 1) I need to create a query based on those results that can cycle through each column and determine if it is NEGATIVE. Then if it is negative, I need to...

I'm not even sure how to search the forums or google for an existing solution. What I'm trying to do is create columns based on subgrouping. See attached example in excel. It's almost like transposing but not it. The names of the columns don't really matter. It's to be used in a dynamic...

May be VBA is a better solution for this: Say for Material A: I need Access to see that the 1st date is 05/01/2013 and say 365 days out or 12 months (05/01/2013-04/01/2014) the average is 158.6 then 06/2013-05/2014 the average is 146.667 and so on. Every month is not going to be listed in the...

Help! I swear I figured this out earlier today and I was like "that's easy enough to remember" then I couldn't do it again :( Here is what I need help with: Say for Material A: I need Access to see that the 1st date is 05/01/2013 and say 365 days out or 12 months (05/01/2013-04/01/2014) the...

Hello, My hair is literally turning white trying to figure this out. I'm not sure what is the best way to do this so I hope you experts can help me. I'm not at work so I don't have the examples with me. It's not that complicated. Basically I have a table called "EDW" which is an SAP...

Hello, I've tried googling for the past few hours and I can't figure out what I'm doing wrong. I'm trying to get this to work: Public Function SMC(Dmd As Long) As String If Dmd > 50 Then SMC = "A1" End If End Function Then I want to go to Query builder and say "SMC: SMC([Dmd...

Hello, In access I have a query (made from 2 queries) then compared against another double query. When I open excel and try to import it (so they sync/refresh data). It just imports nothing but the headers, no data. Just 2 blank rows. Anyone know why? My other imports to excel work just fine.

Hello, I tired to search for help on this topic but I can't find anything specific to what I'm looking for. I have a table that has a long list of order numbers, the 1st 5 mean location like: THOQR1234WERAJS12 ASKLFJ1432WEJKLAKS THOQR1234WKLAJS17 THOQR1234WKIAJS13 GASDKAL123ASF0800...