Hi need help.
I'm trying to make a querie that returns values in two diferent tables.
Table 1 returns the name of the employee and the time he worked that month.
Table 2 returns the number of vacation days that the employee has used in

I have 2 tables.  tblProject and tblDiaryNote.  tblDiaryNote has 3 relevant
fields - Note, Date, ProjectNo  I want to create a query that lists the most
recent note for each project (ie one record per project).  I have tred to use
a combination of DISTINCT and TOP but cannot get ...

I seem to be having a brain doner Monday and I can't figure out how to make
the query from Joe Foster work!
I entered the first part of the code into a module but then I'm not sure
what to do with the last part.  I tried entering it as an SQL query using my

hi, I want to take three consequetive records in a table and create a
table with three records on one row. All records would connect by one
field.
I can set up a table with all the fields in it but do not know how to

In my Switchboard I have this text field (called Date) in which I do input a
date. Next to Date I have created a command button that when pushed should
run a query. The query should return any operation done the date I input in
Date. If nothing has been done that day then a message ...

I have several queries that sum amounts.  I would like to use the results of
these queries in another query but when one of the queries has no results,
the entire "summary" query shows up as blank.
How do I get the "summary" query to show a zero when the results of the

A simple one, but I'm having a total brain freeze.
I have two tables, tabtapescopy & sheet1.
Both have two fields, TapeID & RDate
I need to run a query to compare the two tables to bring up a list of tapes

I have two tables and in each table there is a primary key. Table A has
property state and Table B has QTM_State and I want a count on another field
that will count the miss matches of both. So for example:
TABLE A                                        TABLE B

Sorry about the last post being empty, i experienced a slight problem.  
Anyways, i have used Duane hookom's concatenate function before, but this
time i am having some problems.  I copied the code for the function from his
website and have used one of his queries as the basis for ...

I am having an issue with a microsoft access query.
I am trying to attempt the following.
I have a table with a field that shows the Date and time in the same
field. Format is as follows

I have used Query dynamic counter function from
http://support.microsoft.com/kb/94397/en-us.
The results is displayed in a list box control in a form with Crew Names and
assigned duties. The indicated number is very important as user can keep a

I have a complex query with multiple rows and columns of criteria that
I am modifying for a new issue for my client. Originally I had a
Network field in the query that set the criteria string as:
In("choice1","choice2","choice3","choice4","choice5", "choice6")

I'm migrating some code from MySQL to ACCess
 I have a character field that I wish to sort numerically (rather  than
alpha numerically), I don't want to change the field type.
  In MySQL I do this:

I have a table with a field called nbr in text format.
When I wrote the query
SELECT nbr
FROM table1

I'm working on an employee training database. Some of the training courses
are required, so I would like to be able to query employees that have not
received the required training. Any ideas?