I want to sort my query results by VendorNumber (which is an AutoNumber won't be sequential due to deletions). I want to sort the query by what vendor number the current form is on. So if my vendor numbers are 1, 2, 14, 16, 17 and the vendor number on the form is 14, I want the query to be sorted with the Items from vendor 14 first then 16, 17, 1, 2.
Your time is appreciated,
JOe K.
Below is a script that I want to present in descending order but it is coming up with the error:
Microsoft VBScript runtime error '800a000d'
Type mismatch
/tribute2.asp, line 175
Could it be that the remid and gbid are in two different tables in the database .... or have I just got the scripting all screwie ... the line where the error is occuring is the first set of code ... the second set of code is the area that it relates to ...
Hi
I am looking for an equivalent for the DESC command in Access.
I need to extract the table definitions: name of each fields (at least).
I know I can print that from the menu in Access, but it's not what I want. (and it does not print the comments section of the fields)
I need to be able to generate some kind of text file cause I need to manipulate the output myself with a Text Editor for documentation purpose.
Is there such a function in Access? Or is there any module that can do that?
Thanks
I have a query that lists items in locations in our warehouse. Each location is broken down by Aisle-Bay-Level-Position, for example 50-101-01B; or 51-106-02 with all the even Bays on one side and Odd bays on the other side of the aisle. I have the query set up so it separates odd and even so I can go all the way down one side of the aisle then I have to walk back to the beginning of the aisle to check the other side.
What I am trying to do is change the sort based on another field that I have called SORT with a value of AZ or ZA depending on if I need that section to be sorted ASC or DESC. So for example all even bays in aisle 51 need to be sorted DESC while all ODD bays would be ASC. The way our warehouse is laid out it is not always the odd or even side that needs to be sorted DESC, that's why I made the SORT field. The formula I used for the SORT field is as follows:
SORT: IIf(([Aisle]='50' And [OE]='ODD') Or ([Aisle]='51' And [OE]='ODD') Or ([Aisle]='53' And [OE]='ODD') Or ([Aisle]='52' And [OE]='EVEN'),'AZ','ZA')
Is there a way to make it sort the BAY in ASC or DESC based on the value in SORT?
As an example here is how I want the order to be:
50-101-01A
50-101-01B
50-103-02A
50-103-02B
51-101-01
[Code] .....
I have a problem when I want to create an "ORDER" form, that will allow user to enter more than one order.
I have no clue how to do it.
Good morning,
I have a table ID (primary key) and
ID
--
FEASSDDE
RDSAAASE
NEESSDSD
AEIERIEIEE
and I want to do a select of these values, order by ID ASC, and see the position of each one in this order, something like this:
POS ID
--------------------
1 AEIERIEIEE
2 FEASSDDE
3 NEESSDSD
4 RDSAAASE
I have a startup form with three buttons. All three buttons have Tab Stop set to No. However, when I open the form, there is a highlighted box around what would have been the first button set in the tab order had Tab Stop been set to Yes. Is there a way to not display the light green box around the text in the button?
Thanks,
SKK
My tab order is the way I want it and when the user enters after the last field on the form, they get a new record. Problem is, the cursor is putting them in the last field on the form instead of the first one. I don't get it. The first field is first on the tab order list. Help.
View 1 Replies View RelatedI have a form (Members of the club), linked to a sub form (payments of membership).
When I open the record of Mr John, I want to see all his payments order by date of payment.
How do I do?
Thanks in advance,
Jackske - Belgium
:confused:
I have a query which i've ordered by date with:
ORDER BY status_reports.date;
But I want it to display in reverse order with most recent date first for example i want it in order of 18/sept/05 then 15/sept/05 then 10/sept/05.
im guessing i just need to add to the above SQL but im not sure what!
Can anyone help please
Thanks
How do you change a file's sort order from ascii to international?
View 3 Replies View RelatedHi, is there any way to do an order by, but specify that a particular value is listed last, or first.
E.g. ORDER BY t_name ASC ... but feature Simon first and not with the other names beginning with 'S'
Thanks.
Hi,
I have a question.
why do we need to order MS Access application when the user request it in the company?
Suppose one user buy MS Access application, then we can install the other workstation, right. But, everytime, we need to order MS Access for that user account/workstation.
In contrast, ms word, ms excel, powerpoint, we don't need to order it, every workstation must have them, except ms access.
Can anybody response me why we need to order ms access for each user account/workstation?
Thanks.
Please help,
I have sorted my table by the primary key as when i open the form that loads fields from the table, i would like the most recent record entered to appear instead of the first record that was entered. The problem i have is when i run the form it still shows the first record even though i have sorted the primary key field in descending order. How do i fix this?
Hi everyone,
On a form, I want to fix the tab order of the text boxes. So I go to the tab order property of the form and when it opens, it doesn't let me change the order. Can anyone help me on this?
Thank you very much
I'm using Access 2003 and a week ago I ran into a very strange problem with one of my tables. The table has 15 fields named Field1, Field2, Field3,....Field15. The weird thing that is happening is if I open the table in design view it will list the fields in order (Field1, Field2, Field3....Field15), but when I open the table in datasheet view Field10 and Field11 get flipped (.....Field8, Field9, Field11, Field10, Field12....). Has anyone every seen this before? I'm guessing it somehow got corrupted. It wouldn't be a real big deal for me to just delete the table and create a new one, but if there is a fix to it then I was wondering if someone could share that with me. Thanks.
View 2 Replies View RelatedHi Folks,
I'm working on an order management database for a small company and have an order details form which I hoped to list each product of the order. As each customer has a different price per product I have a combo (based on a query) to choose the product and display the unit price (working fine) - the quantity and product ID are also input on the form and stored in the order details table (un-tested). My problem is on the first line of the order you choose the product and it and relevant details are shown, however, on line two, three etc when you choose the product - the other lines change to this too. How do I fix this???
Many Thanks in advance for help given!!
Mary
Hello,
I have a database which in one part records customer orders. What I would like to is identify customers who have not ordered for a given time period i.e. 30 days.
I know once I have built the query, I will require a parameter for the time period i.e.30 days.
I started by trying to record the last date ordered for a customer in a query, but am having problems with this. I had a query including information from my table for Orders (tblOrders). This had:
Order ID
Customer Name
Date Order Required
I do not need any more info apart from these fields.
The results would include all orders, so for some customers there would be numerous 'Order ID' & 'Date Order Required'. In the query, I did try to select the summary option, to group information by Customer - but the 'Date Order Required' was always the first date ordered. What I would like is only the last ones for all customers to be shown.
Can someone provide some guidance on how I can achieve my objective.
Thank you.
I have got a number of queries that query an MSSQL database that were running fine, but then I decided to tidy them up by giving them more meaningful column headings eg Pupil ref instead of tblPupil. Some of the queries are still fine but in some of them I can't get the columns to display in the order I want. In one, I have got columns called Round, Pupil ref and School but I can't stop the Pupil ref column coming first. If I delete it and put it in again, I can get it to go where I want (ie second) but as soon as I name it, it comes first and stays there even if I remove the name.
Please can anyone help
Fiona
I have to run a seniority query but have an issue. I have job descriptions but can't put them in ASC order because they wouldn't be by seniority.
For example:
Docker
Docker supervisor
Dock Chief
Shift Supervisor
Section Leader
In SQL I would do a decode function and assign each a number and then put them in order by thier number assigned.
What are my options in Query to perform this function. Thanks.
Hi,
Is there anyway that you can order a query to be descending by an expression in your query rather than an actual field from a table. I am trying to do this but the following message keeps appearing:
The Microsoft Jet database engine does not recognize '[ExpressionName]' as a valid field name or expression.
Any ideas?
Thansk in advance.
Lee:(
Hi
I have a problem with an Order By Clause.
Basically, my database holds records of sites in the UK, and I have a select query (qry_SumGIS3) that opens up a summary report (rptSumGIS3) when a button is clicked on the menu page. The report opens perfectly, showing me all the information I need to know about all the sites in my database. However, it is ignoring the Order By Clause I have specifically told it to do. I want to order the records that appear in the report by a calculated field (OBJ_WS_OVERALL_CALC) in descending order (highest to lowest percentage). Instead, it is ordering it by the site id (RTP_ID). How can I stop it doing this?
This is my code (that was created in the SQL view of the query design):
"SELECT MEASURE1.OBJ_WS_OVERALL_CALC, [Tab 1: Factual].RTP_ID, OBJECTIVES.OBJ_ID, OBJECTIVES.OBJ_NAME, MEASURE1.MEASURE_ID, MEASURE.MEASURE_NAME, MEASURE1.MEASURE_SCORE, MEASURE1.MEASURE_WEIGHT
FROM [Tab 1: Factual] INNER JOIN (OBJECTIVES INNER JOIN (MEASURE1 INNER JOIN MEASURE ON MEASURE1.MEASURE_ID = MEASURE.MEASURE_ID) ON OBJECTIVES.OBJ_ID = MEASURE.OBJ_ID) ON [Tab 1: Factual].RTP_ID = MEASURE1.RTP_ID
ORDER BY MEASURE1.OBJ_WS_OVERALL_CALC;"
The red line is the part of the code that I think is being ignored.
Anyone that can help me is a lifesaver!
Wondering if it is possible to order by particular values??
That is I have a column (varchar) named "Status" with values such as; Entered, Active, Completed etc (I didnt design the DB).
What I need is to order by Entered, then by Active then Completed etc.. Is this possible??
Ive got this code for SQL; but it doesnt work in Access (03)..
ORDER BY
CASE Status
WHEN 'Entered' THEN 0
WHEN 'Active' THEN 1
WHEN 'Completed' THEN 2
ELSE 3 END, Status
Hi everyone,
I am looking for some help with a particular problem. I have a report based on a query and at the moment it is ordered by a particular column.
What I want to be able to happen is that the user chooses what they want the query (and subsequently) the report to be ordered by before they run the report by means of a combo box or something like that.
Is this possible in anyway?
Thanks.
Gareth.
Hi,
I have a form with 2 sub forms and when I tab through the first form (the container) and get to the last record, the cursor pops into the first sub form which is just what I want, however when I then get to the bottom of the first sub form and tab to the next sub form but it doesn't work, what does happen is that the cursor goes back to the begining of the first sub form.
I have been testing various combinations of the cycle option but none of these got it working and I've gone through the tab stop / tab index and everything looks ok there.
I can move from the first sub form to the second by pressing ctrl + tab but was wondering if there's a work around so only the tab has to be pressed?
Thanks
The fields on my form are not in the same order as in the table. When putting new data in the form and moving from field to field by TAB key, the cursor would jump from the field to field in the order of fields in the table. How do I change it so the cursor moves from field to field in the forms format.
Thanks in advance,
John