Search results

The information was great... All working now. Thanks again.

More info,,,, I want the button to show the invoice for that particular record. I hope I'm not wearing out my welcome but you folks are the experts, Thanks Again.

Changed my 3 tables ID"s to IDCASE, IDCUST, IDEMP (or I think I did) See SQL below. SELECT Cases.ID AS IDCASE, Cases.Customer, Cases.Status, Cases.[INVOICE PD], Cases.[INVOICE PD DTE], Cases.Category, Cases.[Assigned To], Cases.Description, Cases.[Resolved Date], Cases.[Opened Date]...

Thank you so much but now going to show my lack of knowledge. This code makes complete sense to be but not sure where/how to put it in a query. I'm learning and this site is great.

I have a button on a form that I would like to take results to a report. This all works well with a single table but when I have multiple tables with the same ID field name "ID" it does not work. The form with the button on it comes from a query that has three tables on it all having ID as key...

Hi all. I'm a long time Access developer but with that said I know enough to be dangerous. I'm a retired IT manager for a fortune 100 company but started as a programmer and systems designer. After retiring, I took up Access database developing. I really enjoy the problem solving but, at times...