Hi the_extinguisher_pro (what is your name?)
Welcome ;)
~~~
to add another field to a table:
1. right-click on the table name in the database window or navigation pane
2. choose "Design" from the shortcut menu
3. choose:
- field name
- data type
- description
- size
- default value
etc
For lessons on planning a database, watch these free video tutorials:
Learn Access on YouTube
http://www.YouTube.com/LearnAccessByCrystal
~~~
> "When I run the query i get the pop-up asking me to enter the City, when I do, the query runs but I get no data, its compleetly blank. What am I doing wrong?"
either you are not typing the name correctly, with any leading or trailing spaces
or
what is being stored is a foreign key to the record in tblCities and the text is only displayed
or ...
to fix it, you need to learn more about Access. In addition to watching the 4 10-minute LearnAccess videos, read this:
Access Basics by Crystal (Bill Mosca's site)
http://thatlldoit.com
Free 100-page book that covers essentials in Access
and pay careful attention to the chapters on Normalization and Relationships.
Warm Regards,
Crystal
*
(: have an awesome day :)
*
--- On Sat, 5/28/11, the_extinguisher_pro wrote:
> I have Access 2007 and i'm fairly new
> at it. I have a business of fire extinguisher service.
> The service is usualy done once a year. i already have
> all my table made in access, but encountered a problem... I
> have a "tblClients" with a related "tblInventory" which has
> all info about each extinguisher the customer has.
> Then there is a "tblService" related to "tblInventory" to
> keep track of each service done to each extinguisher.
> That table "tblService" has a field for the "Now() Date"
> representing the date the service was done, another field
> for the type of service that was made and a third field for
> the interval for the next service (monthly, every 6 months,
> or annualy)... and I need to add another field to indicate
> the date of the next service based on the las service date
> and the interval. Who do I make this happen?
>
>
Tidak ada komentar:
Posting Komentar