Hello friends,
I asked this Question for 2-3 times  but nobody answered me !!!!!!
Question is  I need to do Accumulated sum  in  ToDateQty  Field from
ToDay's Qty field.  

Hi - I'm looking to query a field that has TIN (taxpayer id numbers) this is
entered in one of 2 ways either as an EIN (nn-nnnnnnn) or as a SSN
(nnn-nn-nnnn).
Is there a way that I can run a query that will give me just the

I need to make a report which using "month" sumerize the qty used in the
month under each item.
How can I do that?
The table set up the month field as TEXT (Jan, Feb, March... etch).

There is my Query:
SELECT DISTINCTROW
Sum([Lodging]+[Taxes]+[Food]+[Parking]+[Mileage]+[Rental]+[Gas]+[Taxi]+[Phone]+[Computer]+[FAX]+[Metro]+[Tips]+[Train]) AS Stotal
FROM tblTravel;

I have got a problem in my query.
I have a make table query and its columns. And another query wich uses this
table and other tables to make calculations.
when i run the first make table query and then open the second query in

Hi there, I have a table with 13 fields. Within each field, could be one of
upto 10 values. I need to write something to count how many occurrences of
each value there are across all 13 fields. Easy to do for one value in one
field, but this way, means 130 pieces of query needed. ...

I am using this code in a query field in design view:
expr1: DLookup("TimeItemNo","lkupTime","TimeDesc=" &
DateDiff("n",[StartTime],[FinishTime]))
to pull up a code number (timeItemNo) that matches a certain period of

I need a query that joins two tables on three common fields. It needs
to be a LEFT JOIN in that the I need ALL records from the first table
but only matching records from the second. This is not yielded by the
following SQL:

I want to track inventory delivered by a producer to where it is sold.
The first part is to allocate shipments to delivery note reccords, and I
mannaged to create this query. Very proud of myself.
SELECT [Delivery detail].DeliverydetailNo, [Delivery detail].CasesDelivered,

Problem:
Given a table like this:
Create Table IPList
(

I have a question about using date and time in the following format:
yyyymmddhhmmss, i.e.
20070328144801
I have a column in a table called ScLoadTime. I am trying to do an

I have a table of training records, and I want to run a query to
filter out a list of staff,  from a staff table, which indicates those
who haven't completed a particular course.
TblStaff and TblTraining both have [EmployeeNumber] field

I have written a query (using SQL) that has in it a calculated field
which in itself uses a subquery to perfrom a sum() function of a list
of values.  When I view the query results directly, the returned
values are calculated correctly.

I have a query that selects employees based on their particular affliliation
with specific companies. However, sometimes I want to be able to select the
employees in the dropdown box with out them being connected to a company. How
would you write the query to either select the ...

    I have a cross tab query with hour of the day as column heading.
    The result shows hours, 0,1,2,3……..23 as columns, a total of 24 columns,  I
am trying to group hour 0 to 5 together as one group, and shows as one
column, so the result would shows 0 to 5 (one column), 6,7…….23.