Recent content by mtp

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