Sorting In Subforms?

Oct 23, 2006

Hello!

I'm quite new to access, but i've encountered a bit of a problem
for myself here. I'm following a book here, and trying to do some of
the advances tasks, where the author doesn't describe how you solve them.

One task, is to make a subform out of a query which contains 3 tables. This
is my query so far;

SELECT Konto.Nr, Bevegelse.BevegelseID, Bevegelse.Beløp, Bevegelse.Dato, Bevegelse.Sted, Konto.Kundenr, Kunde.Fornavn, Kunde.Etternavn, Kunde.Adresse, Kunde.Postnr, Kunde.Fødselsdato, Kunde.Telefon, Konto.Kontonr, Konto.Kode, Konto.Saldo
FROM Kunde INNER JOIN (Konto INNER JOIN Bevegelse ON Konto.Nr = Bevegelse.Nr) ON Kunde.Kundenr = Konto.Kundenr
ORDER BY Bevegelse.Dato DESC;

This makes a perfect and working form + subform, however - in the subform it sorts the data after the BevegelsesID. I want to find a way to sort it desc from the "Dato" (Date in Norwegian) instead.

Any ideas?

View Replies


ADVERTISEMENT

Sorting Subforms (yes I Searched)

Dec 15, 2006

I did search the forums on this subject and can not figure out how to do what I want to do.

I have a form and subform setup. Basically by main form has contacts and my subform has log notes. It logs the date for every new record. It sorted fine up until yesterday when I ran an update query to change all the userIDs to UPPERCASE. Now it seems to be throwing the subforms in a random order.

I need the subform to order by Order date. Simple as that. I tried setting the property "Orderby" to Calls.Orderdate but it didn't work.

Thanks!

View 5 Replies View Related

Sorting A Table, Apply The Sorting To A Form

Mar 10, 2006

Hi all.
I've created a database which contains information about stores. I want to have the forms automaticly sorted by the department number.
I've tried to sort the table by department, but when I try to add a department, the sorting doesn't seem to affect the form at all.

Lets say I have department 1,2,3,6,7,8 in the form, and I add department 4, it will be the last post in the form. I want it to be the fourth, and so on..

I'd apreciate some help with this :) Thanks

Here's the database (http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=12934&stc=1&d=1142018915&PHPSESSID=f730b7f11f6983965698faeacbe5a1ee)

View 5 Replies View Related

How To Link Subforms To Other Subforms On An Unbound Form

Feb 4, 2006

I forum could someone tell me:

I have an unbound form on that form I want to put three sub forms one on a products table the other on a course start dates table and the link table that joins the other two together. all three are related to each other with Pk/FK links.

When I try to link them it says you cannot link items on an unbound form.

regards in advance
Peter:eek:

View 1 Replies View Related

Sorting?

Jun 14, 2007

Hi Everyone,

Could anyone tell me how I sort a field so it sorts by the surname, not the first name? It's one field with 2 names seperated by a space, i.e. George Michael.

Many thanks for any help.

Essex

View 5 Replies View Related

Sorting Out By Dob

Jan 1, 2008

I am doing a database containing names, dates of birth, dates of death etc of my ancestors. Does anyone know the best way of displaying it so I can sort them out by age of death? For example, I want to see someone for example who died aged 70 years and 6 months to be a place above someone who died aged 70 years and 4 months.

View 1 Replies View Related

Sorting

Jun 26, 2007

In Quebec there are a lot of place names beginning with "Saint-" or "Sainte-".

When I do an ascending sort on the table itself, these type of names don't seem to follow the expected pattern.

For the names Sainte-Marthe, Sainte-Thérèse, Saint-Ephrem, Saint-Eulalie I should see this order:

Saint-Ephrem, Saint-Eulalie, Sainte-Marthe, Sainte-Thérèse.

Instead, I get Sainte-Marthe, Saint-Ephrem, Sainte-Thérèse, Saint-Eulalie.

The names are spelled exactly as I have them in the table with hyphens and diacritic marks.

Any ideas why there seems to be a problem sorting "Saint-" from "Sainte-?

View 8 Replies View Related

Sorting...

Jan 10, 2007

Yet another question! When I run the report, it gives me the results in alphabetical order (i.e. April August, etc) instead of monthly order... Is there a way to fix this?

Thanks!
Michele

View 5 Replies View Related

Sorting

Jul 26, 2007

I have a field with addresses (numbers and letters) Whenever I try to sort it sorts by the number. How do I get it to only sort by the letters but still include the numbers in the result?

View 1 Replies View Related

Access Sorting

Oct 4, 2005

I have been trying to solve this Access problem for a couple of weeks. I have 2 Access 2002 files where I import info from a Paradox DB. I have been doing this for 12 years. I just bought a new laptop and transferred the programs over (I didn't reinstall because I don't have a floppy drive). Paradox files have a default of an International sort order.

One of my 2 Access files is now requiring an Ascii sort order. The Paradox forum says that something in the Access file is asking for the Ascii sort sequence. I have to keep bouncing back and forth in the Regedit changing the sort order from International to Ascii and back again to use the 2 files.

Do you know how I can make the 1 Access file ask for the International sort order?

View 4 Replies View Related

Question About Sorting

Jan 11, 2006

I have a table with an alphanumeric field I want to sort on. If I sort the usual ascending way, data that is numeric is sorted before data that is alpha.

Is there a way to have the alpha data sorted ascending come out ahead of the numeric data srted ascending?

Ex:

Currently,
1
2
3
A
B
c

Desired:

A
B
C
1
2
3


Thanks in advance to all who reply!!!

View 3 Replies View Related

Sorting Numerically

Jan 25, 2006

i have a simple datsbase with 2 fields - drawing number and description.
the drawing numbers are in the formatt STD123 e.t.c.
When I try to sort numerically the order ends up as
STD1
STD10
STD11
STD100
STD101..........
How do I get it to list in true numeric order in report and table view i.e.
STD1
STD2
STD3.......... Please bear in mind that my knowledge of Access is VERY limited. I've tried a search and don't understand about queries and such like. Even so I'd have thought that even the most basic database programmes would be able to handle something as simple as an alpha/numeric sort list....seems not!!!!!
????????????????

View 8 Replies View Related

Sorting Problem

Mar 30, 2006

I have a table with two columns

skill and category

i need to write some type of query or report that will group the skills into the numerical categories 1-9 and then in each of those groups listthe skills autamaticall and then have a way to print it out either in word or excel looking some thing like this

category 1
askill
bskill
cskill
category 2
askill
bskill
cskill
.....
any ideas?

View 1 Replies View Related

Sorting Addresses

Feb 28, 2007

How can I sort string addresses so as to get the correct number order? I know that strings sort on each character, which causes the problem. I have tried some things (with VAL and Len), but was not completely successful. I do not want to enter an address number as 0630, when I want 630.

Why does this not work:IIf(Len(Str(Val([address]))=3),"0" & [address],[address])? Address has 3 and 4 numbers only.

View 2 Replies View Related

Help With Sorting A Query?

Aug 9, 2007

I have a job database where I sort jobs by upcoming, inactive, closed and active. Each has a corresponding number 1-4 respectively. The main table I update the jobs in is the JOB TABLE. I print a weekly report for our weekly meeting but I only want the active jobs in the report. My question is: how do I perform a sort function in the query, so I will have only the active jobs in the database table show in the query? Thanks in advance! If more info is needed I wil post additonal.

View 4 Replies View Related

Secondary Sorting

Jan 23, 2006

Hey everyone,

Is there any way that you can do a secondary sort on a field?
Any help would be of great!

Thanks - edawson

View 2 Replies View Related

Sorting A Table....

Sep 1, 2006

Hi The beginner here again.....

How do I set a table to sort by specific fields???

ie i have an ID field which is an autonumber, then 6 fields

I want the table to autosort first by a field called [rank], and then by a field called [name]

Thanks in advance

Egg

View 8 Replies View Related

Sorting By Ignoring × And +

Jan 27, 2007

I have a table of plant names such as

×Mahoberberis
+Crataegomespilus
Iris
Scilla
Hebe
Geranium
Acorus

Note that the multiplication and plus signs are part of the names.

If I sort the table (A-Z) I get

+Crataegomespilus
×Mahoberberis
Acorus
Geranium
Hebe
Iris
Scilla

What I would like to see is

Acorus
+Crataegomespilus
Geranium
Hebe
Iris
×Mahoberberis
Scilla

I am not a programmer so need to be led by the hand, but can anyone see a way of achieving this which I could copy? My simple mind tells me that I have somehow to suppress the × and + during the sort. But how?

View 3 Replies View Related

Non-Alphanumerics And Sorting.

Mar 2, 2007

I had been using previous versions of Access, and just recently "upgraded" to 2007. I used the search function, and didn't see exactly what I was looking for, so hopefully I don't get flamed too bad if I missed an obvious thread, but here's my situation:

In the previous versions of Access that I used I would get a sort order like this:


R-256
R-276
R-500
R2325
R2598

now I get the following

R2325
R-256
R2598
R-276
R-500

This is a primary key in my table, so stripping the field it apart, sorting, and reassembling is not really an option. I jumped from Office97 to 2007 with this particular database, so I am not sure when the non-alphanumerics were ignored when it came to sorting, but is there a way to get the hypens to be recognized when it comes to sorting?

Thank you.

View 5 Replies View Related

Table Without Sorting

Jan 1, 2008

Hi,

I'm using DAO in C++ to write data in MS Access table. I found that MS Access will automatically sort those records in ascending order based on the primary key. I need to leave those records based on the write sequence, can I do that?

Thank you in advance:)

View 2 Replies View Related

Sorting Sequence

Jan 21, 2008

Hi there,

Not sure whether I am in the right forum. It is Table, Form and Query.

Have a table which index to sort on 4 fields - Proj, SubProj, Team, SubTeam.

1. I used this Table on a form, the data seems to be in random sequence instead of above.

2. Then I tried to sort it in a query which showed up fine ( as required) in the actual running of the query. However when I used this query in a form, the data doesn't sort as expected.

3. With above 1 and 2, I have also tried the Order Of in the Form properties which still do not do the trick.

can anyone shed somelight on this please.

BTW, After I first created the form, I just rename the record source in form property. Don't know whether this make any differences in the above result.

View 9 Replies View Related

Sorting A Many To Many Relationship

Jun 3, 2005

I have a table structure with many to many relationships. I want to create a query that shows all the contacts and they're related costcenters without repeating the contacts name with every costcenter.

For Example:
Joe Black ES-100-0690
.............ES-110-0149

Jane Smith ES-120-0149
...............ES-115-0690
Etc..

Instead of:
Joe Black ES-100-0690
Joe Black ES-110-0149
Jane Smith ES-120-0149
Jane Smith ES-115-0690

Etc..

Anyone can show mw how this is done?

Thanks!

View 5 Replies View Related

Reports Not Sorting

Aug 2, 2005

I have a form that the user can select a report using options through 'group options'. These then open up the report using specific queries. One report many queries.
The queries are the same except for the filter criteria.
I created 1 query then copied the rest and adjusted the criteria. I am sorting on a numerical value.
All the queries sort fine in preview but not in the report except for 1.
If I copy this query and alter the filter criteria it solves the problem.

I want to know what am I missing.
All this is done using VBA.

Cheers


Gordon :confused:

View 3 Replies View Related

Sorting By Date

Oct 7, 2005

I have the data below in a query in Access, and I want it to sort by the Week Begin date.
I have put a sort on for 'Ascending' but it doesn't work. (Due to the 29th being after the 28th - regardless of month)

Is there any way I can force the sort in this query ?
It must be in the same query though, as I could probably do it by using this query in another one then sorting that. However, I don't want to do that for reasons I won't bore you with.

WeekBegin Count
05/09/05 137
12/09/05 90
19/09/05 22
26/09/05 55
29/08/05 122

PS - I should mention that I think it is because the WekBegin date is an expression based on an actual date field. Therefore I believe it's treating it as some sort of text field.

Any help would be appreciated.

Thanks.

J.

View 2 Replies View Related

Sorting By Month

Mar 1, 2006

I have looked and tried a lot of things that I have seen in this forum, but I am not able to make this work. I have a query that I am trying to sort a table field, "Date" by month. The field has a "General" time/date format in the table. This is the last code I tried, but as you can see I am not much with VB. Please see if you can help me. The table name is "Batch Data" and the field name is "Date".
Thanks,
Robert
SELECT Format([Batch Data].[Date],'General Date') AS formDate
FROM [Batch Data]
ORDER BY [Date];

View 5 Replies View Related

Sorting Problem

May 26, 2006

I've done a quick search but haven't found a solution.

I am trying to sort within a query before making a report from that query. I need to sort by date. Currently, it is sorting by date but by month instead of by year. So my data is being sorted similar to this:

11/30/2004
10/18/2005
. . .
1/8/2006

I need it sorted so that the most recent date is listed first. In this case, the most recent date is 4/23/2006 but it's actually showing up in the middle of the listing. :confused:

I know there must be a quick and easy way to do this but due to my hit and miss use of Access, even easy answers are never easy for me! :eek:

Thanks in advance for any help!

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved