Best Way Of Sorting This Data

Nov 5, 2004

i have 2 tables...

1st table called -"tCodes"
containing fields called -

CodeID (PK) - Autonumber
Code - Text
Code Description - Text

2nd Table - "tMachines"
containing fields called -

MachineID - (PK) - AutoNumber
Machine - Text


examples...

Codes

A101
A102
A103
A104

Machines

A
B
C
D

I need to assign various codes to specific lines...

for example i may need to assign A101 to lines A,B & C but not line D

i was thinking i should make a third table and link the 3 together...should i do this..?

also i think that this could be a huge task as i have over 25 machines and over 700 codes the combinations are huge, what is the best way for me to overcome this problem ?

View Replies


ADVERTISEMENT

Data Sorting And Count

Feb 10, 2008

hi dear members
i m new in access dont know how make query i wanna sort and count duplicate recorde with the help of query
for example
id numbers total numbers of trade
A 123 98674
B 456 98458
C 674 093253
A 123 84545
A 123 3423

I JUST WANNA COUNT "ID" AND "NUMBERS" COLIMN HOW MANY TIME A USE 123 NUMBERS HOPE U UNDERSTAND MY PROBLEM PLZ LET ME KNOW HOW I SORTED OUT THIS PROBLEM

HELP APPERICIATED

View 1 Replies View Related

Ordering/Sorting Data In Form

Feb 24, 2005

Hi all,
I have a simple 2-table database. the 'parent' table is tblProducts, and the 'child' table is tblDocuments. (one [products] to many [docouments] relationship)

My data entry is done using a 'documents' subform inside a 'products' parent form. The data entry works fine, except i would really like it if my products and documents would be listed in alphabetical order in their respective form/subform {makes it easier on the user, and saves me needing a find record button}. At the moment they seem to be ordered by the time in which they were added to the table. I guess Access is using the primary Key as the 'order by' parameter.

The thing that is infuriating me is that i have gone into my two tables and told access to sort the data by Product Name, and Document name in the respective tables. I can verify that this has worked by going to data view; lo and behold the data are listed in the order i specified.

Further I have gone into my form and sub form properties, into the Data...Order By property and have keyed in the name of the field i want to sort by (product name in the parent form, and document name in the sub form).

I have tried all combinations and permutations of the above processes but nothing seems to work.

It seems i am missing one crucial piece to the puzzle, as i haven't had much luck finding a solution on groups.google or anything else (maybe im using the wrong search terms). I am having this problem with all of my databases, so any help would be appreciated.

Thanks in advance.

View 2 Replies View Related

Sorting Form By Filtered Data

Mar 14, 2006

I have a button that opens a second form and shows filtered data based on the selection of a ComboBox from the initial form. That all works nicely, I now wish to sort the Data in the new form by [POID].

The code I'm using looks like this;

Private Sub Command5_Click()
On Error GoTo Err_Command5_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "FRM_AWMPonum"

stLinkCriteria = "[ClientID]=" & Me![Combo0] & " AND IsNull(DelDate)"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command5_Click:
Exit Sub

Err_Command5_Click:
MsgBox Err.Description
Resume Exit_Command5_Click

End Sub

What changes do I need to make to the code to sort the data?

View 3 Replies View Related

Help Sorting And Filtering Data For A Report.

Oct 22, 2004

Hi everyone,

I am having a little trouble using a 'canned' Access database. Using the built in Asset Tracking database, I am trying to get specific information on the Assets report. The Assets report generally shows all assets, I've made a new report to show the data sorted by the phone extension number, also the room number (which is how our inventory is tracked).

This works well, except, I want to be able to view one extension/room at a time. To do this, I added a button on the 'Enter/View Emplyees' form to preview the report, and created a macro to get this info. However, it only shows whatever data is highlighted in the emplyees sub-form. How can I get all of the data assigned to each extension to appear on the report?

Tried to upload the file, but it's too large. Can email if requested.


Thanks,
Brian

View 1 Replies View Related

General :: Sorting Data In A List Box

Sep 21, 2012

I have a database with a form. Form has a list Box. I write a code for sorting data in list Box and it is worked but sorting in one of the column in list box does not work.I think the reason of it that this column is a combo box with multiple values.

The file of database is in attachment.

View 2 Replies View Related

Sorting Data In A Form By Clicking On The Header

Aug 31, 2006

Is there a way to sort data in a form by clicking on a corresponding control (e.g. label/txtbox) in the FormHeader?

View 5 Replies View Related

Sorting Ends Data Entry Mode

May 14, 2013

I have a form containing a subform. The subform is opened in data entry mode, so it displays no existing records. However if the user right-clicks the form and selects a sort, all records are displayed. Is there any way to stop this behavior so that the form remains in data entry mode?

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

IIf Statement Used For Sorting Data Based On Option Group

Jan 10, 2006

Hi all,

My problem is as follows:

I am trying to generate a report, which is based on a query, which references a form that has an option group containing four options.

I want to sort the data according which option group radio button has been selected (they the values of 1,2,3,4).

Originally there were only 2 options and the query said (in SQL view):

ORDER BY IIf(Forms!frm_08_reportsort!opt_sort_by=1,TBL_Acco untManager.Name,TBL_SiteContactDetails.SchoolName) ,

This works fine for 2 options, but I can't figure out what command i should use for more than 2 options :confused:

Any help would be much appreciated :)

View 3 Replies View Related

Reports :: Hiding Field That Is Only For Sorting Purposes To Group Data

Sep 24, 2014

I have a table of about 250 items that are sorted based on two fields. I created a query of the table and hide one of the fields because it is only there for sorting purposes to group the data.

For example, I have a "Type" field. In the type field, I differentiate the items with different categories, such as "Materials", "Safety", etc. My next field is "subtype" which assists the "Type" field being sorted properly for my needs. In the "Materials" category, all of the items are either "Fencing", "Plastic", "Wire", or "Miscellaneous". I am sorting the "type" and "subtype" fields in ascending order so that all the "materials" are grouped together, and all of the "fencing, "plastic", etc are grouped together within the materials field.

I am creating a printable report and I do not want the "subtype" field to be on the report, but I need the "subtype" field's sort to be affecting my data so it is grouped properly. I'm having difficulty, is there a way to hide fields in reports?

View 3 Replies View Related

Modules & VBA :: Sorting Out Data To Be Used In Final Table - Runtime Error 3021

Nov 25, 2014

I have managed to sort out the data to be used in the final table. However, I am having trouble transferring the data from each of their own tables into the final table.

Each time I run my code I receive "run-time error 3021: No current record."

It seems that only my timestamp is being added properly, but the error pops up and highlights the first "rstInsert.Edit" of my code. I'm suspecting that my function is running too fast, such that it did not have time to read that the table has already been populated by the timestamp in the AddNew code

Code:
Private Sub Command9_Click()
Dim dbs As DAO.Database
Dim rstTimestamp As DAO.Recordset
Dim rstAcknowledgement As DAO.Recordset
Dim rstAgent As DAO.Recordset

[Code] ....

View 1 Replies View Related

Reports :: Group Data In A Report From Single Table Using Grouping And Sorting

Dec 2, 2014

I'm trying to group data in a report from single table using grouping and sorting and I want the percentile of every record over group total. I'm using a query to fetch data from table, however I'm unable to get percentage of every single record over group total.

I want to display the report as attached image in single report. I'm unable to get data in "Perc" field. It's populating wrong values.

View 3 Replies View Related

Moving And SORTING Multiple Column Data Into One Column

Feb 25, 2008

Hi. I have a question I'm hoping someone can help me with. I would like to take data from multiple columns and put the data into one column. Additionally, I do not want to exclude any data (union all) and I would like to group the resulting union by another field. For example:

Original data layout:

Column Headings: Sample Event, Depth 1, Depth 2, Depth 3,
1st Row Data: 1, 6, 9, 12, 9
2nd Row Data: 2, 7, 9, 8, 3

Desired data layout:

Column Headings: Sample Event, Depths
1, 6
1, 9
1,12
1, 9
2, 7
2, 9
2, 8
2, 3

So far I'm using the following SQL. What do I need to add or change to get my desired result of grouping the unioned depths by the 'sample event' field?

I appreciate any help anyone may have to offer. Thank you.

SELECT Depth1 AS Depths
FROM Depth_Velocity_Substrate_Correct
Union all
SELECT Depth2
FROM Depth_Velocity_Substrate_Correct
Union all
SELECT Depth3
FROM Depth_Velocity_Substrate_Correct
Union all
SELECT Depth4
FROM Depth_Velocity_Substrate_Correct
Union all
SELECT Depth5
FROM Depth_Velocity_Substrate_Correct

View 5 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







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