Recent content by mkdrep

I'll give what you suggest a try. I do have a date time field in each table, I just didn't show it in my original email as it didn't have anything to do with the duplication issue I had. The notes all relate to one "contact" but one table is for project related notes and the other table is for...

I'll combine the notes into one table.

Actually, I do have dates the notes were made but didn't want to include it in my question as I knew it had nothing to do with my issue. I think I'm just going to combine the tables.

Thank you for your answer. I knew I was multiplying records but I didn't understand why. All I'm trying to do it is keep track of all the call notes we have made for one individual. Unfortunately, I have call notes for an individual in each of the two tables. In essence there are (40) call...

I have (2) tables as shown in (tables.jpg) which have a contact name whose ID number is the same in each table. I have drawn a dotted arrow between each ContactID, which is a FK for [tbl-Contacts].[ContactID]. If I run a separate query using the ContactID # 8311 on one table at a time, my result...

Thanks for the suggestions. I'll monitor this and see if that's the problem

I have a simple query which joins 2 tables by their telephone numbers. If the telephone numbers are the same, it copies the [Architect].[AIA-ID] field in table 2 (which is an AutoNumber field) into the 2nd table, [1Firms-ADD New to Firms On Project].[ArchID] field (which is NOT an AutoNumber...

That estimate numbers i.e. 248168E are assigned by a manufacturer which sends us their estimates using 248168E....I am not creating that number, I'm just entering into my system so I can search the database using their Estimate number

I have a quote program which assigns a master JT# for each project. Each estimate associated with that JT # receives an SL Est #. If a JT# has multiple SL Est #'s associated with it, each SL Est # starts with the same 6 digits (i.e. 248168 in attached .jpg) and then A, B, C, D depending on how...

The attached is what I finally settled on, which gives a much clearer view than the original report. Thank you again for your help.

Sorry for the confusion I caused everyone. That being said, what you are showing above is what I'm trying to accomplish. Thank you!

I don't know how to accomplish your suggestion. I assume I would highlite each field one at a time, but I'm not sure how to use conditional formating to accomplish what I want. Any other info you could give me would be greatly appreciated.

Please see (Zeroes.jpg) of a report I am printing. Each line represents when a product shipped and the quantity of the product on each order. Unfortunately, since each order doesn't include a quantity for each of the (10) products, I get a lot of "0" values in report. However, on relatively...

both the main report and subreport has "keep Together" set to "No". Unfortunately, the issue still remains the same. Ty for your suggestion

thank you for your reply. Perhaps I didn't explain myself properly. The date sort is in the sub report. I'm just trying to stop the report from moving all the notes to the second page of the report when I apparently enter too many notes to stay on the first page. I would have assumed the...