Search results for query: *

Hi Duane Here is what it would look like Group A Client 1 Billings $2000 Client 2 Billings $15000 Client 3 Billings $1000 Total Billings for Group A $18,000 Group B Client 4 Billings $3000 Client 5 Billings $1000 Total Billings for Group A $4,000...

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

Hey Duane That is what i had done and that was the error i got when i tried to view the report... any suggestions...thanks again dave

Hi Duane I entered this and i get an error saying the following "The expression you entered on format as the event property setting produced the following error: Invalid outside procedure" not sure what to try ...

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

Hi All I got it working...thanks for everyones help. dave

Hi Shannonp1 I am so close to getting it working but I am missing something...If you could send me the small report it would be greatly appreciated..thanks kindly dave

thanks Maq I had tried that to but it still puts up the month and the year and does not isolate it to just February March april May June July Aug...it keeps it as feb 02, mar 02...so it does not plot over each other...any other help would be greatly appreciated dave

Sample of what it is I am trying to do...I will use February as an example In february 2001, I have 62 new clients worth an estimated billings of $86,000. In February 2002, I have 73 new clients worth an estimated billings of $89,500. When a new client is entered into the database, I enter...

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

I should elaborate on this a bit more, i want to print only the record that they are looking for. For example, they open the form, the person is looking for Client B and when that client appears, they want to print that client and only that client. thanks

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