Search results for query: *

I've grouped the product id, but I'm still getting the same results. Example: Let's say this is my data... Product Id Cost price Cost price effective date 1 1.00 01/03/2002 1 1.50 10/10/2003 2 5.50 06/18/2003 2 5.75...

Thank you all for your help, however, I am still not getting the results I need. Using the max command is returning only those products and their prices with the most current date - as opposed to returning all products in the data wharehouse and their most current price. Am I doing something...

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

Thank you very much....it worked!

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

Thank you.

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

Thanks Gord. You saved me once again! Jenni

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

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 2. Shirts 4 3. Pants 2 4. Hats 2 Whenever the amount of the last...

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

Just to give you a tip. What Gord said works, the only thing that I had to adjust was instead of "," I had to put a ";". Then it worked. Try this out.

Thank you sooooo much! I have been struggling with this all day. Now I can enjoy my weekend! Your a saint!

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

Garridon,<br>I tried your suggestion out, but it only shrinks the table, instead of automatically moving the data to the right hand side of the page.&nbsp;&nbsp;Thanks anyway.&nbsp;&nbsp;

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

I have &quot;Using Access 97&quot; Second Edition and another Programming in Access 97 handbook and I can't find these tips and tricks in either.&nbsp;&nbsp;Where do you look this stuff up?&nbsp;&nbsp;Can you recommend a better book?&nbsp;&nbsp;I have only been working with Access for about half...

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