Recent content by jenni

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;