Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. james2308

    Highest Value in Record

    Michael, I can see what this does, tahnk you. However (and I am showing my shallow knowledge here), how do I apply this to my query? Thanks for all the help, i really appreciate it. James.
  2. james2308

    Highest Value in Record

    I have a table with 3 date fields. At least one of them is always filled in, sometimes all of them. In a query, I need to return the single highest value of these fields for each record. Does anyone have any idea how I can do this? It is starting to hurt my brain. Many thanks, James
  3. james2308

    advice required, if possible

    I am not sure if this is the correct forum for this, but i was wondering how much i should expect to pay for a simple access db. I just want a customer one, shoowing what was ordered at each visit, how much each cutsomer spend, when they visited etc. Then reports could be done on how much is...
  4. james2308

    I think I might be going insane.........

    Thank youboth very much. I unchecked the Missing section (Gifsomething or other I think) and it works. Fanatastic. Many thanks again. James.
  5. james2308

    I think I might be going insane.........

    ...well, being driven insane, anyway: I have 2 databases, one on an networked drive shared by my department (P:\), and one on an networked drive shared by the whole company (S:\). In my P Drive Database I have queries which will accept the Date() function, whereas the S Drive Database will...
  6. james2308

    Custom Menus

    Hi there. As far as I knew, the 'Analyze with Excel' option just outputted the form/report data to an xls file anyway. james.
  7. james2308

    Combo box won't remember it was sorted,why?

    In the combo boxes Properties, in Data, go to Row Source and click on the epsilon (...) button to the right. In this query view sort the viewed field ascending. Then click on the Close button at the top right, and confirm that you want to save changes. The combo box should now list its contents...
  8. james2308

    Including Start and End dates in Report Title automatically

    gary, I do this as well, and what i do is have the date request text boxes and report lanuch button on a form. Then, in the report header i put two text boxes, each of which has =[Forms]![frmDateSelect]![Field Name] in its Data/Control Source property. Does that make sense? James
  9. james2308

    Import button .. ..HELP!

    Tinymind, Does the: DoCmd.RunCommand acCmdImport do what you want it to? James.
  10. james2308

    Input mask on enter and view

    I don't know if this is any good to you, but if you set up your input mask in your table, then build your input form, and put a space inbetween the 3rd and 4th chars in the input mask propery of the form, this should look like it has the gap in the form, but should still store the input in the...
  11. james2308

    How do I create a Command button?

    There is a Form Wizard option which runs the actual Filter by Form. If you want to actually open up the screen where you input the filter criteria, this should do that when put into the OnClick event of a button: DoCmd.RunCommand acCmdFilterByForm Or have i misunderstood the question (a fairly...
  12. james2308

    Calculating Geometric Mean in Access

    Terry, thanks. This is why I learnt to make sure users write down EXACTLY what they want before i start their Access/excel project! It is really easy to lose the overall direction when you are dealing with the minutae. I liek the ones with no calculations best! James.
  13. james2308

    Calculating Geometric Mean in Access

    This is what i came up with. It doesn't seem as impressive as the stuff from Terry, and it is probabaly wrong, but here we go anyway! SELECT tblFigures.ItemID, tblFigures.ItemName, tblFigures.[1stFigure], tblFigures.[2ndFigure], tblFigures.[3rdFigure], tblFigures.[4thFigure]...
  14. james2308

    Totals Query - Report Help

    If you input these dates from a form, which then launches the report, you can put 2 text boxes in the report header, and then make them look at the fields on the form. James.
  15. james2308

    Calculating Geometric Mean in Access

    Terry, How do I do that? I'm new to this site, clearly! James
  16. james2308

    Calculating Geometric Mean in Access

    I have had a look at this, and to actually calculate the Geometric Mean isn't too difficult. The figures it comes out with look pretty weord though! If you would like me to send you my example, please just let me know. James.
  17. james2308

    Calculating Geometric Mean in Access

    What exactly is the geometric mean? If it is a calculation, i am sure it can be recreated if it is not a standard function. Jay.

Part and Inventory Search

Back
Top