Search results for query: *

Duane, Awesome!! Thank you, works like a charm....

My database contains inspection data for inspections done on food facilities in the area. My task is to build a report that will show: FacilityID, InspectorID, Last InspectionDate. The following sql works, but when I add the InspectorID, it no longer shows the last inspection date, but all...

I have a combo box that pulls information from a table. The table (FDAcode) lists over 400 FDA food codes. Codes are set up with the first 2 digits defining which part of the code it refers to. So you may have codes IE: 22-601.13; 31-401.23; 11-101.423 So in this example the 22 & 31 & 11...

Awesome! I guess I should 'read' what is relayed! Report Footer Works! Thank you Duane for your continued help! Have a great day!

Yes, but that doesn't work. Strangely, when adding questionnaire to page footer, it overlays on page 1 (invoice) I tried adding it as a subreport also and that results in multiple blank pages with only the header showing. :(

I designed a report that invoices food facilities license fees. The invoice is designed with page header/footer Business Name Group header and a Billing date header/footer and Detail section. All works great. However, I would like to add a second page that would be a questionnaire. How would...

Hi Andy I think the 'force' idea is what I need and it appears to be working. Thanks again for all you help!!!

Hi Andy! This is my issue: The Fee Table has 100+ different fees. The specific feeID that I want to populate the FeeID field is: 111 How do I accomplish that? If I put "111" in the criteria line, then it will only append records to records that has had existing FeeID 111 in the records...

Good Morning Andy! I like your suggestions as it makes the sql easier to read. However, when I use your format, access reverts it back.🤷‍♀️ I am now attempting to use the same append query to append invoices for all "Priority 1" facilities. The query we now have works only if the facility...

Results: FacilityID = 14 LicenseID = 13 Priority = 1 Status = Active FeeID = 111 It returned the one record !!!! I think the "DISTINCT" wording did it! Thank you again! You are a life saver 😊

Hi Andy! The 2022 invoice does not yet exist in the table. I want to use an append query to add the 2022 invoice. The end result I want to add a 2022 invoice to all existing facilities using the append query.

My Select Query reads: SELECT Food.FacilityID, License.LicenseID, Food.Priority, Food.Status, Fees.FeeID FROM Fees RIGHT JOIN ((Food INNER JOIN License ON Food.FacilityID = License.FacilityID) INNER JOIN Invoice ON Food.FacilityID = Invoice.FacilityLUID) ON Fees.FeeID = Invoice.FeeID WHERE...

THANK YOU SO MUCH ANDY !!!! I got it to work 😊

😊 Thanks Andy! Ok, I think we are getting somewhere. I now have this: INSERT INTO Invoice ( FacilityID, FeeID ) SELECT Qry_InvoiceAuto.Food.FacilityID, Qry_InvoiceAuto.[Fees.FeeID] FROM Qry_InvoiceAuto INNER JOIN Fees ON Qry_InvoiceAuto.[Invoice.FeeID]=Fees.FeeID WHERE (((Fees.FeeID)="19")...

Thank you Andy Yes, the invoiceID is a primary key This is what I have now: INSERT INTO Invoice ( FacilityID, FeeID ) SELECT Qry_InvoiceAuto.Food.FacilityID, Qry_InvoiceAuto.FeeID FROM Qry_InvoiceAuto WHERE (((Qry_InvoiceAuto.Status)="Active") AND ((Qry_InvoiceAuto.Priority)="1")); This...

Currently we are manually entering annual invoices for 300+ food licenses. The invoice is using 3 different tables: 1) Food: with fields FacilityID; Priority; Status (Priority dictates the risk factor and fee level) 2) Invoice Table: InvoiceID; FacilityID, Billing Date; FeeID 3) Fees...

I have a client DB that records visits. I would like to add a field in the table that will count the actual number of visits a client has in their history. I'd like it in the table so that the field can be used effortlessly in a form, report or query. If I use the count function in query it...

Thank you again Duane! Got it to work.

Duane, yes it is a single form. I am open to any other solution, as my goal is to make this check box obvious (if marked) to the user so that it is not overlooked.

Andy, no message box popped up