Topics Search

Sort Day of Week field Sun-Sat

Sort Day of Week field Sun-Sat
Views: 6
I really did search for this but I only go information on how to sort a Date (1/1/1900) to Sun-Mon. What I need is a text field that allreay has the day of week sorted. Below is what i have now....
Sponsored Links:

More topics

 

Diff between two dates (sat/sun = 1 day)

Preview
I have a pickup and delivered date of a package. I need to calculate the difference of the dates with sat/sun only counted as one day. Does anyone have scripts to do this?
 

Form to select week and display weekday totals

Preview
I have a table with the following fields:

Trip#
TripDate
TripType

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.
 

IIf Date Query

Preview
This is in Access 2010 and I am adding days to a date based on a certain day of the week. Sun, Mon, Tue, Wed would add 9 days and that portion works fine. When I add the next part forThu, Fri and Sat it gives me a -1 result for all days.

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.
 

how to create a week planning?

Preview
I need to create an access file that show a "week planning" based on a table of this type:
ID_event
Data_event
Text_event

e.g.
09/01/2012 meeting
09/01/2012 dinner with Kate
11/01/2012 gym
25/01/2012 meeting

I want to see in a form something like this:

mon tue wed thu fri sat sun
meeting gym
dinner wi.

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
 

Date to day of week

Preview
I have a field ldate (lesson date). Next to that, I have a field ldow (lesson day of week). I am trying to return the day of week in that field based on the ldate then save both to the table.
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
 

Date Calculation

Preview
One of my customers made a funky request. When calculating date ranges on their report they want to calculate calendar days but count Saturday and Sunday as 1 day.

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
 

Day of Week Totals

Preview
I have a table that has Event, Start day and End day as some of the fields. I would like to have a query that totals the number events for each day of the week. The tricky part is that the start day and end day may be different and I need to count the totals on both days.

Example:

Sample Data in table:

Event/Start Day/End Day
1/Mon/Mon
2/Mon/Tues
3/Mon/Wed
4/Wed/Fri
5/Sun/Thu

I would like the query to produce the following:

Day/No. Events
Sun/1
Mon/4
Tue/3
Wed/3
 

Filling in data in query

Preview
I have a table with data for only one day a week (Thursdays). This data is used for that week until we get a new set the following Thursday.

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.

i.e
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

etc

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
 

Survey design

Preview
I'm trying to design a database that can record the responses of a survey. This survey has 24 questions in total. This is the first time I'm doing this so I have zero experience.

Question 1:
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.)

Problems:
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.
 

conditional tick box

Preview
I'm trying to make a booking overview, I have a field for each of the days of the week which is set to Yes/No data type. I also have a field for the day of arrival and day of departure.

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?