i have a number field like the following:
125645
1236544
54623211

I have a table with 2 fields (Department_Name, and the responsibilities for
each department):
Department_Name         Responsibilities
Dept1                            a, b, c

UNION
SELECT 19 as MyID, ActivityDate as [Activity Date],  tblEmployee.first_name
+ " " + tblEmployee.Last_Name as EDA,
(Select count(*) from tblEDAActivityPlanMeetingDetails where

I'm trying to figure out a way to this without adding 7 queires to my macro..
I have a data set that has a column for Date and Time.. Below is an example
row_date        interval               split    callsAnswered
27-Mar-08       10:00:00 PM    822        0

Hi to all,
I am gettin the folowing error "operation must use an updatable query"
with the following :
UPDATE BudgetHST SET BudgetHST.Avril = (SELECT Avril FROM GrossMois WHERE

I have a table that has 2 fields with the following data
field1                    field2
department1         a, b, c
department2         d, e, f

My boss has asked me to make him a complicated report. I use Crystal Reports
most of the time but for this report I need to make some queries in access
first.
Basically here's what he wants:

I have a form bound to a table.  I want to use the form to enter new records
in the table.  There are 3 fields in each record that are limited selections -
the choices are kept in separate tables and these fields are joined to the
related fields in the main table.  The 3 fields are ...

I'm running a query that joins two sub-queries.  It doesn't work when I use
an inner join, but works when I use a left join.  The SQL is:
SELECT [0106 treat srcedat gwsw 3].*
FROM [0106 treat srcedat gwsw 4] INNER JOIN [0106 treat srcedat gwsw 3] ON

HI,  I have a query that finds duplicates based on [firstname] and [lastname]
which works fine however what we have discovered is that if the name has a
variation i.e. Rob instead of Robert it wont detect it.  I would like to
build an If statement so that if the 1st character (or ...

Hoping someone can help.  I've got one table with a list of transactions,
each transaction has a user code assigned to it (i.e. AA, aa, Ab, BA, etc.)  
I have another used id table that has the same user codes with a person's
name in another column  (i.e. AA  John Smith).  I'm ...

Our Project Manager hates SELECT *, he wants us to list all columns in our
SQL. Does this make a big difference in Access? The PM is mainly a SQL Server
person and apparently it makes a big difference there, but does it in Access?
He explained that with SELECT * the database ...

Hello,
Can somebody help me with a problem I have?
I am importing a text file into a data base and the data in the file is
simular to this.  

Can anyone suggest a work around on this problem. It seems that formula for
date difference, weekdays does not work in Access 2003. The formula to
calculate the date difference (# of weekdays) between 2 dates gives the
week's difference. The formula is:

When I divide two numbers in a query the result is displayed left aligned.
How do I get it to be right aligned?