I have mail merge documents, which link to Access queries, but on a computer
with Access 2000 they have suddenly stopped working. The reason appears to be
that the queries will not run because Access has stopped recognising
functions such as right and format. Any suggestions? Do ...

I have a query which selects a field containing the path and image name for
an image. The field is called ImagePathAndFile and typically contains C:\My
Pictures\Mvc0000.JPG.
I posted a question as to how to produce a field containing just the image

Thanks in advance.
I have 2 tables in access that contain add info and person info.
Ea address can have many people
What i need to do is find out how many addresses contain lone parents

I am trying to make a query which will dynamically show a different number
of records for each ClientID based on a date.  I know that doesn't make much
sense, so let me try to explain more.
I have a query which outputs the following fields:  

Hello, I have 3 tables (Cuase&Effect_tbl, Catalogue_tbl and a comments_tbl)
Comments table and catalogue table can grow as additional items are added.
The Cause&Effect_tbl shows the combined data and allows you to add more of
either one by assigning its ID value to Comments_tbl ...

Hi
I am a new user and would love to know how to do the following
I have a column of deaths and the date format is 12 12  2005
I need to change this to read 12 Dec 2005

I made a table according to the wizard "mailing list"
I made a simple input form
I made a querry(with the wizard, again,) made by first name, last name,
phone numbers.

I have a table called Monthly Reading, it has following fields, Customer
Number, Year, Month and Reading.
Now I want to know the amount processed in each month for each customer
which is the difference between current month and the month prior.

I have an append query which runs when the db is opened based on the
following criteria:
<Now()-90
I'm trying to create an options-like form allowing to users to customise the

It tells me a runtion error "5" and the debugger highlighted the line "If
u="L" then".
Function LitersProcessed(ByVal u As String, ByVal r1 As Double, ByVal r2 As
Double) As Double

I am completely stuck on my issue: I have created a database fo
employee payroll. Time sheet, percentages and all. The issue I a
having is with the timesheets. I have 2 fields per day.. Dayin an
Dayout. I then in a query created 2 other fields per day for hrs. Fo

Hi.  I have a sql statement that brings back the volunteer opportunity
information as well as the associated coordinator.  If a volunteer
opportunity needs a coordinator, I would expected not to see a name for the
coordinator.  However, even if no coordinator is selected for the ...

I have a field called CLASS which holds data according to this format
????-????-???. I would appreciate help on truncating the last three
characters into another field.
Thanks.

I have one query that contains the following fields (among others):
Call #
Employee # (attending call)
The call information appears for each employee that attended; in other words

I have two fields A and B, both double. In a query, I want A\B and give me a
percentage, but it gives me integers which are 0s, 1s and 2s.
Any help is highly appreciated.