Queries

Running Total in Access 2003
I have a query that has 4 columns Date, Qty, UnitPrice and Amount. The amount is a formula that multiplies Qty x UnitPrice. I would like a 5th column that gives me the running total for each line. So the first line is the first amount. The second line is the second amount plus the first amount. The 3rd... 9 Jul 2008 11:38

Problem with fConcatChild
Hi, I was hoping fConcatChild would be the answer to my concatenation problem I am receiving really strange results. Here's my 1:M data (Directive-Number is in tblMaxDirective and GSWT# is in tblGSWT): DIRECTIVE-NUMBER GSWT# 115451 34 125061 90 125061 ... 9 Jul 2008 10:37

IIF Statement - HELP!
I need help with an IIF statement for the following: If StdPrice = 0, give me "rebill" If Part# ends with "-OSP",give me "outside processing" I got the first part to get "rebill" but I can't figure out how to write the "part# ends with -OSP"... Please help! Thanks, Susan ... 9 Jul 2008 10:37

GRUOPING + SUMMING AND COUNTING
I have a table containing the following fields Code Car type Ownername Ownership% 002 Toyota Pickup John 50 002 Toyota Pickup Odi 50 005 Mercedez Trailer Aish 100 006 Nissan Patrol Ohi ... 9 Jul 2008 09:35

Compare dates
1- How can I compare various dates in Access query. For example, I have a "purchase date", "sold date", with which i want to compare with a "start date" and "end date". The date format is dd/mm/yy. Can this comparison be done in 1 condition; i.e start date < purchase date < end date,.. 2- Can date comparison be ... 9 Jul 2008 10:37

splitting fields of ids and title.
Hello, I'm wondering if anyone can help - i have an id field that i would like to split into a few fields wherever there is a dash i want it to be a new field. if there are 3 parts to the id. there can be 2 parts or 3 parts to the id e.g. P2503-565 or 123-4567 or p765-456-765 and i want to split into a separa... 9 Jul 2008 08:33

need to calculate the quartile in ms access
how can I show the quartile (25 percentile) or (75 percentile) of a data ... 9 Jul 2008 08:33

Copy records without dupliacates
Hello I need a query to copy records from a table to another table without duplicates. Many thanks in advance and your help is most appreciated. Carlos -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200807/1 ... 9 Jul 2008 02:26

Need help with calculation
SKU June08 NET LBS/CS July08 NET LBS/CS AUG08 NET LBS/CS 15010664 #error 24 #error MCL03622 #error #error #error BCI00255 17 17... 17 Jul 2008 15:48

autonumber - function
Hi, I will like the function. Is there a way to make it a default as 0 in the table: tblHighNum. Public Function isIncrement(ByVal var As Variant) As Long Dim lng as Long lng = DLookup("Num", "tblHighNum") + 1 CurrentDb.Execute "UPDATE tblHighNum SET Num = " _ & lng isIncrement... 9 Jul 2008 08:33