I have 12 queries that are designed like these...
qry1
part month amount
a     1        100

I am more of a basic user of Access - no advanced programming experience.  I
have a table similar to the following:
STORE NAME       BLAH         BLAH       BLAH
Best Buy              ......           .....         .....

I have a table of transaction data. In the imported state of the data, there
are may cases where the same transaction is in there in two rows from both
accounts that are transfer to/transfer from halves of the same transaction,
roughly:

The tables that I am developing queries have many fields. I would like to be
able to have the fields show up in alphabetical order when I am designing a
query. Is this possible? Ideally I could toggle back and forth easily.

Is there a query or routine that can be ran against a database table that
would list the gaps in a numbering sequence?  For example, a part master
table containing a field "PartNumber" with part number values ranging between
10000 and 20000.  The user decides what the next part ...

I'm trying to use an IIf statement to calculate the average on the query but
it doesn't seem to work.here's an sql statement for my query:I created a
Union query first and now i wnt to average the values contained in these two
months: July and September

So here's the situation. I have a data entry form used to store data
(obviously). I then have 5-6 queries that are used to sum up the different
categories of the form horizontally. Ex:<BR>
Date   Street 1    Street 2    Street Total<BR>

I have report based on the following query:
SELECT tblCustomer.strCustomerName, [lngAssetCode] & " " &
[strGroupDescription] AS Asset, tblJobs.strJobName, tblInvoices.InvoiceStart,
tblInvoices.InvoiceFinish, tblInvoices.InvoiceDays, tblInvoices.curUsageRate,

Currently I am using Microsoft ME.  Lately, all of my inserted images show up
as code in word, the pictures show up in preview and print out properly, but
I can't see them in any other view.  Any clue on how to change it back to
normal?

I have form where I have a drop down box that lets the user select a
customer.  I'm now trying to write a query where this filed is joined to my
customer table and pulls out the address for that customer.  I have the
tables joined, but it is not seeing the fields as identical.   ...

I have a form with 6 checkboxs.  They are bound to any table or query.
I can click on them and use them however they don't stay after closing the
form.
Is there a code that can be put in the control source properties to make

I have a caculated set of vbcode that I want to run on each record in a
table or query.  Maybe a loop and next record till it ends with the last
record.
Loop

Hi, I got a problem here when i run this query based on the two tables i get
multiple results per Broker ,EffMonth and SUMofTOTAL instead of one.what
could be wrong???
here's a SQL STATEMENT BELOW.

I have a detailed Query with approx 30 plus columns of data and was wanting
a way where the user would be able to select the columns they want to
return.
Is there anyway to do this in form or SQL?

I need to link a parameter field on a html Data Access Page (created in
Access 2002) to a sql Query. Or maybe a filter, but prefer to execute the
filter/query before it looks up the data from the server. In a nutshell, i
want a user to enter a date at the top of the web page to ...