I have a maketable query that takes a linked Excel file and creates an
identical local table -- no manipulation of any kind going on, just "take
whatever is there in the Excel File and put it into a new table."  Lately it
has been throwing a numeric overflow error occasionally, ...

Goodmorning, i build a query that create a table from record selection.
But when i execute this i obtain warning message "Action or event blocked by
disactivation mode".
In what means could i activate this?

I need to calculate at each record a cumulative base on current record +
previous record.
Not sure how to attack this one?!!!
Daniel

I have table1 with ID1, FlightDate (Date) and table2 with ID2 and FlDt (Text).
I'd like to update Field table1 to table2 using Update Query Like this:
Field          :  ID1                           FDate: Format(FlightDate,
"yyyymmdd")                    

i have a table, each record lists a different car (so far i have listed 24
different cars) i have a field named quantity where i could have different
numbers of different cars if that makes sense.
e.g. 5 of a certain audi car, 2 or a certain bmw so on.

Access 2002
tbl_Main Contains a date field.  There are 100s of records
in this table
tbl_Sub contains a one-to-many link field for tbl_Main, and

hi is it possible to for query to retrieve the data, by passing column name
run time ?
Eg:
Table Sales, having data like below

I have a table, recording different clients' transactions during a month:
Client_ID        Client_Name          Purchase_Amount($)    Purchase_date
101                   AAA                   1000                          
1/Oct/2007

Can you please tell me how can I avoid the duplicate rows in the below qry.;
the second SELECT gives me on row with all the fields and one with clsl1 and
clsl2 balnk??
Thanks a lot,

Hi Guys/Girls
this is my first time actually using Access fully but I would like to know
if i can do one thing, I can import my 2 worksheets Emp1 and Emp2 the problem
I have is I want to display a listing where if 2 queries match from emp1 to

In one field, have a mix decimal and hexa numbers (10,12,17,30A, ..) with
text format. I need to change the format as a  numbers.
I used Cint(field A), working for 10,12,17, but errors for 30A,
Can someone guide me please, what a the correct function/query to use?

Group,
I am using the following query that I would like to only return the last 90
days.  Right now it is returning all 12 months.  but only values for the last
90 days....I need it to remove the null columns.

I have a table with two products (currently) "petrol" & "diesel"
------------------------------------------------------------------------------------
ID    Product_iD    Product    Original_amt    Draw    Outstanding
1    101    Petrol    1200    100    0

I am trying to get the number of hours between date/time groups, ie:
2007-10-26 17:50 to 2007-10-28 07:45 is 37:55.  I found out that if the
total hours is less that 24 then it is correct, but after that I get a
date/time group from the year 1900.  Is there any way to compute ...

Stephen or Allen,
I have been trying to recreate the row numbering query you have in
your example:
http://www.lebans.com/rownumber.htm