Sort Day of Week field Sun-Sat
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I would like to create a form that allows a user to select a week of the year (Sun-Sat) by date and return the number trips by day (How many on Monday, Tuesday), separated by Trip Type (Long Haul, Short Haul, Repo) and also a day total and week total.
09/01/2012 dinner with Kate
I want to see in a form something like this:
mon tue wed thu fri sat sun
can I do this using a crossed field query?
some day have no event, other have more than one.
I have to filter by week (e.g. "this week, this week
Sun, Mon, Tue, Wed needs to calculate or add 9 days to Date
Thu, Fri need to calculate or add 11 days to Date
Sat need to calculate or add 10 days to date
This is a database to calculate the expiration day after 7 working days from a specific date.
ex. I input 01/14/2012 in the ldate field I want it to return Sat in the ldow field.
I did search but couldn't / didn't find anything specific to converting this way
Example: My start date is Wed, 1 Jun and my end date is Tue, 7 Jun. Wed counts as day 0, Thu counts as day 1, Fri day 2, Sat & Sun as day 3, Mon as day 4, Tue as day 5.
I thought about using the WEEKDAY function to determine the day of the week the start and end dates occur and calculating the workdays and adding 1 if a weekend fell between the dates, but it is possible that some of my date ranges could cover multiple weeks.
How would I calculate this with a formula/VBA
Sample Data in table:
Event/Start Day/End Day
I would like the query to produce the following:
The table with data is called VFF and has columns Date, SeriesName, Value. This is updated every Thursday.
I want to create a new table with all calendar dates where I populate the dates using the latest available data in that week.
Thu Nov 10 data from Nov 10
Fri Nov 11 data from Nov 10
Sat Nov 12 data from Nov 10
Sun Nov 13 data from Nov 10
Mon Nov 14 data from Nov 10
Tue Nov 15 data from Nov 10
Wed Nov 16 data from Nov 10
Thu Nov 17 data from Nov 17
Fri Nov 18 data from Nov 17
I have tried to think of a few different solutions but I find they are not elegant nor very efficient.
If anyone has a good idea of how I should go about this I would be most grateful
Which two TV channels do you watch the most during the day? At what times do you watch these channels?
a) First Channel (can only pick one)
b) Day (can enter multiple combinations, e.g. [Mon-Wed], [Mon, Wed, Sat], [Thurs, Sun], etc.)
c) Time (can enter multiple combinations, e.g. 8-9am, 8-11am, 10-4pm, etc.) d) Second Channel (can only pick one)
e) Day (can enter multiple combinations, e.g. [Mon-Wed], [Mon, Wed, Sat], [Thurs, Sun], etc.)
f) Time (can enter multiple combinations, e.g. 8-9am, 8-11am, 10-4pm, etc.)
The survey has 24 questions in total, I know I need to use the "memo" datatype but have no idea where to store it so it's clean and neat.
They can combine "Mon", "Tues"."Sun" in any possible combination. But I do not know how to create a field in a table that can accept multiple choices. Any articles or demo videos on how to do this?
3) Same goes for "Time". I thought to break it up to 6-7am, 7-8am, etc. in discrete 1 hour increments, but I don't know how to allow the user to select multiple timeframes. For e.g. he can just select 7-8pm, or 7-10pm by selecting 7-8pm, 8-9pm and 9-10pm.
For the booking overview I'm planning on using a cross tab query with the days of the week in columns and the Room Number as rows, tick boxes can then be used to show whether the room has been booked out on that day. Does anyone know how I could link the days of the week fields to the day of arrival and day of departure fields, so that when a record has been added for a room on them dates it shows up in the fields for the days of the week?