I am wondering if you can run an inner join just using one table. I can
explain why I would want to do this and perhaps there could be a simpler way.
I have four fields in my table (TrackID, ShipID, Date, Status)
I need to query the earliest Date and obtain the ShipID. There will ...

I need help with a query.  I have created a query that asks you to enter a
start date, ie, 06/04/07.  How do I convert that date into a longer date,
Monday, June 4, 2007?

I'm trying to have a datasheet form based on a query in a subform.
The main form contains 3 unbound textboxed that will be used to
search. once they are filled I want to press a button then the query
will execute showing the results if any.

If I have a whole list of items that are, say, 7 characters long and all
start with "ab" (example: abcdefg, abdefgh, abzyxwv), is there a way to run
an update query (or is there any other way) to change the first two
characters "ab" to something else, like "12", so I end up with ...

  I have a table that has a list of departments (tblDept)(15 entries). I
want to count the number of incomplete work orders in the 15 depatrtments in
tblDept from another table tblNewMwo (2500 entries). The tblNewMwo has a
column called Dept and it has entries that are the same as ...

I have a table named "tblAllFiles" that contains a col named "Salesman".  
Every record will have a salesman assigned to it in the tblAllFiles table.  
Then I have another table named "tblStaff" with "Salesman", "Secondary
Salesman" and Primary Salesman" columns.  I need to ...

I have my main table that conatains all the current data.
The other table i created from a query that Data is no longer needed in the
main table.  and need to run a delete query to delete whats in main table
that matches whats in the second table.  

I’m using Access 2003 and I want to create a query that updates fields in a
previously created table.  The first column of the table is EMPLOYEE_ID.  The
remaining 30 columns are actions that an employee can accomplish such as
APPROVED, DENIED, ABANDONED, RFE.  I can create a ...

I'm not even sure if a query is the right way to go about finding my answer,
so I could use some direction.
I have one table with about 10 columns and around 100,000 rows of data.  The
data covers hours worked by employees, what shift, what machine, and what

Hello. I think my brain is not too good. Because I want to make a union
querie and something is not going to well.
I have table1 and table2
In Table1 I have this fields and data:

Hopefully the last time I will have to bug everyone!
Within the BMP database I am working on, I am trying to find a way to
calculate the next inspection date for each BMP, given the previous
inspection date [tblBMP.InspDate] and the inspection period

I have a table with fields containing "Correct", "Incorrect" and "N/A".  I
have created a query to pull any field with a criteria of "Incorrect".  Now I
have a report that generates from that query.  How do I get the report to
only show the field with an "Incorrect" rather than ...

Why is this querie returning me an error (#error):
IIf([NewThickRectas]<Nz(([NewCompactacaoRectasUMin]/1000);[NewThickRectas])
Or
[NewThickRectas]>Nz(([NewCompactacaoRectasUMax]/1000);[NewThickRectas]);"*" &

i have created a query in Access 2003 which pulls info by start and end date
using the between criteria. It works great. Is there a way to have both the
start date and end date field resonses in one dialog box instead of having
them appear in two consecutive boxes?

I have query with columns: Date, Amount, Delinquency (which has 5 catergories)
I was trying to create a calculated field in the same query (or another
query based on this one) which would return me the result of the following
calculations: Amount where the Del = 30 divided by the ...