I am working on a new website using asp with an Access database. I have
a problem with a Memo field when adding/updating - the SQL fails with
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
[Microsoft][ODBC Microsoft Access Driver]Invalid precision value

ok here's the deal i have a query that works with linked tables and resident
tables
basically it's a query that returns money balances from five different
companies within an organization to corresponding names from

In a large memo type field, how can I enter something, like a carriage
return, after every 80th character?
Thanks for any help with this.
denise

I have records which contain, among others, 4 columns:
StrNmbr   StrName    MlgAddr          MlgCity
--------- ---------- ---------------- ----------------
1234      WISTERIA   1234 WISTERIA DR WEST PALM BEACH

I have an update query as below:
UPDATE TimeSheets
Set InvoiceTallyFlag = 'Yes'
From TimeSheets as TS INNER JOIN (ImportedSFUS ON TS.WeekEnding =

Hi All, I am trying to create a counter based on the date and time entered
in a field.  I looked up Dcount ideas in this newsgroup but it isn't
working.  Here's my SQL
SELECT ZipMiles4.ShipperApptDate, ZipMiles4.ShipperApptTime,

I have one half of the result I'm looking for in a calculated field in a
query. Here's the half that works:
Calclo1: IIf([LO1]=True And [Action]="Enable","Y")
What I want to add is the value when Action is "Disable", which is "N". If I

I imported 2 reports from an excel file. One report is for the previous month
and the other from the current. The fields are the same if I am making a
query, but the updated report has new numbers in the total field. I have to
show the differences betwwen last month's totals and ...

I have a date field with proper a criteria statement to give me the dates I
want.  I also need however the time in hours as well.  If I start at 1:00PM
one day, then I want to end at 12:00PM at the end date.  I can get the dates,
but how do I get the hours to match exactly with ...

Good morning,
I am trying to create a formula in my SQL query for my report, and it's not
working.
My formula would be: Diff %: [A]/[B].  Both A & B are the fields in the SQL

I got 9 tables in MS Access 2003 and each table have more then 2000 entries.
My task is find out double records in two columns of 9 tables. for example in
each table column 1 DOB (Date of Birth) has 6 zero(mm.dd.yyyy) and column 2
ID has 5 zero (12345). Now my task is find out ...

I was wondering if there was any other way (other than IIF statement), to
check if the values in 4 specific columns are equal?  If I had 10 columns, an
IIF statement would be very lengthly.
E.g.         A        B

I have a Microsoft Access project stored procedure (created in Sql Server)
which executes successfully, but returns no results.  In SQL Server 2000, it
retunrs data without isusue.  The stored procedure has two parameters (start
and enddate).

Hi guys, I have the following query:
SELECT Quotations.QuotationID, Quotations.Date,
Quotations.Quotation_Customer_Lookup, Quotations.[Your Reference],
Quotations.QuotationBy, Quotation_Details.[Item No],

When trying to open an access database we are receiving this error:
The database 'K:\fspr\apps\database\ledger.mdb' needs to be repaired or
isn't a database file.
I tried running compact and repair database utility but get messages that