I want to sort by the "8027" part of the records. The data connected to the
Datestamp and date can be a string of entries or just one, with the "802*"
record in it.
This is an imported file and the way you see it is the way it comes.

I have a query with several tables.  Two of the tables are called Encounter
and Encounter History.  There are Admit Date fields in each of these tables,
but they are always different.  Each table also has an Address field
(Encounter.Address and EncounterHistory.Address).  What I ...

I have 2 linked tables and have met the 4 criteria in the help menu to make
sure they autofill, but when I enter new data, the other fields don't
autofill. I don't know what info you need from me to help solve the issue.  
The join field in the one side of the relationship ...

I have the below text that is generated by a shipping company and sent to me
in an email. What is the shortest step(s) I can take to get this data into a
database? Way to much effort to cut-n-paste each field. Is there a way to
get a query to read a text file and parse the below? ...

I have found that when i ran a Query using 12 Left Joins, everything went
fine, when I added two more left joins to the same query, there was a
lengthy hesitation in returning the results, does anyone know why?

I have a table that lists "Change Requests" (CR). The table has fields for
'date opened' and 'date closed'. I want to have a query that will show how
many CRs are currntly open in a month for a year. That is, if a CR is opened
in 1/1/2005 and closed in 3/1/2005 it would show up ...

I am running a series of SQL pass-through queries that delete records from
several tables in an Oracle database.  Several of these tables contain 2-5
million records, and Access seems to pause while Oracle processes these
queries.  I would like to initiate these queries, and not ...

Is it possible to use the same parameter for two different columns in a query?
I have a query that asks the user for the First Day Of The Month, and the Last
Day Of The Month, where the First Day Of The Month criteria is used in one
column, and the Last Day of The Month is used in ...

Thanks to the help I received from Duane and Fred I created a Form that
makes a table from a linked table, appends a second linked table to it, then
runs a report. This sequence is started by pressing the Form button.
How can I run the code behind this Form from a Switchboard ...

I have a combo box that is the 3rd item in the tab order of input on my data
entry form.  I also have a command button with coding behind it for the user
to go straight to the combo box for editing.  It has code to make the box
drop down, and works perfectly when the user clicks the ...

Can someone help me out with SQL query syntax? I don’t know how to properly
construct a join when I’m using an aggregate function, in this case Min().
Here is the data:
TABLE vegetables

I'm using a 4 separate parameter queries to make 4 separate reports.  The
queries are identical in what parameters they are promopted for, in fact, the
only difference is that they need to only include 1 of 4 possible groups of
data.

I have a form set up for the user to edit and also input new contract records
I have a drop down list that when the user picks a contractor, the form
displays certain details associated with that record, including a comments
field, viewed in the text box named "txtComments."  I want ...

Is there any way to generate a list of all objects with their dependencies?  
In particular, I am trying to get a list of reports/queries with their
subreports and subqueries.  I am creating a list of reports for my users to
select from, and it would help me narrow it down if I ...

I am a beginner at Access.  This site has been ALOT of help.  I am trying to
create a database to make a 200 question test.  The test are divided into 15
subects and each subject having a different number of questions.  For example
subject 1 has 15 questions, subject 2 has 10 ...