Mean Mode Help Required
Hi,
I found a couple of short threads on the forum discussing the above. None of them go sufficiently far enough into detal to help me solve my (relatively simple) problem.
My boss has asked me to produce both mean and mode calculations for the number of pallets we ship to our branches on the 30+ routes that we service.
So far I have managed to implement mean but mode seems to have me stumped.
I'm aware there actually isn't a mode function in Access as such but like mode, is there a way to calculate the most frequent occurrence of a number over a time period?
My query is already producing Min, Max, Sum (and now mean) results for the pallets we ship, can someone offer me help on this?
All the code that I have retrieved so far seems to be based on something similar to this:
select top 1 with ties your_column
from your_table
group by your_column
order by count(*) desc
I have very little to no idea about how to implement this into my query. Any help would be appreciated.
Thanks In Advance.
sausagefingers
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Safe Mode
Hello all, Has anybody ever encountered this before. I can't seem to get rid of it. When logging in to my Acc 2003 db I get a message along the lines of... "Access failed to start correctly last time. Starting access in safe mode will help isolate a startup problem. Do you want to open in Safe Mode?" When selecting No, it allows me in as normal. This happens everytime I log in now. Even when choosing Yes then exiting the db. Anybody know where to start looking for the solution? Thanks Kempes
View Replies !
View Related
Subform In Add Mode?
I'm having a little trouble implementing this... help would be appreciated. Quite a novice with Access. I have a Client form. I have an "Add Mode", where your able to add new data to the form. This is all fine and dandy. However... The Client has a Shipping Address and a Billing Address. I was hoping of creating a tabular type of dataform; however I'm finding it hard to limit access to a finite number of records. Would this be easier to do with three seperate forms; first putting in the client information, then the billing address information and finally the shipping address information? If yes, how do I call a module?
View Replies !
View Related
Sub Works Only In Step Mode
It's been a while since I've been on the boards. Good to see lots of the same folks are still here. :D I've got an interesting problem. I have a sub that calls another sub. Pretty simple there. The problem is that when sub A calls sub B, sub B does not appear to run. This is all sub B does:If Not IsNull(Me.txtNumber) Then Me.txtNumber = Me.txtNumber + 1 End If The weird thing is, sub B runs just fine if I run the sub B in step mode. If I set a break point and use F8 to step through the code line-by-line, it runs just fine. If I take out the breakpoint, the code no longer works. Anybody have any ideas? I'm running Access XP Sp2 on Windows XP SP1. Thanks.
View Replies !
View Related
Msg Box On Close Only If In Edit Mode
I have a form that is locked unless they click the command button to edit records. I want a msg box that when they click the close button it pops up with something like save edits? Just as an extra precaution. But I only want the message box to pop up if the form is in edit mode. Is this possible? And I would like to be able to have them click ok or cancel in the message box Here is the code for the close button: Private Sub Close_Click() On Error GoTo Err_Close_Click DoCmd.Close Exit_Close_Click: Exit Sub Err_Close_Click: MsgBox Err.Description Resume Exit_Close_Click End Sub Thanks Tracy
View Replies !
View Related
Openning A Form In Add Mode
Hi All, This is such a newbie question I realise, but I have a form (frmFOBEntry) with a combobox (cboMarketCode) which returns a list from tblMarketCode. New records are added to tblMarketCode using a form frmMarketCode When I look through the combobox on the first form if the MarketCode I want is not there I want to be able to click a button which will open frmMarketCode in add mode. Have looked through the forum and found all manner of flash ways to open on to certain records and the like, but nothing that simply opens the form so you can add a new record. Also, if I add a record will the combobox update automatically? Many thanks
View Replies !
View Related
Database Opens In Exclusive Mode Over LAN
I have a database which seems to open many copies when it is accessed over the internet (via ASP) but If I open it on my compter over my LAN then it seems to open 'exclusive' and those on the Internet get the error message that 'file is already in use'. Is there a way of opening the database over the LAN and allowing the Internet to see it?
View Replies !
View Related
Linked Table In Non-exlusive Mode
We have a networked database (using ACCESS 2003) containing: two tables: 1 mdb table (Table A), and 1 linked table to an Excel worksheet. the excel worksheet is set to be SHARED FormA : uses Table A, and the linked table is used in a subform SITUATION : Everything is Ok, if only 1 user opens FormA. If a second user tries to use FormA, an error occurrs that the linked table is already being used and is in exclusive mode. The form will open but the Subform opens empty. QUESTION : What needs to be done in order for the linked table to open in 'Non-exclusive' mode? I'm a newbie to ACCESS, so any help will be greately appreciated. Joel
View Replies !
View Related
Maximized Form Changes To Restore Mode
:confused: I have a db app that has all forms maximized continually (I have set the vba code to do so on Open, Close and GotFocus events). From my app Home Page form the user can browse to other forms in the db. When another form is opened the window automaically maximizes. However, when the user navigates back to the Home Page it goes in restore mode. I haven't told it to do this anywhere. I have also tried saving the form stretched out to fit the full screen, so that if it goes into restore mode it at least still fills the screen, but it still reverts to a restored window (about half the screen). It doesn't matter what configuration I use in the AutoResize, AutoCenter properties either. I have been developing custom db apps in Access for over 8 years. However, this seems to be a stupid (albeit simple) problem that is annoying me. I currently use Access 2003 and this issue is new (or so I believe since I never ran into the problem in previous versions). Any ideas? Thanks...
View Replies !
View Related
Form Mode In Switchboard Question
Have a question on the switchboard choices I've always wondered about. Why are there only "Add" and "Edit" modes to open a form from the switchboard? I see many, many times when you want to allow a form to be opened in "readonly" mode to page through records but not allow edits or additions. Why does Access NOT have "Readonly" as an option?
View Replies !
View Related
Launching A Form In Datasheet Mode
I have a form designed in DS mode. If I open it directly (double click on it on the Panel), it works fine When opening it programmatically (from a button in another form) it shows just ONE record, in spite of having room enough for several records. May I get some help to check what am I doing wrong? thanks
View Replies !
View Related
How Do I Change Data In Property Mode
I have created a form in access 2000. I now want to change the table that this form uses. Normally I would just click the properties tab and then select data, a list of all tables would come up and I would choose the correct table. For some reason I cannot access the data tab. The other four tabs are all availabe, but not the data tab. It is like the data is locked or something. I have clicked on properties on my desktop icon and it is not locked. Please help. Photoone
View Replies !
View Related
Link Two Forms Together On One Field In Add Mode
Hello! I Have a project form test form sample form for 1 project there are n tests and for 1 test there are n samples. The project form is alone and has a button to open the related tests in the test form. The test form incorporates the sample form as a subform. What works: For entries already in the database when I click the related tests button on the project form it opens the test form filtered in the correct manner. For the test form the sample form displays and increments correctly. What doesn't work: When I open the project form in add mode I fill in the data and when it is done I click the related tests button and the linked/child field isn't there! No data, I can't get it to work... Can you suggest something? PS I cannot find anywhere in the Data properties the Linked field properties... neither child nor parent?
View Replies !
View Related
Probability Of MDB Corruption In Single-user Mode
Greetings everyone :) I hope this hasn't been addressed too many times before, I searched for 'corruption' but there were so many results that I could only parse the first few pages. Anyway, I'm developing a C# app for personal use and I was planning on using some MS Access functionality, namely saving and loading data from MDB files. Unfortunately, I've heard a lot of scary stuff regarding Access's tendency to corrupt MDB files. This is really bad news, as I really can't afford to lose any data - information is fed into the application daily, even hourly, and the data isn't stored anywhere else. I could - and will - add some code to back up MDB files on every access, but I'm still curious. Given the circumstances listed below, how likely is Access to corrupt a MDB from time to time ? - I am the sole user of the database. It is never, ever, accessed by more than one user at the same time. There is no networking involved whatsoever. - The database contains only tables and maybe some forms. There are no constraints, stored queries, or any advanced features like that. The forms are never actually used by the program, they're just there to help in editing the database 'manually' should the need arise. - The tables contain only basic data, i.e. INTs, VARCHARs and DATETIMEs. No memos, images or any such stuff. - The database engine / system will not crash in the middle of a writing operation, or if it does, there will be a certified backup available. - There are only two possible operations that the program can perform on the database: either a bulk read on each table, or a complete replacement of all of the records in all tables. There are no selective insertions or deletions. What I want to avoid most is a 'silent' corruption, i.e. Access reports having saved the table successfully, but it has actually corrupted some records. It's not a problem to keep a backup for the duration of a writing operation (to cover the case in which the engine crashes during writing), but if I need to keep it for anything longer than that, the situation becomes rather cumbersome. Well, thanks in advance for any replies :)
View Replies !
View Related
Security / Exclusive Mode/ Compact And Repair
Hi all :) I'm planning to use the "compact on exit" functionality to keep my db's neat. I have understood that I also have to grant "Exclusive mode" to the database object to the users of my db (not to Users group, but my own users group). Does this have a security implication? As I'm running a FE/BE solution, does the compact and repair only do my FE or both. If only the FE, is there a good way of triggering the BE to be C&R as well? (should apply to 2K, XP and 2003) Thanks
View Replies !
View Related
How To: Access 'Query' Screen In Read-only Mode
Hi to all, I would like to ask here for advice on MS Access 2000 application. When a user logs in, he should be able to use the Access 'Query' screen in read-only mode. In other words, he should be able to generate queries by selecting tables and columns, or using the wizard, but the results of those queries may never have any influence on the data in the database. So: SELECT queries only. Users should be allowed to execute those queries, but are not allowed to access the tables, forms, or any other items directly. Is there a way to achieve this? Thank you Ori
View Replies !
View Related
Access Closes In Design Master Mode
I have an application that when in design master shuts down when I attempt to open a certain form. I have traced the problem to a linked field from another table, by creating a new form and ommitting the said field, problem is its a required field! If I copy the database (Backup) and run it as a replica it does not happen, if I then convert the replica to design master it happens. Any suggestions please?? Steve
View Replies !
View Related
Using Option Buttons To Decide Corresponding Search Mode
dear experts, i am a student and i have a project to complete in 2days. i have managed to crawl through access and come up with forms and a functional query set. i need to create a search function for names and addresses. i manged to do a fisrt name search. i need to make an option for users to choose either first or last name and then search for the other details. here is my situation, i need help connecting a radio button to a search form. allow me to illustrate my form. ************************************************** ******* first name : _________ (combo box) last name : _________ (combo box) [0] (option button) [0] (option button) SEARCH ( command button) ************************************************** ******** as of now, the first name combo is connected to the search button via a macro which launches the query with a value from the combo box. how do i make the user choose either option "first/last" and then make the search button search appropriately. please help me. i know this is elementary. i've spent too much time looking for a solution on my own. my time is running out to complete the project. and i've yet to create switch boards and all those other things. please! thanx all.
View Replies !
View Related
|
TRACKER
