Search results for query: *

PCLEWIS, You are a champ, this code is exactly what I waslooking for. Cheers, Tongaman.

I have a table with the following fields Product New_Customer Old_Customer Potential_Customer Car1 100 200 300 Car2 200 300 400 Car3 500 600 700 I would like to write a query that would make a table that looks like...

Apologies for the typing error. The field should be ACCOUNT_NO and not ACCOUN_NO. Cheers...

Hi. I would like to get some help to split a text field into two separate fields I have a table called CUSTOMERS with a field text field called ACCOUNT_NO The ACCOUNT_NO field is 9 charatcers long I want to be able to write a query to split the current values in the ACCOUN_NO fields into two...

Is there a way that I can apply a custom sort in a report rather than the default sort ascending and sort descending. For example, if I have a field with values "a b c d", can I sort in my report to get "C B D A" rather than the default ascending "a b c d" and descending sort functions "a b c...

Willir, There is no primary key - each record is identified by item. Thanks....

Willir, Here is my sql below. Unfortunately, I am not an expert in SQL and I am not getting the desired result. SELECT table1.Cost_Date, t1.Item, t1.Amount FROM table1 Where Cost_date = (dateadd("yyyy", -1, Cost_date));

Can someone assist me to write a query on Table1 below that creates a new field that shows the cost for an item one year ago. Thanks in advance! Table1. Date Item Amount 1/april/2002 Car 100.00 1/april/2003 Car 200.00 1/april/2004 Car...

Can someone assist me to write a query on Table1 below that creates a new field that shows the cost for an item one year ago. Table1. Date Item Amount 1/april/2002 Car 100.00 1/april/2003 Car 200.00 1/april/2004 Car 300.00 1/april/2002 Truck 400.00 1/april/2003 Truck...

Hi Tony, Thankyou once again, it works perfectly! Cheers, Tongaman

Tony, I added the new section you suggested to my sql code below but Im getting an error stating "argument count mismatch". I am not sure what this referring to. SELECT Format([t1b].[Date],"mmmm yyyy"), [t1b].[Amount], SUM([t2b].[Amount]) * NOT IsNull(SELECT...

Tony, You are correct. As their are no values for Jan, Feb, and Mar 00, the total values for Jan, Feb, and Mar 01 should be zero. Currently my sql code( below) returns a total for Jan, Feb and Mar 01. SELECT Format([t1b].[Date],"mmmm yyyy"), [t1b].[Amount], SUM([t2b].[Amount]) AS [12...

Hi Tony, I've been asked to modify my report to give a true 12 month rolling total. Do you have any suggestions how I might do this. I have detailed below the current results on my report and a desired report results. Current Report Results Date] [Product] [Write-off Amount] [12 mnthr...

Tony, Thankyou very much for your help, my report is looking great. If your ever come down to Melbourne- ustralia, drop me an email and I'll buy you a beer! Cheers, tongaman

Tony, I added a product field to my table and modified my sql code, as per your suggestion above, to give me a 12 month running write-off total by TRUCK. However, I found that the the 12 month running total was also adding the write-off total for the CAR. Any suggestions? Here is my sql...

Tony, Apologies for being vague in my examples but your solutions have been great and now I am able to complete my first report on ACCESS. As a matter of interest, if I was to add a [product] field to the table, how would I modify the sql code above to provide me with a rolling total based on...

Tony, Thankyou for your help the query worked great. On a similar note, are we able to modify the query to calculate a rolling write-off total based on the the sum of the totals for the 12 months. (refer below) [Date] [Write-off Amount] [12 month rolling write-off] 1 Jan 01 $10.00...

As a new Access user, I was hoping if someone could help me write a query to calculate a running 12 month write-off total based on the table details below. If someone could assist me I would be greatly appreciated. Current Table: [Date] [Write-off Amount] 1 Jan 01 $10.00 1 Feb 01...