Recent content by MikeVac

Sorry, I thought I was by adding the attachment. Thanks anyway

I added the attachment as a pdfhttp://www.mediafire.com/?l0i8ovpu0oetl3c

I have added an attachment with screen shots. Thankshttp://www.mediafire.com/?d8q3at61qnivaqh

The 2 tables are joined by an Id # which is not used in the report. Table 1 has a value of 500 for example. In table 2 there is one or more records with a value of 500. For every ID # in table 1 there is at least one record in table 2 with that ID #. The select must bring back records where A...

Hopefully this will clarify - sorry for the confusion. Table 1 and Table 2 are linked (1 to many) by an ID field. I want to bring back records where a column in Table 2 called AssignedTo has at least 1 record = A. If there is an A value then bring back all the records = A and startswith A-...

Getting closer - right now it is just bringing back values = "A" where is says {table1.ID}in your group selection should this be the field I am grouping on? - which is table2.col

I have attached a file which should help explain further. I am going to be grouping by table2.col. I am using a couple fields from table1 and the rest will be from table2. Please see attachment. Thanks for you helphttp://www.mediafire.com/?pjyl7w65vv8u3lw

The first time I tried to upload file, I thought it would take it from my C drive and upload it. Now media fire is at 0% (file is 66K) I did try your suggestion but getting error message - "there must be a group that matches this field" Thanks

Trying to upload attachment throught media fire. I am trying to bring back rows in table 2 that = A. If no rows contain A then nothing comes back, if 1 or more rows = A then bring back those rows and also bring back rows that start with A- If I can upload this attachment it will be more clear...

Sending attachment

I will add an attachment showing more details - I may not be able to add it today. Thanks

It can only bring back rows containing A- if there is a row = A. I want it to bring back 'A' and 'A-*' only if there is a row = 'A' or only 'A' if no 'A-* exists. Thanks

What I should have said is have another table 1 created based on the matching id from table 2 where column x = A. Thanks

Yes Tables 1 and 2 are linked on another field. I was thinking to have new table created to be the same as 2 but only have the rows where column x = A I have to bring back rows where A must exist in column X and if it exists bring back rows that contain A and starts with A-. I don't want to...

still not getting results I need. To explain further - one idea I had was to have a new table created (3) based on a join between tables 1 and 2 where column X in table 2 = A Then I could query that table for rows that = A or startswith A-. There are also values AB, AC, etc that I want to...