I am aware that Microsoft, in their infinate wisdom, has decided to block
the ability to update linked Excel files from within Access 2003.  My
question is, when are they going to fix this issue?  I foolishly installed
Service pack 2 yesterday, in hopes that some amazing had ...

I have a form that has three command buttons. On clicking each command
button a query is run. They are all update queries and must be run in a
specific order as one query is dependent on the other queries running first.
I want to combine all these queries so that they will run in ...

I have a table that has Site, Part, Acutual sales, Normalized sales, Month,
Year layed out in this format.  I'm using the sum function to get my last 12
months of sales. In the query I; group by site and part, sum both sales, and
where month is 11 or 12 where year is 2005 and ...

I have three check boxes in my form.  How to you make it where one is
checked, and other two are not?
I have a field in my form that calculates the days between two dates.  When
I run a query to get the elasped time (days), I find the field in the query

I wonder if someone can halp me please.  I have a query that returns several
hundred rows but i'd like to restict the query to return only the first 30
rows out of the entire list.  I was wondering if there's any way to do this
in SQL.  I'd be very grateful for any help anyone ...

HI ... Can you also help? Im such a newbie in Ms Access and I need desperate
help.
Can you please help me translate below SQL statement into an IIF statement?
Select

When I create a hyperlink to a PDF File in a MS Access 97 table and click
onto the hyperling, the PDF File opens briefly then disappears, how can I
create this hyperling properly.

I have a user who wants to keep track of an account balance in
Access...similar to a check register.  She wants to enter amounts and have
them add/subtract from her account balance.  I was able to create a running
balance using DSum in query but you can't add or edit the data ...

I have a query with a field that is set to Standard and 2 decimal places in
the properties.  When you click on some records in that field, it shows
several digits past the decimal as opposed to just two.
I need the field to contain only the value of the two decimal places.

In a .mdb with related tables, related via ODBC to a SQL 2K server, I am
creating some havely joined queries. All INNER JOINS, which functions OK
and without any noticable delay.
Accept when I design a query with more than 4 INNER JOINS, then the

This should be simple..
I want to append information from one table to the other.  Both tables are
identical.  Every time I get to run the query, I get an error that says,
"Invalid Argument."  Anyone have any idea what it is means?

i have done a little research in to how to find the max of something that is
related to another table. i have a compressor table that has a running hours
table related to it. i need to find the max running hours
Compressor

I am trying to create a query which autocalcs pay for services.  SQL is
shown below. The problem area is the AS line and I've added the returns
for ease of reading.
[tbl_Carrier.Type] refers to a lookup field that may be showing text

I am trying to do a Ranking of Sales totals. I am not sure why the below is
not working. Can you rank based on a query that runs a grouping?
Thanks
Matt

As the subject says, I am trying to get a query to return anything prior to a
date that is input or if no date is input, I would like it to return those
dates that are prior to now().  I have this working for a combo box on the
form with the following