I have a table that is giving me big problems....
Its definition is simple:
table name: table1
field1 name: [table1-id]   (autonumber)

I'm having problems running a query with the function FileLen in it using
access 2003.
This has never been a problem in access 97.
I get an error message  - 'undefined function 'FileLen' in expression

Ok,
I'm not that flash with Access but I'm learning. At the moment, I've got a
union query that has all info from say 4 different brokers, all with the
first column as Broker and their name. So say we have ABC, DEF, GHI and XYZ

What is best way to accomplish this -
I start with two Excel spreedsheets which I import into Access tables - Named
DIV - which has many records of persons not in the other TABLE - You can
think of this table as a DIVISION in the ARMY  (Has a field named SOURCE and

What does this error message mean? " ODBC-update on a linked table 'tbl
name' failed.  [Microsoft][ODBC SQL Server Driver][SQL Server]RAISERROR
could not locate entry for error ## in sysmessages."    I am trying to
complete what should be a pretty simple update query.  Any thoughts?

In Acccess 2003: I want to average individually 3 different payments fields
by account, by year in a query in order to create a report based on it.  
During the current year some periods are of course zero-length strings
because they haven't happened yet.  When I try to average ...

I have to create monthly billing invoices for impression counts of print
devices.  To do this I have created a nested query for my reports record
source.  What I have done is create parameter prompts for the user to enter
the billing month start date and billing month end date.  ...

I have two tables that are sorted by date. I would to create a query that
joins both tables in such a way that I get a list of all dates (distinct)
from whatever table. Is there other keyword that INNER, LEFT or RIGHT JOIN?
thanks.

I have two tables one for Fixed Assets called tblFixedAssetRegister and one
for depreciation called tblDeprnTotal. The table called tblDeprnTotal is the
result of a 'Make Table Query' that basically calculates the depreciation for
the period and gives a total for each asset so ...

I am having difficulty editing a crosstab query - and I believe another
question was asked about this - but I'm not sure if it was ever answered.  
When I try to edit an individual cell, I cannot edit the information.  Any
suggestions?

I expect my query to return some #Error results b/c there is division
involved with 0. What I would like to do is create some kind of statement in
the criteria that would say If result "#Error", then result should be "0".
Any help greatly appreciated.

I produced a report from a table that was created using a make table query
to make a copy of a linked table and then an append query to append a second
linked table to the copied table.
How can I force the make table query  and append table query to function in

My child table has many records for each item in the parent table; how would
i go about selecting only the most recent entry? (Note: each record has a
unique date)

Please help.. I need to be able to get a Query reslt and thus a report
(Report I can do if get results)  
What it will accomplish is find people that have been given Temp License
numbers (normally starts with Letters, but also want to find license numbers

I am trying to recode a variable in a query to read:
If Variable is equal to True, give it a 1.  If variable is False, give it a
0.  If variable is -999, give it a -999.  However, I can not get it to work
properly.  I am currently writing it like this: