I have 2 tables: 1 is Main stock code and the other is Main historical
the primary key is stock code.
I create a combo box in a form where the user can select the stock name.
How could i sort the list from the pull down combo box from with asscending

Pls help:
I have 2 tables: 1 is Main Stock. The other is Main Historical.
After creating a query list based on a particular stock name. I could like
to carry out some calculation: IE, 10 days average prices.

I have a split DB with an Access FE and a MS SQL Server BE.  All queries
work fine except when I try to exclude records based on them containing a
certain string.  Assuming "ABC" is the string, I have tried: NOT LIKE "ABC",
<> "ABC" and also NOT IN ("ABC") with the same result, I ...

I've tried to update a field (say, fieldC) with the value = fieldA - fieldB
as follows:
under FieldC in the row of "Update To", I type the following:
[fieldA] - [fieldB]

In an MS Access table I have a one-field primary key, that is an auto-
increment field of type Replication-id. After inserting a single
record using SQL INSERT, I want to obtain the key of the new record. I
have done this before with auto-increment fields of type Numeric and

I am having trouble displaying all duplicate records that meet a certain
criterion. I want them all displayed in the query so I can pick and choose
which ones I want to delete. This is the SQL code that's not doing it; that
is, displaying only the first of the duplicate records:

I have a transfer text routine to transfer the contents of a query to a text
file.  In that file is a field name cost_ctr that has the word "none" in it.
How do I change "none" to spaces for the output file only?  I still want to
keep it in the query for reporting purposes.

I am an Access Neophyte, self-teaching as I set up a client database
for my company.  I am trying to run a query that will return info from
4 expressions; each using a different field.  Expression 2 returns the
expected data.  All the others return "#Error"

I'm trying to use a select query to select matching information on a subform
within a form, and can't seem to get it just right.  An example of my query
is as follows:
(Select [statement date] FROM [correction letters - step 1] Where [statement

I am trying to add an IIF statement to my query criteria. I have a form with
an option group (optRept)with 2 choices: 1. Give me all records where total
sales > [Forms]![frmOrderRept].[txtSlsMin] (this a text box on the form to
enter sales $ criteria) or 2. Give me all records ...

Hello - - I have a query in Access that searches in part a table that
list the 'events' of employees.  These events can be many things, name
change, hire, term etc....
What I'm trying to do is search for data entry errors.  In this case,

Hi,
I have a complex analytical query that is WAY beyond my SQL capabilities and
would appreciate any expert help I can get on this. The table of records I
want to process is large (2.6million records) and will require considerable

I need to query all records that fall between two dates.  I have a column
where I input dates the record was input.  This column is called "DATE INPUT"
and it is a short date format.
The expression criteria listed under "DATE INPUT" is:

I'm trying to automate the running of 8 queries that append to 3 different
existing tables (for example):
qry1, qry2, qry3 appends to tbl1.
qry4, qry5, qry6 appends to tbl2.

Need help with this,
This is a query that I'm using to consolidate other queries that perform the
same calculations, only for different date periods.
SELECT [1stPeriod].FltNumOrgDst, [1stPeriod].ExpLF, [2ndPeriod].ExpLF