Search results for query: *

Hi All I am currently trying to sort a report My report looks like this... Group A includes different clients ie. Group A Client 1 Client 2 Client 3 Group B Client 4 Client 5 etc... I am trying to sort by billings for each group. When I try to sort by group it...

Hi All, Hope somebody can help... I have a report created and I am trying to display the top 5 clients for each employee in terms of billings...the billings is a sum of multiple billings throughout the year...when i do the select top 5, it gives me only the top 5 clients in the entire database...

Here is what I am trying to do... My main form has 3 steps... first is the contact information for the contact that has been created. The second step is to ad a drop down box for the team that created the contact ( ie. Team 1, Team 2 etc) and my problem is once I select the Team that collected...

Hi Hope someone can help me with this one. I have a form created that allows printing of clients that are selected. i.e. Client A is selected and all necessary mailing information is printed on the report (envelop) that has been created. Problem...If I want to change the contact person in...

Hi All Hoping that someone can help me. I am creating a report from a query. My 2 columns in question include Unpaid Balance and Type of charge. The type of charge includes Invoices and Interest and the Unpaid Balance is simply the amount owing on these charges. I am trying to do a report...

Hello All, I have a description field in a database that I'm working on. It is a field with a description of criteria used to create certain queries. What I need to do run a script or query that will loop through each record and create a list of unique words that appear in the field and then...

HI hope someone can help... I am currently running a report to generate the top 250 customers to our business by annual billings. The fields i am using is client ID, Group Name, and Annual Billings. When I create my report using the report wizard I select Group Name as my grouping level as a...

I have created a line chart so I can track billings over the past 3 years. The chart is not working the way that I want it to though. The problem is that it shows the billings for the last 3 years. Instead of overlapping (i.e the month of February displaying feb 00, feb 01 and feb 02) the...

Hey Hope someone can help. I am still new at Access. What I am trying to accomplish is: I have a client lookup form created. When someone searches through the form and finds the client they are looking for, they would like to print the information onto an envelop. Is this possible. Any...

I am currently trying to do a mail merge in Word from an Access database. I want to have my records sorted by last name and the mail merge does not provide me the option to sort by record so it is sorting it by client ID which is a pain as it is not in alpahbetical order. (The tab Filter by...

Hi Hope someone can help. I have a created an access database by exporting information from an accounting database that was already established. My problem occurs as I have numerous companies with unique ids, but one person can be the main contact on many of these companies. We are trying to...