F
FRANCISCO
De: <[email protected]>
Asunto: Re: Access Database & preset report/form
Fecha: viernes, 13 de junio de 2008 17:44
There isn't a "rented units" table. The units table just makes a new
entry for each time the unit gets rented. In order to see the
currently rented unit, I have to do a search for units that have a
move in date but don't have a move out date. This is a premade access
database that we have actually purchased just a front end to - we
don't actually do anything with access, just through the front end
application. I have worked with access before ( a long while ago) and
have done a few queries for particular reports we need and didn't come
with the application. But I am limited in what I can do with the
database. For instance, I can't add tables, and I can't change the
structure of the tables. I hope that gives you a little more
information. Thanks for working through this with me, by the way.
Asunto: Re: Access Database & preset report/form
Fecha: viernes, 13 de junio de 2008 17:44
There isn't a "rented units" table. The units table just makes a new
entry for each time the unit gets rented. In order to see the
currently rented unit, I have to do a search for units that have a
move in date but don't have a move out date. This is a premade access
database that we have actually purchased just a front end to - we
don't actually do anything with access, just through the front end
application. I have worked with access before ( a long while ago) and
have done a few queries for particular reports we need and didn't come
with the application. But I am limited in what I can do with the
database. For instance, I can't add tables, and I can't change the
structure of the tables. I hope that gives you a little more
information. Thanks for working through this with me, by the way.