Using Microsoft Outlook 2007, how to set up a common calendar for everyone in the company?
1. I have my own calendar shared but need few more common calendars, for example, "Meeting Calendar", "Staff on leave Calendar" and "Car Booking" to share among all the staffs in company. Everybody should be able to view, edit and save into these calendars.
2. Can I create few more calendars for myself?...
HowHow
Last Activity: Aug 12 '09, 03:54 AM
Joined: Sep 14 '07
Location: Australia
-
Common Calendar in Outlook 2007
-
Hi Emil,
I cannot redesign the table because I am using Access to connect to our main system thru ODBC, thus all the tables are from the main system and the tables are only linked to my Access for reports. Mainly because main system only have standard reports and cannot produce what my managers required.
Any idea about the code or method to sort the address? -
HowHow started a topic Access 2000, how to sort addresses by street and suburb that exclude numbers?in AccessAccess 2000, how to sort addresses by street and suburb that exclude numbers?
Using Access 2000. I need to group the address by suburb then by street name in my report.
Two major problems here:
1. Unit number has the word "Unit" before number
2. Semi detach house has "a" or "b" after number
Examples of the addresses as below. Address 1 means the first line/field for users to key address in line one, Address 2 means second line/field two for users to... -
Thanks for the link. Appreciate it.Leave a comment:
-
Thanks for your info. Do I need to install anything in order to use Crystal? Like I need MS office professional so that I can use Access in it. How about Crystal? Does it comes with Microsoft or do I need to install and pay licence seperately?
Secondly, our database system is created in SQL. When I have Crystal in my computer, I can just link the table like how I did with Access? With Access, I can link the table using ODBC. How about...Leave a comment:
-
What is Crystal Report?
My boss asked me to find out "Crystal Report" and then use it to create report as our own database system doesn't produce all the reports that we needed. I have no idea what is it about. Can anybody be kind enough to show me some good link to look into? Currently I am using Access 2000 to link the tables thru ODBC to our system. Is Crystal Report easier to learn and more user friendly? Many thanks. -
Thanks for the link, I've got it:
Consider L is Rostered Time and K is Actual Work.
Case 1:
Paying rostered time if actual work is within 5 minutes under roster.
Paying actual working time if actual work is more than 5 minutes under roster. Paying up to rostered time if actual work is more than roster:
Case 2:Code:=IF($K2-$L2>=0,$L2,IF($L2-$K2<=0.08,$L2,$K2))
Paying...Leave a comment:
-
Excel 2000, IF function with multiple condition
I am using Excel 2000 to calculate the pay for worker and there are 4 possibility:
1.If actual work time is within 5 minutes under rostered time, pay rostered time
2.If actual work time is 5 minutes more under rostered time, pay actual work time
3.If actual work time is within 5 minutes over rostered time, pay actual work time
4.If actual work time is 5 minutes more than rostered time, pay rostered time plus 5 minutes.... -
Thank You!!! yes, I can use nest, got it.
First I only add one colume with the formula:
and so on, where 7 means July to me, 8 means Aug to me, 9 means September to me....etc for a financial year.Code:=IF(AND(C2=39630,D2=1),7,"") & IF(AND(C2=39661,D2=1),8,"") & IF(AND(C2=39692,D2=1),9,"")
Then I have it in another colume with the month from Jul-08 to Jun-09, in colume...Leave a comment:
-
I will just try to enter the data here so that you have a clearer idea of what I need:
[HTML]
Fruit Date Negative
Apple Jul-08
Kiwi Jul-08
Orange 1
Apple Jan-08
Kiwi Jul-08 1
Apple
Kiwi
Banana Aug-08 1
Grape Aug-08 1
[/HTML]
Using these info, I know that in Jul, I have 1 negative, in Aug I have 2 negative...at the end, I can provide a record...Leave a comment:
-
I need to count the negative one for each month (of course because some of the negatives don't have a month), so if I add colume, it would mean adding 12 columes...is there a better way?Leave a comment:
-
Now it drives me crazy, I kept trying and it keeps giving error message.
I think I am confused with the cond1 and cond2, whether I can put a range in it as well...etc etc...
By using the example (table above), Orange has 1 in Negative colume and Kiwi, date Jul-08 has 1 in negative colume too. if I need to count how many of them are negative in Jul-08, what formula you would suggest to be? (sorry, I try to copy and paste the table...Leave a comment:
-
I changed the cell to general and it shows me 39630 instead of Jul-08, so I tested on it with the formula, =if(C2="39630", 1,2) but it still gives me 2 instead of 1.
Actually I have another colume named "Negative" and some with number "1" in it. I need to calculate if the "Negative" colume has 1 and if it shows specific date.
I would imagine it is like =countif (D2:D200 = "1")...Leave a comment:
-
It still didn't work. Actually I try to test on IF function again and found even the single formular didn't work
Some of the dates in colume C are Jul-08, but the return values are all 2. Is that mean IF function cannot recognise date?Code:=IF(C2="Jul-08",1,2)
Leave a comment:
-
I tried but I still don't get it. Can you please suggest formular to me please?Leave a comment:
-
How to Count IF something AND something in Excel
Using Excel 2000, I need to count only if both of the criteria are met. Just for example, I have a list of fruits with price and dates beside it.
If I want to COUNT only when the price is more than $5 AND the date are blank.
[HTML]
Fruit Price Date
Apple $3 Jul-08
Kiwi $6 Jun-08
Orange $8
Apple $6 Jan-08
Kiwi $2 Jul-08
Apple $7
Kiwi $4
[/HTML]... -
I see...thank you for your time :)Leave a comment:
-
Can query return result in vertically instead of horizontally?
Using Access 2000, normally query returns result horizontally. Is there any way to set the query to return result vertically?
For example, my query shown the result as below:
[HTML]
Heading below 70 70-74 75-79 80-84 85 and above
Value returned 128 54 137 190 294[/HTML]
Is there any way to show the result... -
Hi Stewart,
Thank you for the answeres and tips.Leave a comment:
-
Hi,
Thanks...I was using "#" to represent numbers without explaining in the previous post..sorry for the confusion....fe w more questions though...
1. When I use clng, the numbers behind decimal is gone. For example, 1.5 become 2...etc. If I am not using clng, some of the figures has lots of numbers behind the decimal. What should I do if I only need two decimal only?
2.
a.Total column...Leave a comment:
No activity results to display
Leave a comment: