Search results for query: *

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.

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

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...

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

...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...

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

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...

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

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

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...

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...

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.

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]...

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.

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

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.

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.