Hello there!

Im currently trying to set up a database to hold customer information and how many "hours" they have left in thier account. With a form that you can sign up new customers and minus / add hours to exsisting customers accounts.

To be hounst im not really sure where to begin, it will probley sound easy to most of you though :( !

I have had previous access expirence whilst doing course work - thats it.


Thank Yooh for reading - please help!!

Even after your spelling corrections I still count at least 9 more spelling/grammar. :eek: ;) Consider using MS Word to at least check your spelling. There's a limit to how many mistakes people will put up with before giving up and moving on to another post.

I assume this is more coursework?

I see it as being similar to a stock control problem i.e. you add and subtract stock of a product to a warehouse. It's worth doing a search in these forums on "stock control" as there are many posts on the subject.

Essentially though, I would consider this as a series of transactions e.g. +60,-15,-15,-15 etc. If you store these transactions in a table then you can sum them for each customer using SQL which will give you the balance of time remaining.

This is just one way of handling this kind of problem.

hth
stopher

Thankyou,
I will look into translating what you mean :P

I Understand most of it :)

The

"can sum them for each customer using SQL which will give you the balance of time remaining." bits where i lost you :P

Thankyou for the reply :D

Suppose you have a table of transactions like this:

CUSTOMER____Hours
Customer1____+20
Customer2____+30
Customer1____-5
Customer1____-10
Customer2____-10

Then you can use an aggregate query in Access to get the sum of hours by customer:

Customer1____+5
Customer2____+20

Thus, summing the transactions by customer gives you a balance of remaining time (consider the first to entries to be opening balances i.e. adding time to their account).

Seach google for "Access aggregate queries"

hope that makes sense
Stopher

Okkay, thats more like my language :P

Thankyooh!

=]

stopher, be nice about grammatical and spelling errors. When it gets bad enough to interfere with clarity, ask for clarification. Heck, every now and then I'll let fly with a spelling faux pas that makes me cringe when I read it a second time.

You might also consider that gaz didn't list a point of origin. For some people, English as a second language is a tough nut to crack.

stopher, be nice about grammatical and spelling errors. Yore absolutly rite and fare poynt particuly as my speeling is prety pore to ;) It took me several attempts to get an O’level in English Language :o.

If I have offended Gaz then I wholeheartedly apologise (that’s "apologize" for those listening in stars ‘n’ stripes ;) ). My intention wasn’t to be critical but to advise that questions will attract more attention and interest from contributors if they are not clouded with errors. I make reference to the excellent document " How to ask questions the smart way" referenced here (http://www.access-programmers.co.uk/forums/showthread.php?t=85042).

When it gets bad enough to interfere with clarity, ask for clarification. Good point. If you check my past posts you’ll see that I frequently try to encourage more from vague questions that would otherwise drop off the bottom of the radar and go unanswered. However, I don’t think understanding of the question was the point here. It’s a bit like writing a curriculum vitae (résumé). One or two spellings can be overlooked. But half a dozen or more and the CV doesn’t get a second look.

Heck, every now and then I'll let fly with a spelling faux pas that makes me cringe when I read it a second time. You and me both :o.

You might also consider that gaz didn't list a point of origin. For some people, English as a second language is a tough nut to crack. Very good point. I maybe wrong here but I’ll wager Gaz has English as a first language. His grammar is good whereas his spelling/typos were “slightly off key”. People who are writing in their non-natural language will struggle with grammar but spell quite well. Of course that’s no excuse for me to make such a brash assumption or to appear to offend people.

My advice to anyone who finds the language a challenge is to, at the very least, run the text through a spell-checker. You’re likely to attract greater interest and therefore subsequent response.

As I say, no offence was intended and I think Gaz took my comments in manner in which they were intended. I appreciate your comments and i take them in the context they were meant. It serves as a reminder to me to be wary of how my comments will be interpreted.

Stopher