I need to have all the departments in the department table to show whether
they have information in them or not.  The query that I am using is
SELECT tblAllWorkLoggedRecords.Date, tblDepartment.Department,
Sum(tblAllWorkLoggedRecords.[VOLUME RECEIVED]) AS [SumOfVOLUME RECEIVED]

In my table i have phone column. The data format in this column is look
different.
For Example: (800)333-4622, 800323-8800 and 8003233800. But in my form
format should be this way: 800-333-4622. To able to format this way first i

I have a query that uses a query to get the data I need. Basically it includes:
Part No
Price
Qty

I want to open table and check to see if PDN exsists in that table
  If PDN is in the table i would like to update that Record with some
txt boxes
If PDN is not in the table i want it to insert a New record

I have e a problem merging data of several rows in one table in Access
2003. The table structure looks like this:
-------------------------------------------------------------------------------

I recently found Allen Browne's Search Criteria program on this site that was
a great answer to a project that I have been trying to do. Everything works
great except for one search criteria.
I have no experience in Visual Basic and do not know how to modify one of my

SELECT index.id, Category =
                           CASE
                           WHEN (SELECT Compond_link_types.id FROM
Compond_link_types WHERE  Compond_link_types.id>0)

I have two tables with the following fields:
Table A(100 records):
FirstName
LastName

  I have a DB that contains client personal details, and billing details.  
I have a query that produces a list of clients that have been to see me
within a given time period.  My query gives me the list I want, except that
if a client has been to see me more than once in the ...

I am trying to use an embedded DLookup inside a DSum to calculate funding for
fiscal years.  The fiscal years will change but not the fields being summed.  
I am using a separate table for the fiscal years and referencing each query
inside itself to sum the queries.  I have ...

Hello and thanks for your help. I'm new to Access and am trying to figure
something out. I posted a similar question last week, but am still getting
the wrong data in my query. Any help much appreciated.
I have two tables, one for Athletes (and demographics) and one for Injuries.

Using the Design View to create a query, here is what I have;
UPDATE tblItem SET tblItem.itemMfgItemNumber = "Fit ABS"
WHERE (((tblItem.itemMfgItemNumber)="Fitting ABS"));
That of course didn't work like I thought. :-)  I need a bit of help

I have 3 yes or no fields, the first field is always a yes/Injury field and
the 2nd/Lost Time and 3rd field/Medical can be yes or no depending on what
action was taken with the injury.   When I run the query it will only show
results if the 1st, 2nd, and 3rd field are checked as ...

Duan Hookom posted a link (http://www.tek-tips.com/faqs.cfm?fid=4524) to a
method for generating a multi-column xtab in response to a question
yesterday.  It took my interest, so I had a play with it, using the
Northwind database.  In the course of this, I found a problem when I ...

This seems simple but I am hitting a brick wall.  I have a customer
visit table that lists each visit I make to a customer.  I want to be
able to run some reports that will show the last time (not each time) I
visited each customer.  My original thought was to create a crosstab