ms access
i would like to increase my ms access knowledge. can somebody help me? from time to time, i get stuck and i want to be able to ask a person troubleshoot where i get stuck, if anyone would like to do that for free, please reply to this e-mail.
i live very far from doha, or to be exact, i'm in ras laffan, so, e-mail is the best form of communication with me. though we can use other chat systems if necessary.
right now, i'm working with the yes/no data type and boolean. i want to know the difference between the two.
i'm making a database of timesheet of surveyors.
each surveyor comes with asst. surveyor.
now i have to sum up the number of surveyor and asst. surveyor for any given time.
how do i do that?
the difference between the two gives the number of absent asst. surveyor. that will deduct to the total billable amount.
any idea guys? do i try to get all these done in a query or form?
my query is already designed to pick up the parameter dates. then from their, i want it to count the number of surveyors. how do i do that?
thanks guys for your help.
Any one Needs MS Access Customized Programs for personal/Co. use. (Less than QR1000 depending upon the database). Contact me on [email protected]
i dont think this is a complicated situation. Two queries and a table will do the calculation for you. have you prepared a database and if you are stuck with it send it over by mail to me and i will correct you and and resend it.
[email protected]
cheers
...The Oracle...
I am not an expert, more an enthusastic amateur and wrestled with the same issues early on but very basically:
Tables are for storing base data
Query's are for extracting, filtering and when necessary manipulating (eg calculations) data from those tables
Forms are for looking at stuff on screen in tables or queries and should also be used for data input - its not good practice to let users enter data directly into tables. Data can oly be entered into Tables, not into queries
Reports are for getting info from tables or queries in logical, well laid out printable form.
For this issue, use New Query, Simple Query Wizard and in the Summary Options, choose Count for those fields you want counted
Hope this helps
Another site I use a lot is Woodys Lounge - part of WOPR. Has enormously knowledgeable and helpful people (especially the resident genius Hans). They have helped me tremendously over the years, are not patronising and its free
Pop
you.. i think.. PM me....
If someone here wants to volunteer please be my guest.
Otherwise your best bet is to join one of these fora:
http://www.utteraccess.com/
http://www.access-programmers.co.uk/forums/
http://forums.aspfree.com/microsoft-access-help-18/