Access query

Roger Spratt

Does anyone know how to sort the days of the week in order, Monday Tuesday
etc. As entered as text they would normally be sorted alphabetically i.e.
Friday, Monday, Saturday, Sunday
Rog

Nov 13 '05 #1

Subscribe Post Reply

1394

Mick

Have you tried adding another field and allocating a number to it depending
on the entry for the day and then sorting that field numerically. If you are
selecting the days from a combo box you could add another column for the
numbers.

"Roger Spratt" <is****@ntlworld.com> wrote in message
news:kg****************@newsfe5-gui.ntli.net...

Does anyone know how to sort the days of the week in order, Monday Tuesday
etc. As entered as text they would normally be sorted alphabetically
i.e. Friday, Monday, Saturday, Sunday
Rog

Nov 13 '05 #2

Tim Mills-Groninger

Make a new column in the query and enter a new field along the lines of DOW:
weekday([datefield]) where [datefield] has the date value. Review help on
weekday for further options

hth,
tim mills-groninger

"Roger Spratt" <is****@ntlworld.com> wrote in message
news:kg****************@newsfe5-gui.ntli.net...

Does anyone know how to sort the days of the week in order, Monday Tuesday
etc. As entered as text they would normally be sorted alphabetically
i.e. Friday, Monday, Saturday, Sunday
Rog

Nov 13 '05 #3

by: Frnak McKenney | last post by:

Back when computer dinosaurs roamed the earth and the precursors to today's Internet were tiny flocks of TDMs living symbiotically with the silicon giants, tracking access to data processing...

PHP

Access Reports using ASP

by: Joris Kempen | last post by:

Hi people, I know that the question has come around sometimes: How to open an Access Report using ASP and export it to for example RTF. I'm trying to implement the first method of David...

ASP / Active Server Pages

Better index access = worse performance??

by: Sean C. | last post by:

Helpful folks, Most of my previous experience with DB2 was on s390 mainframe systems and the optimizer on this platform always seemed very predictable and consistent. Since moving to a WinNT/UDB...

DB2 Database

Performance on access queries with conditions

by: bhbgroup | last post by:

I have a query on one large table. I only add one condition, i.e. a date (the SQL reads like 'where date > parameterdate'. This query is rather quick if 'parameterdate' is either explicitly...

Microsoft Access / VBA

Access 2002 vs. 2003

by: Neil | last post by:

We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...

Microsoft Access / VBA

Stop Access saving 'broken' queries

by: tt40 | last post by:

Anyone know how to prevent Access 2002 from automatically breaking all the incorrect joins in a query and then automatically saving the broken query? This is what I would call stupid design...

Microsoft Access / VBA

classic asp - returning records from access in a random order

by: InnoCreate | last post by:

Hi everyone. I've recently written a classic asp website which uses an MS Access datasource. I know this is less than an ideal data source as it has limited functionality. I have a search form on...

ASP / Active Server Pages

Access Crashes When Rt Click Build in Query Design View

by: mnjkahn via AccessMonster.com | last post by:

I'm running Access 2003, modifying a query that has over 45 fields. When I right click on the field name in Query Design View, and then click Build, Access crashes before the Build window...

Microsoft Access / VBA

Access Query on SQL Linked Tables

by: jsacrey | last post by:

Hey everybody, got a secnario for ya that I need a bit of help with. Access 97 using linked tables from an SQL Server 2000 machine. I've created a simple query using two tables joined by one...

Microsoft Access / VBA

Action pass-through with a form variable Access 2003

by: magickarle | last post by:

Hi, I got a pass-through query (that takes about 15 mins to process) I would like to integrate variables to it. IE: something simple: Select EmplID from empl_Lst where empl_lst.timestamp between...

Microsoft Access / VBA

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Similar topics