Recent content by pachad

Using the code below, I am trying to get the latest facility info for each facility, based on user input. The facility detail table stores the info, and only has rows for when data changes i.e.: FACILITYCODE MONTHNO YEARNO RATE PLANT_A 1 2006 100 PLANT_A...

That's what I am looking for. I know similar capability exists when printing Excel spreadsheets that overlap multiple pages...

FYI, You can set the default printer used for a report in the Page Setup dialog. Also try PDF Creator on sourceforge: http://sourceforge.net/projects/pdfcreator/

Thank you for the quick response. I was hoping for an automatic way of doing this similar to the page break control for horizontal breaks. Does such a thing exist?

Th only method that I am aware of is setting the left and right margins as well as the report width. So I have to know the page size, and manaually set the columns on a new page?

I have a report with many fields: |-----| A | B | C | .... | xyz | 1 | 2 | 1 | .... | wxy | 4 | 4 | 3 | .... etc. Question: Is there a way I can have access automatically insert a page break between column B and column C? The page break control in access seems to allow...

As you only have one value for each PlantID,ProductID pair you may use the First (or Min, Max, Last, ...) aggregate function on ItemCount Once I added in the Year field, I now have more than one value for a PlantID, ProductID pair, and using the Crosstab gives the SUM for ALL of those rows.

CrossTab only allows me to do aggregate functions. I added a new field to the new table called year, and want to show actual counts broked down by year. Report would look the same, but would have Year set to 20XX in the Record Source query. I tried using grouping, but that gives me this...

Followup question: How do I re-assemble the original data for a report from the new table? The report looks like the orginal table: |---------| Cars | SUV | Trucks | | Plant A | 4 | 5 | 6 | | Plant B | 3 | 4 | 2 | Thanks

Great. Thanks for the quick response.

PH, Your idea worked great, and I still need to do more research on INNER JOIN. I tried the code below, and it also seemed to work (your use of AS keyed me to it). Will this work the same as your solution, since it uses WHERE and IN which I am more familier with. Thanks. SELECT A.Plant...

I have the following info in a table: |---------| Year | Rate | | Plant A | 2005 | 5.00 | | Plant A | 2006 | 4.00 | | Plant B | 2005 | 3.50 | Not every plant has its rate information changed every year. What query can I use to ensure I always get the most current...

Perfect! Thanks for the quick response. Note to users: In access, to create a UNION query see this link: www.ehow.com/how_13580_create-sql-query.html Then create a separate append or create table query to insert the data into the required table.

Hello all. I currently have the following table: |---------| Cars | SUV | Trucks | | Plant A | 4 | 5 | 6 | | Plant B | 3 | 4 | 2 | I would like to convert this to the following, with PlantID and ProductID as the primary keys. A separate table would contain PlantID and...

No, no and nope. Thanks all, but I guess I'll have to just redo the wizard. I also tried deleting the dependancy from the dependancy window, but i could not delete from there. Thanks again.