I'll give this a shot...thanks!
Dave
-----Original Message-----
From: ms_access@yahoogroups.com on behalf of John Ruff
Sent: Sat 10/29/2005 4:47 PM
To: ms_access@yahoogroups.com
Cc:
Subject: **SPAM** RE: [ms_access] Airline Schedules dbase
You can create a function such as this:
Public Function getDayOfWeek(datFlightDate) As String
Dim strAbbr As String
Select Case Weekday(datFlightDate)
Case vbSaturday
strAbbr = "SA"
Case vbSunday
strAbbr = "SU"
Case Else
strAbbr = "W"
End Select
DayOfWeek = strAbbr
End Functio
John V. Ruff - The Eternal Optimist :-)
"Commit to the Lord whatever you do,
and your plans will succeed." Proverbs 16:3
_____
From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dave Moreau
Sent: Saturday, October 29, 2005 9:59 AM
To: ms_access@yahoogroups.com
Subject: [ms_access] Airline Schedules dbase
Airline Schedules Dbase:
I am working on putting together an airline schedule dbase for our
airport.
One of the requirements is that I differentiate between a weekday
schedule,
a Saturday schedule, and a Sunday schedule.
How can I take a date that is input in the record as ....
Ops_Date
11/02/05
and convert it to a character as follows
SA for Saturday
SU for Sunday
W for weekday
in a separate field associated with the record. Then I will be able to
sort
records according to whether they are Saturday, Sunday, or Weekdays.
Also,
if I do not have an Ops_Date recorded can I would like to manually
input S,
SU, or SA in that same record.
Of course, if you know of such a dbase already, please let me know that
as
well.
Thanks!
Dave Moreau
This e-mail and any attachments may be confidential or legally
privileged.
If you receive this message in error or are not the intended recipient,
you
should destroy the e-mail message and any attachments or copies, and
you are
prohibited from retaining, distributing, disclosing or using any
information
contained herein. Please inform us of the erroneous delivery by return
e-mail. Thank you for your cooperation.
[Non-text portions of this message have been removed]
SPONSORED LINKS
Microsoft
<http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Microsoft+
access+database&w2=Database+development+software&w3=Database+management+soft
ware&w4=Database+software&w5=Inventory+database+software&w6=Membership+datab
ase+software&c=6&s=190&.sig=hc7Za8QzEj1t7F8GW0yzhA> access database
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+development+software&w1=Micros
oft+access+database&w2=Database+development+software&w3=Database+management+
software&w4=Database+software&w5=Inventory+database+software&w6=Membership+d
atabase+software&c=6&s=190&.sig=i5H8GCn7HzmglwpvhJg19w> development
software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Microso
ft+access+database&w2=Database+development+software&w3=Database+management+s
oftware&w4=Database+software&w5=Inventory+database+software&w6=Membership+da
tabase+software&c=6&s=190&.sig=kzlRmjQuUTEFLTjkEd6-kg> management
software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+software&w1=Microsoft+access+d
atabase&w2=Database+development+software&w3=Database+management+software&w4=
Database+software&w5=Inventory+database+software&w6=Membership+database+soft
ware&c=6&s=190&.sig=CoCmr_EubT5Xd83NiQjcpg> software
Inventory
<http://groups.yahoo.com/gads?t=ms&k=Inventory+database+software&w1=Microsof
t+access+database&w2=Database+development+software&w3=Database+management+so
ftware&w4=Database+software&w5=Inventory+database+software&w6=Membership+dat
abase+software&c=6&s=190&.sig=DHnS8Uu1ImyGVg1J4k0BMw> database
software
Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Microso
ft+access+database&w2=Database+development+software&w3=Database+management+s
oftware&w4=Database+software&w5=Inventory+database+software&w6=Membership+da
tabase+software&c=6&s=190&.sig=uEGHlFpqbscHu8mCHe7tzg> database
software
_____
YAHOO! GROUPS LINKS
* Visit your group "ms_access
<http://groups.yahoo.com/group/ms_access> " on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.
_____
[Non-text portions of this message have been removed]
SPONSORED LINKS
Microsoft access database
<http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=hc7Za8QzEj1t7F8GW0yzhA>
Database development software
<http://groups.yahoo.com/gads?t=ms&k=Database+development+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=i5H8GCn7HzmglwpvhJg19w>
Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=kzlRmjQuUTEFLTjkEd6-kg>
Database software
<http://groups.yahoo.com/gads?t=ms&k=Database+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=CoCmr_EubT5Xd83NiQjcpg>
Inventory database software
<http://groups.yahoo.com/gads?t=ms&k=Inventory+database+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=DHnS8Uu1ImyGVg1J4k0BMw>
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=uEGHlFpqbscHu8mCHe7tzg>
_____
YAHOO! GROUPS LINKS
* Visit your group "ms_access
<http://groups.yahoo.com/group/ms_access> " on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
