I have a datasheet From Access that has approx 600,000 rows. I need to export that to at least 10 woorksheets in excel. Can Anyone supply code that will do that.I only use sql for querys and I not familiar where in Access to place programming code.Please supply that as well if possible. thanks...
I ran a query that came back with 145,000 rows of information. I need to export that to excel. However Excel will only except 65,536 rows. I need some sort of workaround on this.
I need to select all merchants via the merchant-id that have process for 12 consecutive months. Processing means that we have received payments via the merchant 's credit card. The processing information is held in the processing date column and is reported in days not months.
I am not sure...
Lespaul..Thanks fo responing, i was out yesterday.. I will rerun your initial answer and giv you a baetter senario of what is going on later today.. thanks for hanging with me
PH I ran this part of the code and it ran fine as long as i added the group by clause, Howver when I aded this
AS A INNER JOIN qry_CNT_Contracts AS B
dbo_CNT_Contracts.MerchantID = B.MerchantID AND MerchantID, dbo_CNT_Contracts.FirstFundingDate >= B.FirstFundingDate
GROUP BY...
You are correct! that is exactly the average interval in days between the the first and 2nd contract purchase, the numbers of days between the 2nd and 3rd contract purchase. I need to run that query against the entire 20,000 records merchant table. I have multiple mercants wih multiple...
I don't understand your response. I can run a query using
this AVG(DateDiff("'d"([date1],[date2}) But it only will give me the average of each row. I need the average of the number of days between each new contract broken into intervals between the first and second contract, the 2nd and third...
Thnaks .. I'll be more clear. I need to to get the average days between dates at selected intervals. I have customers who have open new contracts and paid them off with out defaulting at different dates.
This particular data set has several different open and paid contracts. I used DateDiff...
I used Datediff for the answer. It gave me the numbers of days between the purchase and the payoff. However.I have customers who have several purchases over time. I need to find out the average time between purchases
I have code that gives me that gives me the customer name,the purchase date, the date the customer paid out the contract completly but never defaulted before paying out.
I am trying to find out the average numers of days between the 1st and 2nd contract purchase, 2nd and 3rd purchase...
The code is Select avg(turn) from (tablename) group by funding_date. The averages are base on the individual day. I need the averages to be based on a month by month basis.
Thanks again
I need to group my data by month. The query I run gives the average of a select column of numbers but groups by days instead of months Below is my results. I need to group the averages by month instead of days. My code is simply not working Thanks in advance
6.762790698 1/2/2004
6.708717949...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.