In a access database query  I want to compare a field in record with
same field in preceding record
Can that be done in access query?
How?

I have table A with promises of payment, Amtpayable , Duedate and CustID.
I have table B with actual payment details, AmtPaid, PaidDate, Cust ID.
Now i am creating a query to show the total AmtPayable as on date, amount
paid, and LastdueDate.  Now i have no problem getting the ...

I want to make a birthday list from my employee table that only shows the day
and month, not the year.  The dates were originally inputted to the table in
dd/mm/yyyy format.
Thanks!

I have a field in a form entitled interest rate, which is set up to be a long
integer, and a percent. When I enter data in this field the data won't stay
and the number just changes back to 0 as soon as I go to enter data in a
different field. What can I do to fix this? I tried ...

I have encrypted a database, but want to show someone that the data is indeed
encrypted. How can I verify that my database has been encrypted using another
program such as Word. I tried using the get external data feature in Excel
but the data appeared just fine and did not look ...

I'm trying to make my clipart smaller in a form in Access 2003, and it just
crops it instead.  Help?

I have a form with a subform that allows a person to enter all the Sold to
Ship To on the top form and the details on the subform.
I would like to create a print button on the form that they can click after
they finish entering the subform information that will print out a P.O. ...

the table I created won't record a calculated field after the 200th record.  
Can anybody tell me how to fix this?

Perhaps I should cut to the chase and ask my question followed by a bit of
background.
Does anyone know if you can use an Access 2000 database with Business
Object’s Dashboard and Data Integrator?

Thanks for the reply Doug.
Would I do this with 3 seperate command buttons?, if not I am unaware
of the code required. If I do use command buttons how does this work
with setting the properties for the form. I mean if I set the from to

Is there a way to add a table to the database using a button and the
On Click event?
In the end, I would like to allow my customer to be able to browse to
a .csv file on the desktop, import it into Access. Finally, on a form,

I have an Append Query  which is appending data to a table. This is done when
I run a Macro.
The problem is, that all fields are getting transfered to the table correct,
except one field. Instead of putting the value (i.e 62.000,00) in that field

I am a beginner of Microsoft Access.
I have some basic questions that figured out bu myself.
Please help me!! Thanks.
- What is a database and when to use

i have installed mcAfee on my pc. i run to computers and i cna no longer file
share due to this progam. can you please tell me how to over come this
thanks

I deleleted duplicate data in two of my combo boxes (in query).  When I
finished, I saved this on my backup.  I went back in and noticed that about
90% of my table was deleted.  
I stopped working on my database onthe hard drive and disc.  Is there any