I have a bunch of companies whose financials I upload into access from excel.
Each quarter of financials has up to 20000 lines. Currently I uses one table
that I import to, run a query to extract the 1000 or so lines I use and then
export that to an excel spreadsheet. I want to ...

My database looks like this:
Message             MessageTime    Identifier    MessageType
BOX00AIQ0D17    92931    9595959    Receive
BOX00A3S0AU8    92931    4637727    Send

Ive been trying to build an expression that removes the decimals (".") out of
my fields and replaces them with two spaces.  I came up with something like
this....
Mid([findDOT]![LOT],1,InStr(1,".","  ",1)-1)

I have a table in an Access database that I want to update from a linked text
file.   The common field is Account which I link in the query and I want to
take information from the linked text file (a very large file I don't want to
import) and update a field in the internal table ...

I'm trying to run a query, but getting this error:
"Not enough space on temporary disk."
I don't understand why.  I have 5+ gigs on my C: drive, and 18+ gigs on my D:
drive.  I've looked this up in help, and found that this refers to my "TEMP"

when records are deleted by a delete query are they logically deleted or
physically.
is it possible to undelete them?

I need to run a query that updates a portion of the information in a record.
This would be like a the find/replace feature. Only i want to automate it
for several different conditions. Like Company to Co, Inc. to Inc
For Example the query would change ABC Incorporated to ABC Inc

OK this is what I need to do.
I have to print out a number of labels for records in a database.  Some of
these records need 3 labels printed, some need twelve.  Is there someway to
automate this so I can use a merge and tell the printer how many labels to

What's wrong with this? It gives me: "Too few parameters. Expected 1."
and the debugger points to the currentDB.Execute(query)
-- snip --
CodeBox.SetFocus

Morning all,
In a query, I am creating a field with an expression.  Here is what I have:
Current Variance:
IIf(Month([FiscalMonth])=1,[BudgetJan]-[ActualJan],(IIf(Month([FiscalMonth])=2,[BudgetFeb]-[ActualFeb],(IIf(Month([FiscalMonth])=3,[BudgetMar]-[ActualMar] ...

I have a query in which three dates have to be entered. Field names are:
[Datum klantverzending]
[Datum ontvangst]
[Datum afhandeling]

I have a query from which an invoice is printed. How do I eliminate
blank address lines?
For example if I have address_line1, address_line2,
address_line3,address_line4, post/zip code and there is data only in

I need some help trying to figure out how to do something.  In table rows
when the data has the same NHA and PART, the ITEM_NO should be equal.(see
sample data)  I am trying to figure out how to write such a query where I can
bring back results of the NHA, Part and Item_no if the ...

I have a table in which each record has a date associated with it. I need to
extract the record that has a date closest to a date entered on a form.
Specifically, it needs to be the record that is the highest in the table but
lower than or equal to the date on the form e.g. if ...

I don't know if this is a bug, but i have encountered this before. Can some
one at microsoft fix this!
When designing a query , and in the SQL window
if you have a select , you enter in the SQL window with a where clause YOU