Recent content by 80proof

Here is the SQL view, sorry I didn't get it up here sooner: SELECT [tblPIPE Deal Database].Date, [tblPIPE Deal Database].Issuer, [tblPIPE Deal Database].Ticker, [tblPIPE Deal Database].[$ Raised], [tblPIPE Deal Database].Structure, [tblPIPE Deal Database].[Shares Outstanding], ([Shares...

I am creating this access database because I had an excel spreadsheet with lots of data and want to be able to manipulate it easier and allow others to manipulate it as well, so i have never worked with access before. The "market cap" field in the query comes from the underlying table using...

Thanks for your help, sorry i left out some important info regarding what the columns relate to. The field i would like an average of is titled "Market Cap" and contains numbers ranging from $50,000 to $20,000,000,000. The fields I would like to count entries greater than, equal to and less...

I have a query and would like to get the average of a few fields in my table. Then I would like to also have this same average minus the best and worst number in the field. Is creating a form the best way to go as far as manipulating data in a query to get certain values? Is it also possible to...

Thank you all for your help, after days of trying to figure this out I found this website and you all were able to help me. Within an hour of posting my question I had enough feedback to fix my problem. The end result which worked for me ended up being: Between Val(LowerLimit) And...

unfortunately adding 'Val' to the code did not help, it still gives me back the same random results. The code: Between [LowerLimit] And [UpperLimit] works fine if i use it in a different column where the underlying info comes directly from the table. I don't know exactly what you mean by...

The number that I am trying to search for values is a currency that stems from an expression consisting of two values from the underlying table: Market Cap: ([Shares Outstanding]*[Closing]) The result is what I am trying to define an UpperLimit and LowerLimit. For the Criteria in my Query I...

I am learning how to use MS Access 2003 and have one column in my data that has standard numbers ranging from 50,000 to 20,000,000,000. When I open the Query I would like a dialog box to open asking for a bottom value and then a second box to open for a top value, i want the result to display...