All categories - 12 November 2006

I am doing a database for a hotel reservation system on access. I have a table called room category. All of the single rooms are numbers 100-103, all doubles 122-125, all suites 111-113, etc....

I need an IF formula in the room number field which says, if the room type field = single, then room numbers between 100-103, if souble then 122-125, etc......

I assume this IF statement goes in the input mask.

Also, as it is one field, you need to link the IF statements

P.S. I cannot alter the design of the tables.

2006-11-12 00:12:19 · 1 answers · asked by joemoran7 2 in Programming & Design

2006-11-12 00:12:17 · 10 answers · asked by ♫Pavic♫ 7 in Polls & Surveys

I added an Dirk an Archer fish to my outdoor heated pond. He has become a problem. I am finding other fish in the pond skewered by arrows! Also the gnome at the side of the pond has been riddled with arrows. I cannot catch Dirk to get rid of him. any suggestions?

2006-11-12 00:12:15 · 6 answers · asked by Anonymous in Fish

we have
taller buildings but shorter tempers, wider freeways,
but narrower viewpoints. We spent more, but have less,
we buy more, but enjoy less. We have bigger houses and
smaller families, more
conveniences, but less time. We have more degrees but
less sense, more knowledge, but less judgement, more
experts, yet more problems, more medicine, but less
wellness.

We drink too much, smoke too much, spend too
recklessly, laugh too little, drive too fast, get too
angry, stay up too late, get up too tired, read too
little, watch TV too much, and pray too seldom. We
have multiplied our possessions, but reduced our
values. We talk too much, love too seldom, and hate
too often.

We've learned how to make a living, but not a life.
We've added years to life not life to years. We've
been all the way to the moon and back, but have
trouble crossing the street to meet a new neighbour.We
conquered outer space but not inner space. We've
done larger things, but not better things.

We've cleaned up the air, but polluted the soul. We've
conquered the atom, but not our prejudice. We write
more, but learn less. We plan more, but accomplish
less. We've learned to rush, but not to wait. We build
more computers to hold more information, to produce
more copies than ever, but we communicate less and
less.

These are the times of fast foods and slow digestion,
big men and small character, steep profits and shallow
relationships. These are the days of two incomes but
more divorce, fancier houses, but broken homes. These
are days of quick trips, disposable diapers, throwaway
morality, one night stands, overweight bodies, and
pills that do everything from cheer, to quiet, to
kill. It is a time when there is much in the showroom
window and nothing in the stockroom. A time when
technology can bring this letter to you, and a time
when you can choose either to share this insight, or
to just hit delete.

Remember, spend some time with your loved ones,because
they are not going to be around forever.

Remember, say a kind word to someone who looks up to
you in awe, because that little person soon will grow
up and leave your side.

Remember, to give a warm hug to the one next to you,
because that is the only treasure you can give with
your heart and it doesn't cost a cent.

Remember, to say, "I love you" to your partner and
your loved ones, but most of all mean it. A kiss and
an embrace will mend hurt when it comes from
deepinside of you.

Remember to hold hands and cherish the moment for
someday that person will not be there again.

Give time to love, give time to speak, and give time
to share the precious thoughts in your mind.

AND ALWAYS REMEMBER:

Life is not measured by the number of breaths we take,
but by the moments that take our breath away.

2006-11-12 00:12:11 · 11 answers · asked by Anonymous in Religion & Spirituality

2006-11-12 00:12:11 · 19 answers · asked by annacachetona 1 in Languages

2006-11-12 00:11:56 · 6 answers · asked by tim_daugherty1952 1 in Cooking & Recipes

Evey, the larger of the two grabs the other around the throat. Gabriel meows and it sounds like he is crying out in pain. They do this quite often, and it always Gabriel who sounds like he is getting hurt. This is my first set of kittens, so I don't know very much (but I'm getting better). I appreciate all of your answers.
I have only had Gabriel since Monday (but they get along quite well aside from this), could this be Evey asserting herself as the dominant cat in the household? When will it stop, I don't want Gabriel getting hurt.

2006-11-12 00:11:46 · 5 answers · asked by Artemiseos 4 in Cats

2006-11-12 00:11:23 · 10 answers · asked by SYNAPSE 1 in Internet

Stepdaughter went from a dirty blond to black hair color. Now she wants it all blond again. She let a friend put bleach in her hair but they didn't have enough so only part of her hair is bleached out and the other black. She has long thick hair to her b*tt. Is there any way I could correct it for her or should I take her to a salon. I color my own hair all the time but its one color so no big deal. Is there something to take all the color out without damaging her hair?

2006-11-12 00:11:16 · 12 answers · asked by ? 5 in Hair

2006-11-12 00:11:12 · 1 answers · asked by marilou l 1 in Books & Authors

2006-11-12 00:11:05 · 1 answers · asked by Lee-Lee 2 in Other - Health

2006-11-12 00:10:57 · 5 answers · asked by christophercogan 1 in Other - Football

she is very talented - but I'm sure Simon has had her winning on the cards for ages. Does voting on X factor make a difference?

2006-11-12 00:10:50 · 27 answers · asked by Anonymous in Television

You tell me this answer by your criteria.

2006-11-12 00:10:48 · 2 answers · asked by hello india 1 in Other - Society & Culture

yes I have a girl who likes me and I like her but we have never really talke in person... She is in my biology class and I really want out ask her out but I don't know what to say or what to ask or where we would go. I asked her in instant mesager would you like to go out some time and she said sure but I never said anything else. I think she is loosing intrest but I still want to ask her out. so I ask you please tell a 15 year old boy how to talk to a mutual crush and how to ask her out on a date as well a the wording and where to go. Please HELP ME!

2006-11-12 00:10:47 · 9 answers · asked by Anonymous in Singles & Dating

Nubbins (the kitten) is part jungle cat, part manx. The little dear is quite nice, but she keeps ambushing me! How do I teach her that this is naughty?
I'm having trouble typing right now because keeps attacking my feet and the keyboard…
AAAAUUGH! BAD KITTY!
But seriously, how do I teach her?

2006-11-12 00:10:44 · 10 answers · asked by lektio 2 in Cats

Rock Chalk Jayhawak Go KU.

2006-11-12 00:10:42 · 4 answers · asked by Anonymous in Basketball

2006-11-12 00:10:41 · 7 answers · asked by s2_l_i_s_a_s2 1 in Victoria (Melbourne)

2006-11-12 00:10:12 · 5 answers · asked by deen 1 in Marriage & Divorce

2006-11-12 00:09:46 · 2 answers · asked by st_thougth 1 in Investing

i am try to lead to read and i am haveing a hard time becauge i am 28 yead old and i dont know waht to do i try to find thing to help me to read good bet i just cant find entthing

2006-11-12 00:09:38 · 9 answers · asked by tabitha197828 1 in Singles & Dating

i want to get a tatoo of one of them but cant seem to find them.i know on the show they have at least a dz. diff ones.they are sooo cool...thx

by the by ..they are not on cbs.com

2006-11-12 00:09:23 · 2 answers · asked by Robin 4 in Television

Or would you just try to keep going on and try to do things differently with the time that you have left in the here and now?

2006-11-12 00:09:22 · 14 answers · asked by silverpearl 1 in Other - Family & Relationships

Do you like this Iranian pop music?

Imagine! Even if it is hard to imagine
a world where each person is truly fortunate!
Imagine a world where money, race, and power have no place!
a world where riot police is not the answer to the calls for unity!
a world with no nuclear bombs, no artillery, and no bombardments!
a world where no child will leave his legs on land mines!
Everybody free, totally free!
no one in pain, no pain!
You wouldn't read in newspapers that
You won't read in newspapers that whales committed suicide!
Imagine a world with no hatred, no gunpowder,
no cruelty of arrogant, no fear, no coffin!
Imagine a world filled with smile and freedom!
full of flowers and kisses! Filled with up-growing improvements!
Imagine! Even if it is a crime to imagine so!
even if you'd lay down your life on this!
Imagine a world where prison does not exist in reality,
where all wars of the world are included in ‘The Ceasefire Treaty'!!
a world where nobody is ‘The Boss' of the world!
people are all equal!
Then each person will have an equal share in
each single seed of wheat!
No border, no boundaries – motherland would mean the entire world!
imagine you could be the interpretation of this dream!

2006-11-12 00:08:45 · 6 answers · asked by Anonymous in Religion & Spirituality

2006-11-12 00:08:42 · 2 answers · asked by lizard 3 in Cats

Data sets have been obtained of advertised prices published in the current issues of local papers for 2 different towns in your area for a sample of houses for sale.

Mean prices (£'s): A=100,000 B=105,000
Variance of mean price (£ x £'s): A=12,400,000 B=12,500,000
Sample size: A=50 B=50

It is required that a 95% confidence interval has size +/-£1000 assuming the variances remain unchanged, calculate the size of samples required for such a confidence interval. (You can assume sample size of town A and B are of equal size).

Thanks for any help.

2006-11-12 00:08:40 · 1 answers · asked by joemoran7 2 in Mathematics

Do people who have one night stands have more respect for themselves because they do not feel the need to conform to what society believes is morally correct, or do the lack self respect because of the nature of sex without a commitment?

2006-11-12 00:08:34 · 24 answers · asked by Anonymous in Singles & Dating