I've coded a form which calculates and populates a text box on a form.  To
be clear, data entered into the Textbox is not done manually it is calculated
on the AfterUpdate event on other fields in the form.
I have another command button on the same form which then loads a query, ...

Simple question.. I think
My query is showing the same name 2 times I want to only see the name one time
Example
Staff members Vacation Pay

I'm trying to put together a query that will find records between two dates.
The two dates are entered via a form and, if cleared, should return all
records.
So far I have (using previous posts as I'm a total novice) got:-

first off, i'm using A2K....
i want to create an update query that will let my users modify records in a
table because when they have to scroll through their usual data entry form it
takes too long to get to the record they need modify and i think a query

A very simple database, main table and a table that will store posible
choices (2) for one of the fields in the Main (combo - look up column,
possible choices here are EXIT and ENTRY). What I want a query to do is show
me only entries from the Main table that have both EXIT and ...

I have a table [meeting items], which contains agenda items for meetings of
a certain 'type'. A yes/no field 'current' denotes which items are still to
be included in forthcoming meetings.
I also have a table [meeting schedule], which is a list of meeting dates for

Is there a way in a query to have an if statement that will allow me to
do one section of code versus the other based on some value. Something
like below
if (value = true)

I am trying to run a query that will return me email addresses based on
hobby.  Then i want it to take all the cooresponding email addresses
and put them in the "to:" field of outlook.  It can leave the rest of
the email blank.  I have NO idea how to do this or even get started.

I also posted this to Queries by accident::
This piece of code in my module records the date someone deletes a record by
writting it to a table.. Could you please help me add the time to this format.
lCriteria = lCriteria & "#" & Format$(Date, "mm/dd/yyyy") & "# AS tDate "

I'm using a form & VBA to get information from a query.  It works but now I
want to store the information in the fields of the query to some VBA
variables.  My thinking was that I have a field in the query named 'project'.
In the VBA code I dim a variable named 'projectname', in ...

I have the following code in a query field which takes the content of field
Function, which contains, say,  Maths Mentor, English Mentor etc and produces
a new field containing just Maths, English etc. The problem is that when the
field Function does not contain anything, ...

Hi, I know this query is very difficult if you have not the
relationship beetween all the table.
But I need to filter this table to obtain only one record choosen as
the minimum of "DIFF" field

Any help would really be appreciated on this:
I have a Query  where I have made a union query to consolidate my data:
The query is as follows:
Query Name = "2 Summary"

I have been writing a simple query in Access 2003 to count records with a
calculated value greater than a threshhold. I entered a few different values
for the threshold into the query and tabulated the values. Getting bored with
this I decided to use a table with the different ...

I've got a database that stored the values of the concentration of different
chemical compounds within a sample in one table (~ 50 different chemicals),
eg:
Sample....Chemical 1...chemical 2............chemical 50