Hi
I'm an inexperienced Access user who has to update a database regularly (to show which books have been sold). It would be much easier if I had a procedure where I entered a Number (the number of the record, generated automatically) and the record then was updated in the "Sold" field.
How do I start?
Pretty basic i know: I'm lazy i guess, and thought someone here could say this is where you look.
Too much red wine perhaps.

Do you already have the book details stored in your database?

If you do, do you also record the number of books in stock?

And if so , is that in a field in the same database?

As for the red wine, I sometimes post an answer here, after the consumption of several largers and when I view the answer when I'm sober I think "oh dear"

Maybe we should have a smiley which indicates how drunk you are.

..................................

Hi
Now its morning and I'm feeling less than smiley: :(
My database has fields for author etc.
It autogenerates the Book Number which I record when a sale is made.
I'd like to be able to type out the number & update a field which records whether the book is sold or not, changing from "N" to "W" or "E".
Ideally therefore: an entry box for the number, then press return, then record updated.
Any suggestions?
James
:eek:

Maybe we should have a smiley which indicates how drunk you are.
http://www.abestweb.com/smilies/alcoholic.gif

>>>>>a field which records whether the book is sold or not<<<<<

So you only ever have one copy of one book to sell, not 100 copies of a particular title?

Yes: I deal in second hand books, so each record is unique and if I get a 2copies of the book I produce separate records, as each has to be described separately.
If I sell book 2030, then I want to update just that record.

Who is Annabelle?