Search results

How do you keep a text box from breaking across 2 pages? Thanks Kurt

Im creating a where used report (see attached) and i would like to add a few details to the end of the report. PART NO. TOTAL: I would like to add a count of the different part numbers(far left column). The total right now should be about 514 but when i create a text box with the string...

The 2 queries I posted are being used for the report that was shown. I am grouping by the part number. Kurt

I just attempted making the same report with just the part numbers < 201010001 and the report came up blank.

Im trying to create a where used report that shows the part number, the assemblies its used in, and a total of the places used. When i open the report the first half of the data from the queries is missing. Attached are 2 screen captures. Queries shows the top of the 2 queries i used to...

Im creating a report that is based off of 2 queries. where_used_tbl - This query contains the following 3 fields: Part No. Assembly No. Assembly Description. where_used_count - This is a count query that contains 2 fields: Part No. count of where_used_tbl This query shows me how many...

1 - No, each board can ONLY be in one module. For the next 2 questions what are you refering to as a project? I will assume you mean the printed circuit board. 2 - Yes, an engineer can be (and is) responisible for more than one board. 3 - No, the modules are the top level assemblies that...

Im setting up a database that contains information about printed circuit boards that are being developed for our current project. The information that i need includes the following: Board # - 3 digit number Board Name - Module # - 9-digit number Module Name - Project Leader - engineer...

Ok looks like im almost there. Now i have a query that displays the part numbers, and how many different assemblies its used in. Now would i get it to show me which assemblies each part is in, and in just one field per entry?

I want Total to be the total of how many different assemblies that part appears in. I do have dupilcate records in that where used table that you helped me make using the append query (turned out to be only abotu 850 entries, so no where close to worst case). Basically my where used table now...

My end result i want something like with 3 columns: Part No Assemblies Total Will a crosstab do this? It sounds a lot like what i have now where i have a column for every assembly and there is a Yes where the part number is in the assembly, looks like a crossword puzzle kinda. A LOT of...

Ok im not sure about the options that are available when i select crosstab

Wow didnt know i could do this haha. So say tomorrow i add a handful of new components. Would i have to do the same thing as above?

heres the problem. Fields that i have created indicating where the parts are used are yes/no. example: Part number - 001003021 is used in assemblies 378, and 379. The check boxes under those assemblies are checked the other fields 376 through 411 are left unchecked. After looking into what...

Heres the problem... I dont know how to do any of that. And im worried about the data entry aspect. Right now i have over 500components and growing as well as 20 assemblies and grown. Worst case that means i would have 100,000 entries in my whereused table. That scares me a bit, ok a lot a bit.

Makes sense, but another questing arises. So whenever i add a new part i not only have to add it and its information to the parts table but i also have to list it in the PartsAreUsedHere Table? So is there an easy way to do this? Say some kinda of macro or something that pops up and all the...

First off i apologize if something like what im about to ask has been discussed arleady, im not sure what exactly im looking for to know what to search. I would like to make a "where used" report. Im starting with a query of my tables that has a column titled "Part Number" that lists abotu 500...

Is there a way to track changes in reports? I need to come up with some way to show our document control people what has changed in my report since the last time i submitted it? I was thinking it would be nice if there was some way to mark an item as new and have it appear red. Is this...

I like a challenge :-D

I like how i can create queries to include only the information i want and then created a nice formated report for distribution in access. Ive done a ton of work in excel but i dont recall it having the ability to do any of that.