Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. monkeysee

    Max Date Qry

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

    Max Date Qry

    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...
  3. monkeysee

    Combo Box - Limit results

    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...
  4. monkeysee

    Muti Page Report

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

    Muti Page Report

    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. :(
  6. monkeysee

    Muti Page Report

    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...
  7. monkeysee

    Select Query for append query

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

    Select Query for append query

    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...
  9. monkeysee

    Select Query for append query

    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...
  10. monkeysee

    Select Query for append query

    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 😊
  11. monkeysee

    Select Query for append query

    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.
  12. monkeysee

    Select Query for 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...
  13. monkeysee

    Automatic Invoicing in Access

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

    Automatic Invoicing in Access

    😊 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")...
  15. monkeysee

    Automatic Invoicing in Access

    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...
  16. monkeysee

    Automatic Invoicing in Access

    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...
  17. monkeysee

    Field to count specific records

    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...
  18. monkeysee

    Yes and No Check Box - Highlight when checked

    Thank you again Duane! Got it to work.
  19. monkeysee

    Yes and No Check Box - Highlight when checked

    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.
  20. monkeysee

    Yes and No Check Box - Highlight when checked

    Andy, no message box popped up

Part and Inventory Search

Back
Top