Search results for query: *

In our data wharehouse, each product has a price with an effective date. If I want to pull the most current price for all products, how do I write the query in impromtu? Each product may have had a price change at different periods in time (even various years). How is it possible to...

Table A has a column with a 10 digit number, Table B has the begining six of that 10 digit number... I want to run a query based on the six digits pulling out all that are similiar in 10 digit form from Table A...can I join those fields somehow? I have no other field where I could join the...

I am trying to keep groups together per page. I have got a query which sorts different names to a particular location. I would like to make sure that all names listed under a location remain on the same page. So, can Access recognize where a group ends and if it doesn't fit at the bottom of...

I have been using this Top feature, but the problem is that if I choose top 10, and the values in the 10th and 11th place are the same, the list returns Top 11. For example: Top 3 products sold 1. Boots 5...

When I create a Report which is in the form of a Hit list, I use the command "=1" to show the position of the data in the Hit list ( i.e. Hit list most damaged products: query sorts damages descending, report displays info with text box =1, which shows what damage has position nr. 1...

I have a query which counts certain fields per a given criteria. When nothing is found, I recieve an empty field, or a Null field. I would like that it returns a zero in this case. I have read many of the threads which exist on this topic and looked up info in handbooks. It seems that this...

When you have a table in Excel, that only has two or three columns width, but extends over 90 some pages...and only<br>uses up the left hand side of the page, can Excel continue the table first on the right hand side before it moves to the next page? I don't want to cut and past 90 some...

My boss is willing to send me to a trainings seminar, so that I can enhance my capabilities in Access.&nbsp;&nbsp;I posted a question titled &quot;Top Select&quot; and cornerstone responded with an expression....dim getsql as string....etc.&nbsp;&nbsp;Is this SQL?&nbsp;&nbsp;Can you use SQL for...

I would like to thank cornerstone and samara for their help.&nbsp;&nbsp;Unfortunately, like will5, it didn't work.&nbsp;&nbsp;Is there maybe something simple that I am forgetting?<br><br>I have &quot;Using Access 97&quot; Second Edition and another Programming in Access 97 handbook and I can't...

When you have a table in Excel, that only has two or three columns width, but extends over 90 some pages...and only uses up the left hand side of the page, can Excel continue the table first on the right hand side before it moves to the next page? I don't want to cut and past 90 some...

in the query design mode,i have the ability to display either the top xx lines of my result, or the top x percent.&nbsp;&nbsp;How can I control this feature over a form?<br><br>My goal is to allow my colleages to create Hitlists over User-friendly forms (because not all of them are capable of...