The main form of our contacts database has its source in a query which places all contacts in alphabetical order by surname. How do I get the query to sort by surname and then by first name? Also, how can I get the query to run each time a new contact is added so they are put into alphabetical order when they are saved, rather than appearing at the end of the list?
I have created a form with a drop down box so that I can click on a client in the drop down box and it will pull the information from that clients record.. my question is : Is there a way of having the clients names in the drop down box listed in alphabetical order without it changing the order in my table? My table is listed in order of project numbers not client names.
I have inserted a bar chart onto a form using a totals query. The query is grouped by days on stock, eg. '0-30', '30-60', '60-90' etc. which is therefore the labels on the x-axis.
The chart displays the correct data, however, the chart automatically displays the categories on the x-axis in alphabetical order... '0-30', '120-180', '30-60' etc.. Is there anyway to adjust this order to be eg. '0-30', '30-60', '60-90' etc?
I have a report that generates 100 items in alphabetical order. All of the items are also displayed in a table. I have a bound form attached to the that table, and when the items appear they are not in alphabetical order. Therefore, it is a hassle typing in the data when the form will not appear in order, because instead of going in order I am flipping through pages. What is causing this to happen? And what can I do to fix this?
I have a Table with 6 fields, 2 are named Initial and Surname. Is it at all possible to have a combo box on a form with these to fields "joined" with the alphabetical order on the Surname. I understand that using a query will not work as the result is based on an expression
I am using a combo box in my form and its row source is set to Table A, however, the data in the combo box arent displayed in alphabetical order even though the data from Table A is sorted in ascending order.
can pls help me by teaching me How to display "row source" in combo box in alphabetical order??
How can I preserve the user-defined sort order in a column in a table?
Every time I exit the table, and go back, my items have been alphabetically sorted. This results in my Combo Box displaying the list in alphabetical order, rather than my custom order.
I have a string where alphabetical and numerical characters are mixed up. I need a string function where I can find the index of the first non-numerical character. I tried with the mid function but could not get it to work.
I have tried posting this message before, but with no results. I am trying to get a query that will give me all of my customers and show what their last order date is. The query that I have now is coming back with ALL the dates the customers made purchases. Here is how I have the query set up: Field1 Customer ID Field 2 Customer name Field 3 Address Field 4 State Field 5 Phone # Field 6 Order Date (Last in Group by) Field 7 Shipping Method Field 8 Salesman name
The query is a select query and I hit the totals button on the toolbar. In Field 6-Order date, I have it grouped by "last". Another problem that I have it I am working in a 97 access database. I have tried to convert it to 2003 with no success. So, I am not able to make NEW queries or reports. I can modify them, but when I close the query or report design, it does not save.
Can anyone help me with this query problem? It is very perplexing.
Hi All, I am modifying some asp product catalog query to sort by order of 'price' so the data from the DB is displayed on the page from cheapest to most expensive, I am a newbie but keen..... <%if not request.QueryString("cid")<>"" then%> </font> <%end if%> <% if request.QueryString("cid")<>"" then set rs = cn.execute("Select * From Products Where CategoryID= " & request.QueryString("cid")) end if %> <% if not rs.eof then while not rs.eof %>
This extract shows a request to select products from a specific category but I want to disply them in order of ascending price....can any power users out there set me straight. greatly appreciate it. cheers now
I have a combo box that contains the months. They appear in month order on the form but when I query, they are in alphabetical. How can I get this to be in month order on the query?
i have a query which looks at 2 fields: "employee number" & "agency number", i would like the query to list the employee numbers in order first (1,2,3...) then the agency numbers in order (100, 101, 102...). ive changed the ascending/ descending order for them both but doesnt help. Its mainly the form that looks at this query i would like to fix so that is shows all employee records in order of employee number first and then underneath all agency numbers in order of their number (some employee numbers & agency numbers are null) hope this makes sense , any help would be great
I need to get all the services for one license, but only once, you'll see what I mean
Pk Service Service_Name MyDate Fk_Licence 1 Base 10/5/2004 5 2 Base 12/6/2004 5 3 Super Base 11/4/2004 5 4 Base 20/10/2004 5 5 Super Base 17/7/2004 5
there's about 7000 records with the same 4 services recurring all the time
All I want for one license is the all distinct services for a chosen date
If I select License 5, and today's date, 26/10/2004, I would need the latest service (closest date but has to be inferior or equal), in this case
Pk Service Service_Name MyDate Fk_Licence 4 Base 20/10/2004 5 5 Super Base 17/7/2004 5
Here's the query I have:
select distinct Service_Name from Services where Fk_License=5 where MyDate <= SelectDate order by DateDiff('d',SelectDate,MyDate) DESC
where Fk_License is to get only the services for a particular license distinct if to only get each service once MyDate <= SelectDate if to get only the services older than the selected date order by is to get the latest service cause there will be a lot of services older than the selected date
I have started a table to manage expenditure with dates payments and headings. Set up a query to summarise the monthly amounts by each heading. The Query is sorting the date in date in alpha order not date order so I get February before March etc. How do I get it to show chronological order?
I've created some queries on some data that return summary information to then chart over time. The fields being returned are YearGroup, Academic Year, Term, TotalI want the data to get sorted by YearGroup (Year7, Year8, Year9 etc) however, when it sorts the data it sorts it starting with Year10, Year11, Year7, Year8, Year9.
I am trying to create a work schedule, some customers are scheduled for morning and others in the afternoon. I am trying to figure out how to sort AMs and PMs so I get a line with every other one.
I have a combo box that contains the months. They appear in month order on the form but when I query, they are in alphabetical. How can I get this to be in month order on the query?
Does anyone know (and would be willing to share) how one can order the results of a Union query in Access by something other than the returned values?
I have a simple Union query that would work perfectly - if I could get the thing to order the results in a particular order everytime:mad:. The query returns counts (all from one table) of separate select statements that each meet certain conditions (e.g. having state=Nevada, having state=California, etc.) as records - but since Union queries in Access order results in ascending or descending order by returned value, it puts my records in a different order every time the record values change. I need to have them ordered the same way (in the same order as they appear in the Union query, if possible) everytime so that I can return those values to specific cells in MS Excel. Any suggestions would be much appreciated!
Hello, I have created a crosstab query where I specify the order of Column Headings, however, I can't figure out how to specify the order of Row Headings. I only see that Microsoft Access offers the option to sort ascending vs. descending. I'd like to customize my sort order such as "Under 18" row first followed by "18-29" row and then "30-39" etc.
I have a Report that uses a query as it's record source. I have the query ordered by a field, which works as expected in the table view of the query. In the report, however, the ORDER BY clause does not seem to carry through. The field is not sorted Ascending. What's going on?
Why does access automatically rearrange column order in a query after closing and reopening? Is there a way to stop it? It doesn't affect the usefulness of my query but I set the columns up in a specific order and I'd like them to stay that way. This is an update query. I see that it is grouping them by name. Anyway to stop that without giving each field a unique name? Screenshots attached.
I have set up a basic database that has a customer table , orders table , join table and products table. I have created an invoice form that has customer details and then in a subform has the order ID and product ID , name , price and quantity.I have a text box on the form to which I am trying to output the sub total to when the form is launched(quantity X price for the current order).I was trying to create a query that will return the subtotal for an order.I had the query calculating the subtotal but I was then trying to get t the cost based on the order ID. I was then attempting to get the Order ID for the query from the open form by adding this to the criteria in the query: