Insert into table -- Need help

[giahan]

Hi,
I am a new access user. I have to update a table daily. Here is my description:
mytable has fields(Today, item, rentDate, returnDate, rentedBy)

item in the table is not static, it can be varied daily (I have to insert or delete item depending on if available)

Here is example how mytable works

Today item rentDate returnDate rentedBy
9/22/00 item1 9/22/00 9/23/00 abc
9/22/00 item2

9/23/00 item3 (item3 inserted by me manually)
9/23/00 item2 (item2 inserted automatically b/c no one rented it on 9/22/00)

9/24/00 item1
9/24/00 item2
9/24/00 item3

*note: the content in () just for explanation, not in the table physically.

Does anyone have any idea that what I need to do?
I really appreciate.
GH


[sig][/sig]

 

[giahan]

I solved my problem [sig]<p>GH ((-:<br><a href=mailto:giahan@hotmail.com>giahan@hotmail.com</a><br>(-:[/sig]

 

[MikeLacey]

Ok <grin> tell us how you did it then! LOL [sig]<p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>Making mistakes, so you don't have to. &lt;grin&gt;[/sig]