Search results

Nevermind, I figured it out. In case anyone's interested, I basically created one report with one subform based on the Job Table Query and one subreport based on a third query that created a list of all duplicated jobs. I had a time working out the correct parent/child relationships. I used...

Here's the situation: Card Table and Job Table have a many-to-many relationship with a junction table that ties the two primary keys together. The way this is set up is, I have a form that selects the Card with a checkbox. "Card Table Query" (based on the Card Table) lists all selected...

Pat, (or whoever else wants to answer this) I have a similar issue and took your advice about building the seperate query and subreport. This works. But, I want to hide only certain fields of my query if the record is duplicated. example query return: job #2 - 12 - 13 - 14 job #2 - 12 - 13...

I have a report that will show duplicate values due to a many-to-many relationship between my tables. This report will return duplicate job and job hours for different card numbers. example: card #1= job #2 - 12hours - 16hours - 10hours job #3 - 9hours - 2hours - 14hours Card #2= job #3 -...

Thanks for the reply Pat! After putting my theory into place, it did NOT work as I intended. I'm not sure I understand your answer though. Could you elaborate? Thanks!

Disregard.... I figured it out. I just made 3 queries in which the third showed unique job #'s.

Well the formatting of my tables didn't work out. I hope you can make sense of it anyway.

I'm currently building a monster database that requires a massively intricate reporting structure. I've hit a brick wall with a report that I need to create. I'll explain.. I have a table that includes this type of structure: selected card # bfl access restore planning...

Thanks for the reply Pat. Do you think you may be able to show me an example of what you're talking about? I can't visualise it. Thanks alot!

Ok...I've been an avid reader of this forum for over a year. I've learned ALOT from all of you guys/gals. Now, I'm stumped and I hope someone can help me. I've been tasked with creating a "new business database" that will allow for users to select an "aircraft type" and then create and...