I have looked through the Access 2002 Bible book and can't find any references to partitions. Is there some other reference book that might explain this or is this a process used in VBA only? dave
-----Original Message----- From: ms_access@yahoogroups.com on behalf of John Viescas Sent: Sun 11/6/2005 8:11 AM To: ms_access@yahoogroups.com Cc: Subject: RE: RE: [ms_access] Airline Schedules dbase Dave- Take a look at the Partition function to segment your data by 15 minute intervals. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dave Moreau Sent: Saturday, November 05, 2005 11:20 PM To: ms_access@yahoogroups.com; ms_access@yahoogroups.com Subject: RE: RE: [ms_access] Airline Schedules dbase P.S. Thank you for the first reply...how rude of me not to say so. dave -----Original Message----- From: ms_access@yahoogroups.com on behalf of Dave Moreau Sent: Sat 11/5/2005 5:10 PM To: ms_access@yahoogroups.com Cc: Subject: RE: [ms_access] Airline Schedules dbase That worked....now for one more question...I need to separate flights out by time every quarter of any hour. 07:00 07:15 07:30 07:45 08:00 I have a field called Ops_Time that indicates what time either a departure or arrival operates. How do I group and count them so that I have a tally of the number of operations per quarter hour (or by changing the query or calc the number of ops by every 5 minutes, or in one hour increments)? Ops_Time Number_of_Flights 07:00 4 07:15 8 07:30 25 07:45 35 08:00 45 The table data looks like this (this is an arrival flight only). I need to group and count the number of flights based on the Ops_Time filed only: ID Ops_Date In_Flt In_Org In_ACType Ops_Time Ot_Flt Ot_Dst Ot_ACType Flow 4 11/2/2005 5933 MOB CRJ 7:25:00 AM ARR-9E-JET I can easily group times in a query using between #07:00:00# and #07:15:00# but I'd have to have 96 separate queries to run a calculation for a 24 hour time period for all flights. I know there has to be a simpler way to group the 15 minute time slots and calculate the number of flights in each time slot. Any ideas??? Do it in a form with unbound text box and formulas with no calcs or groupings in the query? Thanks Dave -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of John Ruff Sent: Saturday, October 29, 2005 4:47 PM To: ms_access@yahoogroups.com 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 <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Microsoft+ > &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 <http://groups.yahoo.com/gads?t=ms&k=Database+development+software&w1=Micros > &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 <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Microso > &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 <http://groups.yahoo.com/gads?t=ms&k=Database+software&w1=Microsoft+access+d > &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 <http://groups.yahoo.com/gads?t=ms&k=Inventory+database+software&w1=Microsof > &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 <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Microso > &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 <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! Terms of Service <http://docs.yahoo.com/info/terms/> . _____ [Non-text portions of this message have been removed] _____ 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/> . _____ ------------------------ 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 SPONSORED LINKS Database development software <http://groups.yahoo.com/gads?t=ms&k=Database+development+software&w1=Database+development+software&w2=Membership+database+software&w3=Microsoft+access+software&c=3&s=100&.sig=Upzwr-Ik5Xj7qTR0JbBxgw> Membership database software <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Database+development+software&w2=Membership+database+software&w3=Microsoft+access+software&c=3&s=100&.sig=6uBrvgrPHnjEy1rxZwhBcQ> Microsoft access software <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+software&w1=Database+development+software&w2=Membership+database+software&w3=Microsoft+access+software&c=3&s=100&.sig=cQRMc0w3NAv87fvWTSrKbg> _____ 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/