I am having a problem with a full join, I have been using the following
example:
SELECT d.* ,a.salary
FROM tbldetails d FULL JOIN tblAccounts a

I have a table with tasks assigned to employees. Two employees are
assigned to one task. I want to write a Query that when run gives them
a drop down type of box with  the employee names and when they click on
the name it will show all the tasks assigned to them.

I am trying to build an expression in a query that will filter specifi
numbers when the value is entered. I would like the value box to rea
something like "Please enter the file number" and when entered, se
example of file # in brackets (001-200-001), it will show those record

Access 2002
-Advisory-
First, I have very limited knowledge of Access but I need to get a temporary
database in to replace the massive paper mess that goes on in this

I have my query showing duplicate records using the Electronic # and customer
# fields.  I want it to just show the duplicate records if the customer has
bought the same electronic item within 60 days.  I have a Date Entered field
using the Date() code and was trying to use field ...

Is there a length max on the field in a query?
I have the following expression in a query. The text string being evaluated
by the InStr function is 141 characters long.  It consists of all the items
selected by the user from a combo box.  It works fine for me --I'm running

I have a 2000 database, I'm using Access 2003 for development, customer is
using 2000.
On a form, user chooses items from a list then clicks the select button.  I
read the list box and make a text string that includes all the values.  In my

I'm having a tough time with a key violation error.  
Background:  I'm taking data from a table, that has about 6000 records, and
trying to append it to another table.  The primary key in the destination
table is a autonumber that I am not importing into the table (it assigns

I'm beginning to worry that I might be overstaying me welcome in the
newsgroup at the moment. I've posted a few questions in the last days (all
with successful replies) and I'm worried of giving the impression I'm just
using the newsgroup to build my project for me ..... I hope ...

Hi,
I want to be able to access different tables but all the tables have the
same fields and I want to view the unique fields in this new query.
thanks

Is there a way to limit query results? Via form? TIA
-JS

I am using MS Access as a front end to SQL Server database tables.
In one of my tables i've got two columns formated as DateTime with the date
and time in each of them. Each time i query them for a certain date range i
get the correct months and days but all of the years instead ...

Sorry to post so soon with another question, but I'm getting desperate!  lol.
In the same adp I mentioned earlier, I am trying to recreate a query used by
a former developer (without benefit of documentation) that counts instances
of production runs per date.  What I wound up with ...

I need help with a date formula i have. I have three field one call Admin
Review which had the dates the review was done, then i have next admin
review, which depends on the Amount of days given to review the case. What i
need is that when i type in the number of days given it ...

I have a table of work orders that has a primary key on OrderNumber.  About
8:00 to 10:00 every morning we download new work orders from the mainframe
(using a text report that is parsed via a query).  The mainframe report lists
all orders created anytime yesterday or today ...