nikki grefe
2007-12-12 06:10:02 UTC
hello all
I am new to all of this blogging and www sites beyond porn of course! just
kidding, as well as a very good database for quick information and
reasearch. I am grateful to all of you for your comments. You are all very
generious! I am the village idiot in this arena, I am having an impossible
time getting people to view my jewelry website! I don't know how to get
more people to enter. If anyone has any ideas about how I could go about
making it better, as well as garnering more traffic.!!!
Nicole Grefe
elizabethgrefegemstones.com
I am new to all of this blogging and www sites beyond porn of course! just
kidding, as well as a very good database for quick information and
reasearch. I am grateful to all of you for your comments. You are all very
generious! I am the village idiot in this arena, I am having an impossible
time getting people to view my jewelry website! I don't know how to get
more people to enter. If anyone has any ideas about how I could go about
making it better, as well as garnering more traffic.!!!
Nicole Grefe
elizabethgrefegemstones.com
I have hit a wall...
I have a fairly basic, yet confusing database that is used to track lesson
bookings, and staff availability.
Staff availability is recorded by saving all contact info to one table,
and
then all linked daily availabilty into 7 related tables (Monday - sunday)
I have a query that searches all of this availabilty and allows me to post
a
report that is nicley colour coded to show when staff are "Available" and
"Not Available" at each hour of the day. I have a different report for
each
day of the week. Due to the size of my staff, I would like to EXCLUDE
people
from these reports if they do not have any "Available" hours on that day.
Within the Query, I have the feilds [Stafffirst], [Stafflast] (names)...
and
then the hours of [8:00am] through [8:00pm].
On an initial attempt I just put the criteria <>"Not Available" under 8:00
am... which worked great at exluding anyone who was not available at 8:00
am... but it also excluded staff who happened to be available later in the
day... but were simply not scheduled at 8:00....
Does my dilema make any sense to anyone out there?
I guess Im looking for an expression that would only exclude staff names
that did not have ANY "Available" hours on a given day.
Thoughts?
thanks in advance.
I have a fairly basic, yet confusing database that is used to track lesson
bookings, and staff availability.
Staff availability is recorded by saving all contact info to one table,
and
then all linked daily availabilty into 7 related tables (Monday - sunday)
I have a query that searches all of this availabilty and allows me to post
a
report that is nicley colour coded to show when staff are "Available" and
"Not Available" at each hour of the day. I have a different report for
each
day of the week. Due to the size of my staff, I would like to EXCLUDE
people
from these reports if they do not have any "Available" hours on that day.
Within the Query, I have the feilds [Stafffirst], [Stafflast] (names)...
and
then the hours of [8:00am] through [8:00pm].
On an initial attempt I just put the criteria <>"Not Available" under 8:00
am... which worked great at exluding anyone who was not available at 8:00
am... but it also excluded staff who happened to be available later in the
day... but were simply not scheduled at 8:00....
Does my dilema make any sense to anyone out there?
I guess Im looking for an expression that would only exclude staff names
that did not have ANY "Available" hours on a given day.
Thoughts?
thanks in advance.