I would like to insert a column in my query to add column three plus column
four ONLY if column four is greater than .5

Is there a way to Exit an Access Query without being asked "Do I wnat to Save"?
I do not want other users saving changes to my query, i.e. Sort Order,
deleting or adding field names, etc.

I am trying to run a query from a VBA module in the OnOpen
event of my main form.  Basically, if the day of the week is
a Friday,  then the following appears in the OnOpen Event:
If Forms![frmMain]![cboDayofWeek] = 6 Then

I really struggle because I cannot find the reason for the behaviour of my
queries. When I create a normal select query and after that I open this
select query via an append query everything works as usual. However when I
change now my "normal" select query to an union query and ...

I have an Access database which i would like to split into two. The original
database has data from two regions and i need to split the database to
reflect data for the two different regions. Anyone with some ideas will be
highly appreciated.....

I want to convert a SQL-Server based query to work with an Access Database.
This is the SQL-Server query :
Set rstTrace = RST("SELECT SUM(CASE WHEN DEBET<> 0 THEN
abs(round(geboekt,2)) ELSE 0 END) AS subtotDebet, SUM(CASE WHEN DEBET = 0

I am creating a database for my office. All of my tables are in place,
relationships are created, and all sorts of queries and reports can be
created. To me, everything is functional. From reading this forum, I have
decided to use forms instead of the switchboard for my opening ...

I am trying to create a Query on the fly, using variables from a ListBox.  I
did this before and it worked fine; the solution escapes me now.  Below is
the code:
Option Compare Database

Is it possible to have just one criteria and have it apply to a group
of queries?
I am trying to create a report with the separate results of 4 queries
based on a prompt for the user to input (only once) a date. Is this

Dear All,
I hope someone can help me
I have three tables
Contract Details

Hi
I have created two queries and the datas are picked from different tables.
Example are shown below
when i run Query1, below are the answers

Could anyone please assist me with a query that I wish to set up. The
basis of which is to find the nearest value in one table to a specific
value from another table.
In a table named [Source] I have a field named [CT] which contains a

I have a table that has a Start field and an End field both of which are
Date/Time type fields.  I want to compare the records in the table for data
entry errors since it is not possible to have two activities occurring at the
same time.  

I have an append query that takes data from Table1 and Table2 and appends the
data to Table3 for a mailmerge. Table1 and Table2 are joined by field
PatientID - list all records from Table1 and those in Table2 where the joined
fields are equal.

I am using Access 2000. In a query I have a field called docdate. I wish to
display this field's month name in same query as January, February,  and so
on . So I typed the command   Month:Format([docdate],'mmmm').
But when I try tun the query, getting error mesage - undefined ...