I have a table that has a lot of number fields and some yes/no fields.  I am
doing a query to get averages for the number fields and a count for all the
yes fields.  But those fields come up with the right number except they are
negative.  There are 32 records in the database and ...

When I run a select query that links two tables that should result in 83,000
records I get an "Overflow" error message. No other information about the
error is available. If I restrict the result to under 10,000 records with a
parameter query I do not get the error, but I will ...

Is there a way in access to obtains the difference in work days between two
dates, similar to DateDiff only excluding weekends (and holidays)? Excel has
this as NetWorkDays.
I have this column: EDays: DateDiff("d",[timein],[timeout])

I'm new to Access, this is the sample table
IDCODE    NAME
267    MIKE
267           JOHN

I think I know why this is happening but I don't know how to possibly get
around it.  In short, I have a field which holds a value of 1 - 5.  Using a
form with unbound fields, persons search these fields using 1 of 2 buttons in
an option group.  1 represents anyone with a value ...

I am having trouble with an if statement.  My logic steps are
1.  If amount is < 0 (want any negative amounts)
2.  AND type = AC OR type = AT
3. THEN Amount

I attempted to import information from an excel spread sheet to an existing
table that had all of the same type of information - I am receiving the
production information daily, so the dates are different but all of the
fields are the same.

I am getting syntax error for the following update statement
update post set a.edate=b.edate from
post as a, temp as b where a.id=b.id and a.edate='20011231'
I get syntax error after b.edate.

I have a multuser database for salespeople i want to be able to remove the
contact from their list if they do not get them to buy within 60 days.  I
have a date created field, and a sale date field the sales date is a
continious form i need to only take the most recent date.  I also ...

I need to convert minutes to a percent of an hour.  For example, 93 hours and
45 minutes (93.45) needs to be converted to 93 hours and 75% of an hour
(93.75).
Can this be done in one step?

I have created a Union query to give me information from two tables and it
works well, except that the formatting of a numeric field which can refer to
any currency displays the default currency for everything!  In the SQL
statement I formatted the field to display as Standard, ...

I have a "main" table of names with a second table "payments" showing
payments, records are linked by ID field.  in order for users in my office to
use the total payment amount in a form to filter etc... i need real data in
the main table, so hoped to do an update query.  

In response to a very lost soul the following was offered as the best
route to take.......
"A normalized design, if you're interested, is
to have 3 tables.

I have the code below to run a query that matches two text boxes based on
input in one of the two. I'm not throwing any errors here, but I'm not
getting the results I'm expecting. To me, it looks like the query itself
isn't actually executing, but you can't use the QueryDef ...

All,
I need to combine/unite like 50 queries into one table. I am using an SQL
'UNION ALL' way to do it. I am in the middle of it. Thought there must be
some easier ways. Please advice.