Search results for query: *

I believe I have it working now. I am using this SQL script SELECT qry2013DailyTransactionPercentageQuery.[TRANSACTION DATE], qry2013DailyTransactionPercentageQuery.[PAYMENT TYPE], qry2013DailyTransactionPercentageQuery.[COUNT OF PAYMENT TYPE], qry2013DailyTransactionPercentageQuery.[TOTAL...

One question... I know that A represents [2013 Daily Transactions] so what does B represents?

Here is the SQL Code in my query? SELECT [2013 Daily Transactions].trans_date AS [TRANSACTION DATE], [2013 Daily Transactions].descript AS [PAYMENT TYPE], Count([2013 Daily Transactions].descript) AS [COUNT OF PAYMENT TYPE], Sum([2013 Daily Transactions].trans_amt) AS [TOTAL AMOUNT] FROM [2013...

I created a query and from the query I created a report. What I am trying to do is crete a formula that will give me the percentage. For example.. Cash 105 Check 200 Cross Applied Payment 16 Debit 56 Money Order 87 There are 5 Payment Types which is the field name with the count of...

Thanks MajP: I got it to work.

I just want to be able to see the other reports that are built like CCPK Discount Employees Fulltime1 since they are he same but with different information on it.

Thanks for the quick response MajP but I am confused where do I put your answers in my script? stDocName = "CCPK Discount Employees Fulltime1" DoCmd.OpenReport stDocName, acViewPreview, , stWhere stDocName = "Your Report 2" DoCmd.OpenReport stDocName, acViewPreview, , stWhere stDocName = "Your...

I have a question. Look at the script below. Where it says stDocName and strQueryName how to add multiple entries? When I click on that button to generate the report I would like for multiple reports to pop up. Private Sub Generate_CCPK_Employee_Discount_Report_DblClick(Cancel As Integer)...

I have a question. Look at the script below. Where it says stDocName and strQueryName how to add multiple entries? When I click on that button to generate the report I would like for multiple reports to pop up. Private Sub Generate_CCPK_Employee_Discount_Report_DblClick(Cancel As Integer)...

Thanks bluedragon2 that worked perfectly.

I have two columns Last Name First, Middle Harris Vincent D. How to merge the two columns into one column. I need a formula to have the whole name under one column.

Thanks...PHV and genomon. I was able to generate my report.

I have a query I am building in Access. I am using the fieldname call net which gives me the amount of money billed. I have about 800 records. Is there a way to rank the amount of money from the highest to the lowest? I need to pull the top 25 highest money billed.

What I did was write Month([trans_date])and it gave me the number of the month. For instance if the date says 1/1/2013 it gives me the number 1 for January. What I would like to see is January 2013. What I have tried so far is Month([trans_date])'mm-dd-yyyy' and that did not work.

Thanks bborissov In my SQL below I have the order that I want as far as the trans date and account no SELECT pu_balance_hist.account_no, pu_balance_hist.occupant_code, pu_balance_hist.trans_date, pu_balance_hist.jour_code, pu_balance_hist.trans_amt, pu_balance_hist.desc_code...

I forgot to add that I wanted to sorted by trans_date then by account.no ORDER BY pu_balance_hist.trans_date ORDER BY pu_balance_hist.account.no

I have a ODBC query created below: SELECT pu_balance_hist.account_no, pu_balance_hist.occupant_code, pu_balance_hist.trans_date, pu_balance_hist.jour_code, pu_balance_hist.trans_amt, pu_balance_hist.desc_code, iccpaymc.descript, Month(trans_date) FROM Northstar_live.harris_live.iccpaymc...

I am creating a query and I added a column to show the actual payment type. Fo example the Pay Methods are 1 - Cash 3 - Debit 4 - Money Order 6 - Online Payment When I try to build this I am getting PAYMENT TYPE: IIf([harris_live_ichrecpt]![pay_method])="1","Cash") which does not seem to...

COMBO: That worked just fine!!

The formula is not working for some reason. I need to be able to see in a new column: 4051200-11