I have a report that has a field (4) whose data is in the form of NO.1.1.2, NO.2.1.1, NO.1.12.3, etc. It is not allowing me to have the report display with those in order, sorting this field is not offered. My report is being grouped by Fields 1, 2, and 3, no sorting. How can the data then displayed in Field 4 be in order of those numbers. Sorry I don't know more about Access and I'm having to do this without support. Thank you
View RepliesI 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?
I have a table for gathering interview scores for candidates from multiple reviewers (example below)
Field1 - RankID
Field2 - Presentation Score
Field3 - Writing Score
Field4 - Applicant Name
etc.
Each applicant will be interviewed by multiple reviewers. I want a report to display the data is grouped by Applicant name, but sorted by Score.
Applicant2 - average presentationscore = 5
Applicant1 - average presentationscore = 4
Applicant3 - average presentationscore 2
it seems simple enough to group by applicant name and sort by PresentationScore, but this does not work. I have used the grouping and sorting feature in every combination I can think of and it always keeps the Applicant Names in order whether I group first on PresentationScore (which will then give me several entries for same applicant) or not. What am I missing?
In reports, we can sort items, A to Z or Z to A.
Is there any option we could apply another sort list customized to different criteria ?
For Example, first display B, then A then C ?
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:
Is there a code that I can use to sort out certain information by salesmen number? I am not sure if I can use a check box or a code? Help?
View 9 Replies View RelatedI have a Report based on a query in Access and I need it to sort in a different manner and can't seem to make it do that as the item I want to sort is a formula ...
Right now it sorts like this - first on month and year - oldest to newest - which is great.
Second sort is sorting on the reviewer's name which I don't want, I want it to sort on their monthly total - (number they reviewed within that month) with the one with the most reviews first - but that is a formula (see below).
What I have currently:
January 2013 Monthly Total: 7 % of Grand Total 100%
Reviewer 1 2 28.6%
Reviewer 2 4 57.1%
Reviewer 3 1 14.3%
This is what I would like:
January 2013 Monthly Total: 7 % of Grand Total 100%
Reviewer 2 4 57.1%
Reviewer 1 2 28.6%
Reviewer 3 1 14.3%
The formula is in the Reviewer Name Header and looks like this:
Reviewer Full Name =Count([Review Date]) =Count([Review Date])/[AccessTotalsReview Date1]
I want to make an unbound form that has the functionality like the form found in access for reports wizard.
I want the user to be able to select the sort order dynamically for a report instead of a fixed sort order. But i'am unable to sort out my own problem :mad:
plz check out the functionality of this form by opening in your access.
When the first combo is empty all the other combo boxes are disabled.
Entering something in the top combo enables the combo below it.
If we delete something in the top combo when something is already existing in the combo beolw it, the values of the bottom combo boxes are shifted to the upeer combos and the lower combos are disabled.
i have also attached the picture for refference.
Ok Second issue: I have a list of companies that each offer 5 different programs. Eash Listing in the query (My report is built on this) has both a column for the definition and a colum with a number idenitfying the amount of people in the program.
What I need is to HIRE someone, but maybe I can do this:
I want to list each company and all 5 programs associated with that company; easy and its done.
Then I want to have a summary at the bottom of the report that goes to each company, takes the 5 programs for maybe 1, maybe 3 or maybe 92 companies, and lists them in order. Order = the top 5 programs for all the different companies. See and it gets complicated because sometimes, a program can be the largest for every company in the report, and then the second program for each company is different for each each company. So I need to arrange the programs in an order. then sort them by size, and them only show the top 5.
PLEASE, if you got through this far of my irrational and illogical brain then maybe you can help
Thanks Sean
What I wish to achieve is to create a report that groups and sorts without the need of a header section as it is taking up to much space cascading :
----
----
----
----
----
----
rather than :
---- ---- ---- ----
----
----
---- ---- ----
----
----
I basically want it not to cascade but do the exact same thing as it does inside its own header. (We need to dramatically cut down the page amount as a delivery schedule is printed out daily and could do with the page count around 10 rather than 50 ).
(Links below)
What It Looks Like ....
What I Want ....
I have a query where I ORDER BY ClientId, MatterId and Transdate. The result of the query is correct. All of the transdates are in ASC order within the Matter.
When I run the report for a MatterId the relative transactions are not sorted on transdate
Can there be something in the report that could be effecting the order of the transactions.
How can I change report Sorting and Grouping through code? I tried:
Dim rpt As Report
Dim strReportName As String
strReportName = "ReportName"
[Code].....
But this did not work. I assume because it is on the Open command for the report. I think I might have to place some Event Procedure in the Group Header - On Format or On Print? However, I can not find the right syntax to do that.
I have 3 fields Yes/No.
A B C
To be in order it is necessary that: A , B and C = Yes.
I would want to print all different combinations :
A = no et B et C = Yes
Then
A: Missing
Nom, prenom et adresse.
.....
.....
A = Yes, B=No and C = No
Then
B and C missing :
Nom, prenom et adresse.
......
.......
Etc.....
i intially, I wish to have attendance stats for 3 groups of people over 2 days in a report
i have the two queries for the raw data, but wish to combine into a report that will ultimately become a "dashboard" report for half a dozen queries., and can only get one or the other to work do i need to combine the queries into a summary query of sorts?
Access 2010. I have a table with the following fields:
- From
- To
- TypeOfWork (to be chosen from a combo-box)
- Activity (text field to be filled in freely)
In a table i have a complete day with times (from -> to), the type of work between those times and the activity performed between those times a bit like this:
FROM TO TYPE OF WORK ACTIVITY
00:00 - 11:00 Welding Welding clamps
11:00 - 13:00 Welding Welding anodes
13:00 - 15:00 Cleaning Cleaning pipes
15:00 - 18:00 Cleaning Cleaning floor
I would like it to show in the report like this:
FROM.....TO.......TYPE OF WORK.....ACTIVITY
00:00 - 13:00......Welding............00:00 Welding clamps
...............................................11: 00 Welding anodes
13:00 - 18:00......Cleaning...........13:00 Cleaning pipes
...............................................15: 00 Cleaning floor
So it should sort on "From", then group by "TypeofWork" and repeat the "From" field(I think...). But I now have tried every combination of sorting and grouping I could think of and nothing works!
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.
I'm trying to make a report that a untrained user can use to review the relevant data from the database I'm creating. All of the work I've done so far has been directly in the tables . Here's a quick outline of my general data organization:
Department:
DepartmentID(PK)
DepartmentName
Employee:
EmployeeID(PK)
EmployeeName
DepartmentID(FK)
Needs_Work (check box)
[code]....
Basically, I want the user to select a department to view using a combo box or option group (which I'm not sure of how to do in a report). Then, I want to view the employees within that department sorted first by whether or not the Needs_Work check box is selected, and then by how many of their competencies are unchecked.
i have a date field where about 80% of the data is entered in the format dd/mm/yyyy but the rest may be year only since the exact date is not known. Therefore, it does not have an input mask or a format set. Is it still possible to sort on that field? (As i write this i realise it is probably a dumb question but always worth a shot!)
View 3 Replies View RelatedI have a table that i would like to sort the records in one field Ascending.
I would like for the field to be updated after the record is entered so that the records in the field are all ways in a alphanumerical order.
I have put [SSB-CW].Square in the Order BY properties of the table. The Table is called SSB-CW and the field to sort is called Square. As i enter the records they stay in the order entered. When the table has been closed and then re-opened the records are sorted.
Do i need to design a form and set the lost focus property with the SQL [SSB-CW].Square.
I have a text field in a table that contains an alphanumeric code. i.e.
DEL998
DEL999
DEL1000
DEL1001
SUN998
SUN999
SUN1000
SUN1001
SUN1002
etc.
I want to run a query to find the highest number for a particular alpha code. In the example for DEL I would want the query to return DEL1001.
I have created a select query that asks for the alpha code, selects all codes starting with that code, sorts them in decending order and only displays the first record.
The problem is that because the field is a text field the numeric is not sorted like a number. So in the DEL case the query returns DEL999.
Any ideas on how I can get a result of DEL1001??
Thanks for your help
I have a query that pulls info from a table. One of my fields is frequency and in that field i have weekly, annually, daily, etc.
How can I make the query sort starting at the daily one and move out to annually?
I have this form for data entry. I want to sort a field in a certain way which is neither ascending nor descending. The items in this field should be ordered as say, C, A, D, B. What I want is a custom order. How can we do it?
The field I am referring to is not on this form, but in the underlying table.
I am thinking of a VB code to achieve this purpose, where I can define the order. But not sure how to do it.
I have a table that stores data adn one of the fiels values is direction x or y so we have
|field 1|field 2|field 3|direction|field 4|
For example
Direction x and y will be different records in the parent table
And I want to arrange my data on a form as so
| direction x | direction y |
|field1|field2|field3|field1|field2|field3|
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)
I have created a lookup in a field in a table:
select id, bike from tblbikes.
Column count 2
Width 0,3
When I try to sort the table by bike:
I receive the following error: Type mismatch in expression.
Is there some way to sort a field with a lookup.
I have a field on a table that is a DateTime format and it needs to be that way. I am trying to query that table for all the dates to use in a combobox but I only wat the date not the time. The problem is when I format the field to just date I can't sort it anymore as a date and I can't group them. I still get multiple lines in my combobox because there multiple times for the same day. what is the proper way in a query to extract just the date from a field and still sort it as date ie 1/12/2015 is greater than 12/15/2014?
View 8 Replies View Related