Search results

Has anyone else experienced this issue? when using vba to send emails ( i send about 1600 a day to different recipients with different data and attachments in each one.) it seems that i am only allowed to send 5 a minute. I need to increase this to 100/minute. I checked with my exchange...

need query to transpose data ID numStore cntStoreManager cntAstMgr cntTeamLead cntReceiver cntTeamMemb sumTotalLoss numDate 1 100 0 0 1 1 10 12 20141227 1493 100 0 0 0 1 12 13 20150124 2985 100 0 1 0 1 11 13 20150221 4477 100 0 1 0 1 10 12 20150328 5969 100 0 1 1 1 11 14 20150425 7461 100 0 1 1...

I have a table that has 108076 rows and 8 fields wide 4 percents, 1 currency, 2 numeric (store & deptNumber) and 1 text. i need to rank each store(1500) by dept(74) Sales$. I have tried this Rank: (select count(*) from [qryTop10Dept] where [qryTop10Dept]![Store TYTD Sales $]>= [cw]![Store...

I have 2 tables tblSales & tblFiscalDates. In tblSales, I have datWeekended and curSales. In tblFiscalDates I have datWeekEnd(Saturday); datWeekStart (Sunday); datFiscalMonth; datFiscalYear; datFiscalQtd In my query I want to use a criteria that uses Now() to get fiscal month. I have tried...

Trying to look up fiscal month from another table. looking at Event Date and fiscal table has a start and end date. Where is my formula incorrect?? fMonth: DLookUp("[fiscalMonth]","tblFiscalDates","[EVENT DATE]<=[tblFiscalDates]![datWeekend] And [EVENT DATE]>=[tblFiscalDates]![datWeekStart]")...

Really not sure which way to go with this new requirement and need your help in deciding what is the best and easiest way to accomplish the following... Currently have an Access db filled with different departmental information. Trying to build a workflow mechanism that will validate the...