Search results

My report shows check number, broker name, and the amount. If the same broker name, there will have the same check number. Example, my report shows 2 check number 3, and the broker name for these 2 checks are the same, but the amount are different. I want to group the check number so the amount...

I want to print out the counting number for each record in my report. But if my record duplicate then the number for that record is keep the same. Example: record number 1 has 1 building, then the next line is 2 which has 1 building also, but if go on say like 3 and it has 2 building priting...

After user enter the begining date and ending date, how to tell the report print out those date had enter? And how to set a warning if the query doesn't have any record that user want to see? Please help. Thank you!

I want to build a text file in Access. This text file which I will use to print out a check for broker. And I don't know how to start it, does any one know how? Please help!!!Thank you.

I'm working on a report when enter a zipcode it will show a specifice area. But there are some zipcode with 10 numbers in the zipcode field. How do I make it that when the user just enter the first 3 number of the zipcode it show most of the zipcode in that area which includes the one with 10...

I want to display a report close date from a closemonth table. I can only display that close date field in the report's detail only. I want to show it in the report header, but when I put the field name on, it automatic has the equal sign (=) in front of it. And couldn't get the close date...

I want to print out a due date in my report, and the condition to print out is that: if the type is 1 or 0 then use the enddate else use the transdate. How do I create an if statement to tell the report to do this? Please help!!!

My report shows that broker in sorting by broker's name and 1 broker can have many clients. I got problem when doing sum for any client have the same name and same id. Do I have to make a new query? Or should I go to report design and do something which I don't know how to do yet. Any help is...

I want my report not showing the current new balance if it 0.00. But the problem is we keep track all the customers who haven't pay us since 30, 60, 90days and so on. When the report comes out, it showing that customer's in the current column is 0.00. If I display the report not showing <>0...

My report shows the record from 90-120days since the postdate of the amount. The user don't want to see it, but they want the total come out right when calculate the prevous balance for last couple months. I don't want to make that column (90-120days) to be 0, because when it updates for the...

My report was working fine but since I renamed my queries and changed my Macros (did checked the name as well) I did not get my report back. All I got is #error for the data. Can anybody help, please? Thank you.

When my report prints out, there are some line that have 0.00 value. I want to skip those lines and not printing them out. Does anyone know how to do that in Macros? Please help. Thank you!

I'm trying to print a report which has to be difference dates for every month. What I have done is that my report only print out the right number when the close date is the beginning of each month (like every 30 days in circle) Example: when my closedate is 1/19/01 the report is not printed...

I'm working on a report, and I just want to print out only the month and year for that report (i.e. 12/00) . Is there any way to do that? Please help

Please help! When printing out the report, I want it automatic appear the closedate of that month (like 11/17/00). What should I put in the Control Source?

I have a table of a closemonth (the dates for every closemonth are different. Like close month for Oct: 10/20/00, and for Nov: 11/17/00 and so on till the year 2001). I have problem when running the query that know what month should I want to open the data for that month (This program can't use...