Search results for query: *

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...

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)...

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.

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.

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...

I have the following below Account No Occcupant Code 40512400 11 I need a formula to show 4051200-11

I have a SQL query in Access as follows: 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 FROM Northstar_live.harris_live.pu_balance_hist pu_balance_hist WHERE...

QUERY 1 ACCOUNT_NO = ‘30123000’ OCCUPANT_CODE UTILITY_TYPE = ‘W’ JOUR_CODE = ‘CR’ TRANS_DATE Between 12/1/2012 – 4/30/2013 TRANS_AMT Results are as below which is what I want to see. Those are the payments made for the utility (W)Water ACCOUNT_NO OCCUPANT_CODE UTILITY_TYPE JOUR_CODE...

I have a query that I wrote in Access and it givs me the following: ACCOUNT_NO OCCUPANT_CODE NAME 10011250 12 JACQUELINE W TEST1 10011250 11 JAQUITA TEST2 10011250 10 LALISA A TEST3...

I have 3 columns of data as follows: Col 1 Col 2 Col3 Col4 2262 RUGBY TER ???? In the 4th column I need a formula that would combine all 3 columns. So far I have =LEFT(X198,4) for columne 1. How can I add the other 2 columns?