I have queries for marketing purposes which keep track of how clients heard
about our company.  The query counts how many times each response (i.e.
internet, newspaper, etc.) occurs in a table of callers.  I have three
seperate queries; one returns the numbers for all calls, one ...

I'm using a UNION query to join survey results for different types of
questions (rating questions are in one table, text answers are in a different
table). I ran into a situation where using UNION ALL to get data from the two
tables was only bringing back data from the first ...

I have a table:
Emp_no      Date         Time      In/out
58001        27/7/06     7:01         In
58001        27/7/06     8:23        Out

i have 2 standard fields
[Doses]
[TxnType]
i want to have the following occur

Hi
We have some software which records all the shipments of goods to stores day
by day. I have a query which summrises these shipments by store on a monthly
basis eg 30 to store 1 , 25 to store 2 etc which works fine. However I now

This must be easy, but I can't find it nor figure it out.  
I have a database with addresses in it.  When I change an address [even a
small part of it] I need to mark the old record as obsolete with a date and
create a new record, sometimes almost identical to the old one and ...

Hello all,
I have a database containing over 1.2 millions records in one table.  I have
added two additional tables containing X codes in one and Y codes in the
other.   I need to remove from the main table any records that do not have

Hi,
I have a very basic database with two tables for a sports club. First table
is called 'Swimming Table'. This contains 2 fields 'Name' and 'Address'. The
second table is 'Gym table'. This also contains 2 fields 'Name' and 'Address'.

I have a postal code field, when I run the query to ask the user which
postal code want to view.
I need to use like now, so if If the user wants all the postal codes
which begins in 17, Selec * from PostalCodes where "[PostalCode]*"

I can create envelopes from Access into Word, but only as a snap-shot. When I
update my database my envelopes do not update. Any ideas please? I am using
Office 2003.

I have a database of about 7000 records, 8 fields, that contains a fair
amount of VBA.  The database started to get a little large, so I tried
to compact and repair it.  After it compacts and repairs, when I try to
run the VBA, which simply runs a query, then opens a form that ...

I've built my query, and it works, but if I go into the SQL view it
generically informs me I have a "Syntax error in FROM clause" and sets the
cursor to the comma before "Max(Year)" in line 3. Any ideas what Access
doesn't like?

I want to update sick time accrued to 8 hours when an employee's start date
is between January 2nd and May 1st in the same year as a date entered by a
user. For example, if the date entered by a user is 12/31/2005, and the
employee start date is 1/14/2005, sick time accrued would ...

I am trying to randomly select a client on a form. The query behind the form
is as follows:
SELECT TOP 1 Rnd([ClientID]) AS Shuffle, tblClients.ClientID, tblClients.
Client

I have shared my database on a number of networked pc's and set-up
usergroups to control access to certain objects (database has also been
split). However, now that I have distributed the front-end to
colleagues, my security file has been set to apply to all other