Search results

I’m looking for a way that I can automate my dates. Instead of going in a couple of times a months going into my query and changing the dates to correct my query. My typically query outcomes are. Past 3 months starting at the end of the prior month and go back 3 months. Past 6 months...

I’d like to try and automate a import process. Below are the steps I currently use to get these excel spread sheets into my ms access database. Manual delete tables Table1, Table2, Table3, Table4. Open the macro to TransferSpreadsheet exel TableA Open the macro to TransferSpreadsheet exel...

Works great, thanks Bob

It opened just find at home, but for some reason it’s not work here at work

How do I do "single stepping through your code"?

I followed the steps and now when I try and run it, it just sits there for over 15 mins

I'm getting a Compile error: Can't find project of libray. and the "Dim objExcel As Excel.Application" is highlighted for a second the the: Public Function GetXLStDev(No1 As Double, No2 As Double, No3 As Double) As Double I tried this, and added it to a new Module, because the other one doesnt...

Would you recommend a sight?

Thanks vbaInet, But I still don’t know what I need to do to get Standard Deviation for my months that funded. When I try this Standard Deviations: (DStDev([Jan_Fund],[Feb_Fund],[Mar_Fund])) I'm getting a reading in the SD field that shows "#Error" So if I took all the months from Jan -...

How would I get I use a query to get the Standard Deviations? from what I read it should be something like this, but this one isnt working. Standard Deviations: Val(StDev...

That worked. Thanks again

I have a formula that should count all the 9’s and not 9’swithin a certain period Jan_Loan_Amoun: Sum(IIf([Expiration_date] Between #1/1/2010# And #1/31/2010# And ([OMNI_Status])='9',1,0)) Why cant I count the 9’s for the month of January? My data shows that I have 9’s I have also...

OMNI_Status is text, no lookup

Select Count([OMNI_Status]) As JanApps from Pull_Through_1 Where [OMNI_Status]= 9 And [Expiration_date] Between DateSerial(Year(Date()), 1, 1) And DateSerial(Year(Date()), 1, 31)

I’m getting a Data type mismatch in criteria expression I’m not sure what causes this type of error, could you please help me understand why I’m getting this error and what I need to do to fix it? Thank you again for your time and help SELECT Pull_Through_1.orig_code...

I’m working on a query that will count all the 9,8,7 that fall between the expiration date Count all the 9’s in field1 Count all the 8’s in field1 Count all the 7’s in field1 Count all the 6’s in field1 That fall between #01/01/10# and #01/31/10# “Jan” That fall between #02/01/10# and...

There are anywhere between 500 records to 5000. Do you have any recommendations?

I’m looking for help on being able to speed up my Ranking query. Below are a couple of my Rank formulas. And way below is what I copied from access sql. How would I clean it up so my query will run faster? How would I make this a actually sql statement, so that it will run faster. Or should I...

Does anyone know how I can speed up a Ranking query? I’m currently using the formula below: Rank: (Select count(*) from qryCustomerTotals1 as B where qryCustomerTotals1.CustomerTotal > B.customerTotal) From reading on the web, some people talk about doing it in a modules, they even give some...

It worked, thanks for the help again guys. Your guys ROCK