A special DB

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Hello,
I am relatively new to Access and have found this to be
the most difficult Office Program there is. As of this
moment I am quietly frustrated.

I need to find out how to create two types of DB's I have
yet to find.(1) I need to be able to make an order and
have the order be calculated to remove it from an
inventory DB I guess they would be the same DB - Say... 30
items and then making an order of 10 would then set the
inventory to 20 etc...

(2) I need to make a time sheet DB of hours worked and to
be billed with elapsed time counter.e.g. I punch in and
start to work when I punch out time worked calculated and
a report can be generated.Is there anywhere I can go to
learn or get this done?

Thank you,
Joe
www.ImmoralBalance.com
Worth the trip!
 
1) Suggest that one way to do this would be to maintain a running table of
beginning balance plus inventory transactions, then sum the table for each
item, returning the ending balance. Your records would be +30 and -10
which, when summed, equals 20. Don't delete transaction records. Continue
to add records to make transactions and adjustments to on-hand counts.

2) Assuming that you're turning your $500+ computer into a ten cent time
card, you could use a coding system for events "IN" and "OUT". In the table
where the transactions are logged set the default to =now() which will enter
a date/time stamp with each record. Set up a query or report to calculate
elapsed time.

In both cases SQL databases generally do not store calculated results into
tables.
 
Joe,

I am in business to provide customers with a resource for help with Acceee,
Excel and Word applications. I offer the kind of help you are looking for.
Cobtact me at the email address below.
 
I've seen PC Datasheet offer his services so many times.
Always wondered if he got any work out of it.


Chris
 
Note the end of the last sentence of the poster ---

<<Is there anywhere I can go to learn or get this done?>>

The vast majority of posts to cdma are from users looking for help!

Steve
PC Datasheet

BTW, I am a frequent contributor to cdma and two other newsgroups, are you?
 
I am a frequent contributor to cdma providing whatever help I can. The vast
majority of posters on cdma post here looking for help. Yes, my sig line does
advertise my services because there are many users out there like the poster
here looking for these services. Look at the end of the last sentence in his
post, "Is there anywhere I can go to learn or get this done?" My answer to his
post is, "Yes, contact me".

Steve
PC Datasheet
 
I am a frequent contributor to cdma providing whatever help I can. The vast
majority of posters on cdma post here looking for help. Yes, my sig line does
advertise my services because there are many users out there like the poster
here looking for these services. Look at the end of the last sentence in his
post, "Is there anywhere I can go to learn or get this done?" My answer to his
post is, "Yes, contact me".
Click to expand...

On the other foot, quite a few of the other volunteers on the
newsgroup (myself among them) use the newsgroups primarily or
exclusively to provide free support, rather than to advertise our
services for pay. I've gotten contracts as a result of discussions
here, but I would consider it inappropriate to advertise here (beyond
a line in my .sig perhaps); and still more inappropriate to reply to a
request for help with an offer of paid consulting without any answer
to the question.
 
Back
Top