Search results

It's worked great. Thank you!

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

Rich, I can't find them. Please show me more where to look for? Thanks.

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!

The text file looks like the format above that I gave. And here's it again: * * SEE ATTACHED STATEMENT * * $ 1,083.96 $ 1,083.96 SEA-MOUNTAIN INSURANCE BROKERS 131-2ND AVENUE SOUTH EDMONDS, WA 98020 All information should pull out from fields in tables...

Pat, I have all the tables and queries to know what fields I need for. I tried what you said before and didn't get what I want. How do you build a text file then import into Access with a list of what you want to print out? Should I build a text file in Word? Note Pad? but then I couldn't get...

Pat, can you explain more for me please? I totally don't know how to do it. My program has to do these things: first print out a statement of list who need to pay, then after the statement will print out the check of that list. The format for the text file I want to do for the check print out...

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.

Thank you so much, Fornatian. It's worked very well. Thanks again!

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

Thanks Charityg! It's worked very well except for some balance is made up of multiple records and the duedate wants to see on the report would be the earliest duedate. Any more suggestion is very appreciate.

I'm sorry Charityg that I didn't mention about the 30 days after. If type is 0 or 1 then duedate is 30 days after enddate otherwise, duedate is 30 days after transdate. Could I still use the control source to do it? or I have to use the update query?

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

Thank you so much for your help. It's worked wonderfull.

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.