Help - Need A Way To Sort Data Effectively

Aug 15, 2006

Hi,

I am currently implementing a stock control database in access. I have various forms for entering stock in and taking it out etc. It all works fine except I need a way of sorting my data to produce very specific reports. The company wants reports to be listed in a very specific order. I have many fields with which I have to sort the data so it has proved a very time consuming problem.

I have tried the custom sort order techniques involving the switch function, however due to the large extent of data in use this approach has limited success.

I have also tried merely applying numbers to the front of a stock item to sort it, however this is a very basic approach and means the user has to look at random numbers before actually reading the stock item in reports.

One approach that could work would be to have a sort order as a separate field. But the user would have to then enter a sort order number each time data is entered(?).

Does anyone have any ideas as to how to solve this problem?

Apologies for the length of this post!

Cheers
Turbojohn

View Replies


ADVERTISEMENT

Sort Data In A Combo Box

Mar 1, 2005

I have a combo box based on a table. The table is sorted by the Customer surname field using the Order By property. My Problem is the combo box will still display data in the unsorted order ie in Primary Key order.

Any suggestions on how I can make the Combo Box display dat in ascending order of Customer.

View 3 Replies View Related

Sort Data On My Form

Aug 31, 2005

When I open my form the data are sorted through the ID, How can I change that to be sorted through the Year? On my form properties is that the Filter is responsible for sorting?

View 5 Replies View Related

Allow User To Sort Data

May 10, 2006

Hello everyone

One of my forms has a load of data displayed in it from a query and I would like to allow the user to sort this data by means of some buttons next to each column heading. For instance clicking 'up' next to first name / last name etc will sort ascending on first name, 'down' will sort descending etc. I tried setting up different queries for each sort and changing the record source of the form in the on click event but then the controls don't seem to know where to populate from!!

Can anyone help with what I should be doing?

Thanks

View 2 Replies View Related

General :: How To Sort Raw Data

Feb 21, 2013

I need to create a absenteeism database for work . I have attached a sample data for you to see how my table is in access.

so the fields that i have are name, team leader, date, code, department, minutes.

from this raw data I need:

1) a high level summary report that groups all ccps by team leader and how many hours the team leader has and each individual ccp.

2) summarize by code the hours each ccp has and also occurence. if the ccp has been sick 3 days in a row then it is considered 1 occurence. if they have been sick multiple days but are not concurrent then each one is an occurence so i need that info categorized by month and tl.

3) a form where the user can pick what codes they want to see from a check box / list box (which one would be better?) and group those codes by ccp and team leader month over month.

View 13 Replies View Related

Sort (order) Data On Forms

Apr 12, 2005

Hello,

This is related to "Old_value, new_value" thread I posted yestarday (Module&VBA).

I have a problem i missed yestarday. The code it's vorking great, but it allways takes the showed new_value and makes it old_value for the new record, and this is a problem, because the showed record is not the last for that customer.
So, I was thinking that if I make a new Autonumber field in my table, I could sort descending the values and this way the input form will allways show me the last entered data for that person.
As I noticed from a long time ago, if I sort a table that allready has a form, the form won't show the records sorted. Why? It's necessary to make the form again? I tried to order the data on the form from Properties window ->Data->Order by, but the ordering is Ascending and I need it Descending!
Can enybody help me?

Thanx,
Attila

View 1 Replies View Related

Sort & Data Type Mismatch

Dec 20, 2004

Hi. I was doing a simple query that resulted in a "data type mismatch in criteria expression" error. Hunting around for the source I realized that when I attempt to sort a column of numerical data a hidden decimal point is inserted and what should be an order of : 45, 10, 9, 2, becomes this order: 9, 45, 2, 10 (i.e., 9, 4.5, 2, 1.0)

Does anyone know what has happened?

moondog

View 1 Replies View Related

Exporting Data With A Custom Sort Order

Jun 7, 2007

Hi,

I have a Form which contains a datasheet and I have some code which allows users to custom sort this datasheet. Another table based on this datasheet is then exported as a csv file.
However, the data is obviously not exported in the same order as the datasheet and it is quite critical for the application to be a sucess that it is exported in the custom order chosen by the user.

I have done some re-search, searching groups, forums etc and found the solution of having a 'sort column' in the table the datasheet relates to, I can then use this in the query that exports the data. My only problem with this is I had to manually fill in this sort column in the datasheet, once I had decided upon my final sort order. Is there anyway to fill this column automatically based on a row's position in a datasheet?

Many thanks in advance

View 4 Replies View Related

User Input Data In Table Using Form - Sort By Month

Mar 28, 2013

I have a table with product numbers and their cost. That table has 3 fields : SKU, Cost, Month. (The cost can change every month, therefore the list is built to have a cost / month)

I want the user to be able to input the data in the table using the form but I would like the form to be sorted Alphanumerically for the SKU numbers and then per month (in their normal order not alphanumerically).

I have a combobox (named month for testing purposes) to force the user to select one of the 12 months and the field type is Text.

Also I am unsure how to "autosort" (or apply a permanent sort) the form whenever it's opened. Will it be applied if I just set the sort and then restrict the user from seeing let's see design mode?

View 4 Replies View Related

Forms :: Sort Of Limit On Number Of Columns Contained In Data Source For Such A Box?

Jul 14, 2014

I have a form I created in the past that auto-fills some of its fields based on the user's selection of a record from a combo box linked to another table. The form has been working perfectly however I recently tried to add a couple of more fields to the form that need to be autofilled. I added the new fields to the source table and added columns to the combobox that should allow my VB code to fill those boxes. However only one of the new fields is filling correctly. After trying a few different things I notice that the problem seems to be with whatever data field becomes the 21st column in the combobox. Is there some sort of limit on the number of columns contained in the data source for such a box?

Option Compare Database
Private Sub EmpIDAutofill_Change()
Me.EmployerCatAutofill.Value = Me.EmpIDAutofill.Column(1)
Me.StreetNumAutofill.Value = Me.EmpIDAutofill.Column(2)
Me.JobCityAutofill.Value = Me.EmpIDAutofill.Column(3)

[code]...

View 3 Replies View Related

Forms :: Form That Shows 100 Records At A Time - Filter / Sort Data Source Entirely

Oct 20, 2014

The recordsource is a query with over 6,000 records. The form currently lists the records in datasheet format with header and footer for things like buttons and filtering. The client wants to be able to go from page to page of the souce query, showing 100 records on the form at a time.

But at the same time, they should be able to filter or sort the data source in it's entirety. The person who created the form came up with what seems like an awful solution to the problem. It seems to use a random number generator to determine how many records to portray at a time. I see this in the code as well as in operation, because the number of records on page to page varies. It doesn't even start out at 100! Worse yet, using a sort on the page only sorts the records that are visible.

View 9 Replies View Related

Report Sort Different From Query Sort

Mar 3, 2006

i made a report based on a query. when i run the query, my results are sorted by Job Time Ascending, like i want...
when i made my report i chose job id as the main group priority in the wizard..

now in my report it displays the jobs in ID ascending, rather than Job time ascending as my query says..

i dont want to re-do the report it took ages.. how can i fix this?

View 3 Replies View Related

Can I Do A Sort Within A Sort On Combo Boxes?

Oct 16, 2006

Hi all,

I have a form in Access 2K that properly displays city, state and zip codes. As I type in each letter of a city's name into the combo box, I get the first city in the sorted list displayed (autofills). That's fine when there is only one zip code for a city, but when I enter "chic" for chicago I still get the first chicago zip code in my table.

It sure would be nice if I could do a "sort within a sort" so that if there were two or more records with the same city name then that whole group would drop down so I could choose one of the other zip codes. If this is doable, kindly point me to an example as I need all the help I can get.

Thanks in advance for any responses.

D

View 6 Replies View Related

Report Sort Is Not The Same As Query Sort...

Jan 9, 2005

I have a query that sorts players batting averages from highest to lowest. When I run the query just by itself it sorts it right however when I open the report based on that query it does not sort in descending order like I asked. What am I missing??

View 3 Replies View Related

Sort By A Value

Aug 8, 2005

I was just wondering if it was possible to run a query by a specific value first, then the remainder of the following values in ascending order.

For example, the data would appear in the table as

Smith
Bloggs
Jones
Taylor

What I would like to do is have all the Taylors at the top, followed by Bloggs,Jones then Taylor

I have looked at the OrderBy function, but believe that you can only sort Ascending and Descending

Checked search, cant find anything

Many Thanks

Andy

View 3 Replies View Related

Re-sort

Mar 25, 2007

Hi,

I try to do something but I don't know how.
I have 1 table with 3 rows (title, year, genre) and 1 Form.
Is it possible to create combobox or something with 3 criterium, when I selected
criterium to re-sort columns in Forms (by title, by year, by genre)?

thank you

View 2 Replies View Related

Sort Asc / Dec

Jan 13, 2006

Continuous form:
The standard menu / toolbar commands sort ASC and DEC work just fine.
However, if I define a button with the VBCode
"DoCmd.RunCommand acCmdSortAscending", I get an alarm message pop-up
saying "the command or action "SortAscending" isn't available now".
I made sure that the standard menu items "Sort asc / dec" are not grayed out(disabled) at the time I click the button in runtime. The mouse cursor points to the desired sort criteria field.

Any advice?

Regards from Belgium (pretty cold here)

View 2 Replies View Related

How To Sort By IP Address

Aug 29, 2005

I am completely stumped on this one. I have a database where we track IP Addresses and I just want to sort by IP...should be simple, I'd think.

With these 5 IP's, I'd want them in this order:
1.2.3.1
1.2.3.4
1.2.3.7
1.2.3.9
1.2.3.10
1.2.3.17
1.2.3.21

But it sorts in this order:
1.2.3.1
1.2.3.10
1.2.3.17
1.2.3.21
1.2.3.4
1.2.3.7
1.2.3.9

Is there anything I can do to fix this? I want it to see each number as a whole, for example "10" instead of "1" and "0"

Much thanks.

View 5 Replies View Related

Sort Order

Oct 10, 2005

How do you change a file's sort order from ascii to international?

View 3 Replies View Related

Sort Table

Dec 22, 2005

Hello all...
I have a table which includes month, day & date. I want to sort this table by day, and then by month & then by year... does anyone know how to do this?

Thank you...:)

View 4 Replies View Related

Help Newbie Sort Out His DB

Jan 16, 2006

Hello all

Been looking at this forum for a few weeks and think it's great!!

Now for my first post :rolleyes:

We have a DB at work (attached) and it was put together by a consultant would you believe. Anyway I have been given the task to fix this. It now work i.e. it records what I want. The only problem is that it's written with more macros than i've ever seen.

I want some advice on the DB to make it function better. It is used to record how long a member of staff spend on a piece of work, apologies for the interface.

1. The user must first input a date , start date and end date into a table. Now the start date will always be a Monday and the end date a Sunday. Is there anyway to automate that process? i.e if a user goes in on a Monday the prevous weeks date is there but if the user went in before it would not , get the idea.

Anyway, please rip it to shreads and give me some advice

Thanks

View 11 Replies View Related

Auto Sort Anyone

Jan 25, 2006

I have a table already set up in a Subform of a main form

The Table has values like
-Date
-Time
-Name
-SchBy

I want to have the subforms table to automatically re-sort ascending by Time, how would I go about doing this so the user doesn't have to click the field then sort ascending button...?:confused:

View 1 Replies View Related

Hello, Sort Anoob Here

Oct 17, 2006

hello ladies and gents!
I've been kind of lurking around.
I love this site! thanks for having me :)

View 1 Replies View Related

Sort Negative First

Jan 15, 2007

When i sort values, for some reason the negatives are at the top, followed by the highest positive values. Anyway to turn this off?
Tried google and searching these forums.

View 5 Replies View Related

MDB To TXT Looses Sort

Dec 9, 2007

Hi all.
I imported a text file into a new table.
I sorted the table on one field, then exported table to another text file.
But, the sort did not export. The new text file has the same sort as the original.
What am I doing wrong?
Thanks.

View 3 Replies View Related

Sort Date

Dec 13, 2007

Hey all, I looked throught a couple of threads for sorting, but could not find exactly what I need.

Basically, I have a list of dates:

10-Aug-07
20-Oct-07
13-Nov-07
etc...

and when I try and sort these dates from earliest to latest, it only reads the number and not the month, like:

10-Aug-07
13-Nov-07
20-Oct-07
etc...

How would I make it sort by date and month?

Thanks,
RR

View 4 Replies View Related







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