My Company has different departments.  Department name  e.g. : A, B, C, D
I need query telephone number of department in departmentwise.
I assume this will be o.k. in case I arrange thru main form and sub form
basis.

I have a query and its acting up when I add the following column
Followup: IIf([vTracking]![Datecompleted]-[vTracking]![Date]<=2,"Completed
<=48",IIf([vTracking]![Datecompleted]-[vTracking]![Date]>2,"Completed >
48",IIf([vTracking]![Datefollowup]-[vTracking]![Date]<=2 ...

I have a table called COLUMN (not a good name I know).
Insert into and delete from SQL statements work fine with the table,
however, when I try to add a column to the table using the following code:
"ALTER TABLE COLUMN ADD IS_DEFAULT YESNO NOT NULL"

Hi, I have a crosstab query which has the date as column headings. If in
short date format the order is displayed correctly. The problem is I want it
to also show the day of the week and when I tried adding this the sort order
was incorrect. I used Format([ReviewDate],"d mmm"", ...

Been working on this for a long time...
My table contains sales & income from 2004 to current... thanks to this
group I am able to query YTD and MTD 2004 and 2005 on the same report.
BUT when I query 2005 only, report lists every single customer, showing $0.00

I have a query that has 3 columns as follow:
Origin
Net Weight
Destination

I am wanting to use the following SQL statement in a larger UNION query but
am struggling to get it to work. I need to do a nested SELECT so as to only
include the K5 records that match the query.
The database is in Access 2003 and I am using WinSQL with ODBC connection.

Hello, I am an admitted novice to Access.  My company is trying to se
up a database application to track the inventory levels of differen
parts.  We have a field titled "Part Number", and want to search fo
any occurences of identical part numbers showing up in different row

For example I have this table :
No.    Type    Date    Amount
2    a    03/03    120
5    b    10/03    130

I need to have a query that pulls data from a table that has 4 fields that
represent route days in a month. What I want to do is select only clients
that have lets say route day 4. I have tried using criteria and an unbound
control in a form but I keep having the same problem. I ...

I'm quering a table with 5 fields.  In the query, I'm using the same critera
for all fields but this will only give a result if it matches all fields.  I
want the query to return an answer if it matches data in any of the 5 fields,
how do I get this to happen?

Quick version of question:
I have a table with that I want to sort on one columb, and have no
duplicates in the other.  I only want the no duplicates in one columb and I
want to sort after the duplicates have been removed.  How do I do this?

I think this is easy but I looked on the MS website and the newsgroup and
couldn't find anything.  I have a query with two tables ("bills", "paybills")
that have a relationship of 1 - many respective.  I want to use a combo box
that looks up field "A" in the "paybills" table and ...

I have an employee database with FName, LName, Start_Date.
I need to be able to choose two dates and select all people who fall between
these days within working 30/60/90/270/450 days since there start date.
For example, I want to see anyone who has been working for us for

Is there a function to get the max of different fields for
a record?
For example, a table looks like
ID  number1 number2 number3...