Search results for query: *

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

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

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

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