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: *

  • Users: 4304
  • Order by date
  1. 4304

    Multiple Tables used to populate information on one Report

    Here is what I have in the item number field: =[Forms]![Invoice Recap Form]![Item Number] = #Name? Here is what I have in the Vendor field: =Forms![Invoice Log]!Vendor = Red Man Pipe & Supply I'm not sure what I am doing wrong. I also just noticed that it is only giving me information from...
  2. 4304

    Multiple Tables used to populate information on one Report

    You got it so far, but I am just a tad bit ahead of you, I already have everything setup. I have the report made and the text boxes all laid out with the correct "formulas" already in them. It's just for some reason, instead of the information I need, I am getting #Name?.
  3. 4304

    Multiple Tables used to populate information on one Report

    The primary key is the PO # in each table. I have relationships by PO # with the PO log and the Invoice Log - indeterminate (whatever that means), by PO # with the PO Log and the Invoice Recap Table - indeterminate, by PO # with the Invoice Log and the Invoice Recap Table. I have the query...
  4. 4304

    Multiple Tables used to populate information on one Report

    Okay, Item Number - Invoice Recap Table Client WO Number - Invoice Log Client PO Number - Invoice Log Vendor - Invoice Log MR Title - PO Log Invoice Number - Invoice Recap Table Date - Invoice Recap Table Quantity - Invoice Recap Table Taxes - Invoice Log Freight - Invoice Log Invoice Amount -...
  5. 4304

    Multiple Tables used to populate information on one Report

    1) OK, can you list the fields from each table that you need in the query, including duplicates? Item Number Client WO Number Client PO Number Vendor MR Title Invoice Number Date Quantity Taxes Freight Invoice Amount PO Total There aren't any duplicate fields. 2) When you say there are 19...
  6. 4304

    Multiple Tables used to populate information on one Report

    Several items under one heading" - I have a field named Item Numbers - there are 19 different Item Numbers and I need them all to show up on my report. The query is set up as follows: Item # WO # PO # Vendor MR Title Inv # etc... Reca tbl Inv log Inv log Inv log PO log Reca...
  7. 4304

    Multiple Tables used to populate information on one Report

    I currently have 3 tables that contain several of the same fields, but also several different fields. I have the relationships linked to the main "item". I have a report that needs to list several different items under one heading, but the only results I am getting is "Name?". I have the...
  8. 4304

    Formatting of Report in Access

    Next time, it would help to state upfront that you tried the obvious solution so no one wasted their time replying with something that would not work. Also, it would have helped to understand that your controls might grow vertically." My apologies. I actually did not try it until you told me...
  9. 4304

    Formatting of Report in Access

    Thanks for your advice. I did try this option, but since the information is so different in size and length, it gave me several different "squares" with gaps and they are very inconsistent. I was looking for more of a table type format.
  10. 4304

    Formatting of Report in Access

    I have a report that contains several columns and rows of information. Is there a way to have the columns and rows seperated by a single line, similar to an excel spreadsheet when gridlines are printed?
  11. 4304

    Field in Table will not populate

    No, my apologies. I have a DLookUp field in a form that populates a table. However, that field is the only field that does not show up. The formula that I have is in a text box and is as follows: =DLookUp("[Suppliers]","[Supplier Table]","[Supplier ID]= " & """" & [Supplier ID] & """")Sort Order
  12. 4304

    Field in Table will not populate

    My DLookUp field will not populate the field in my table or on my report. For example: My field is called Suppliers and it looks up the Supplier Name by Supplier ID. My table has a field called Suppliers, but the information that is "looked up" does not fill in the fields in my table, nor on...
  13. 4304

    DLookUp field not showing up on report...

    Thanks for your FAQ, however it didn't answer my question.
  14. 4304

    DLookUp field not showing up on report...

    My DLookUp field will not populate the field in my table or on my report. For example: My field is called Suppliers and it looks up the Supplier Name by Supplier ID. My table has a field called Suppliers, but the information that is "looked up" does not fill in the fields in my table, nor on...
  15. 4304

    DLookUp field not showing up on report...

    HELP!!! I have a field in my form that looks up data from a different table. That form will not show up in my table or on my report. Can anyone help me with this?
  16. 4304

    Need table to update field

    YOU ARE SO AWESOME!!! That was the problem all along. I had the table named tblMaterial Category Codes and Lookup, thinking the "tbl" was telling access that it was a table. Well, I took out the tbl and it is working perfectly! Thank you, Thank you, Thank you, Thank you!
  17. 4304

    Need table to update field

    It returned the #Error message. Does this mean there's something wrong with my table? Thanks again!
  18. 4304

    Need table to update field

    Okay, I entered the following: =DLookUp("[Material Category Code]","[tblMaterial Category Codes and Lookup]","[MR Suffix]= " & """" & [MR Suffix] & """") And it is giving me the "circular reference" (#Error) error message. I really appreciate you and please, please, please don't give up on...
  19. 4304

    Need table to update field

    You are absolutely correct. The MR Suffix is entered in a different text box, and it gives the Material Category Code its' number. Something like this: MR Suffix Description Material Category Code 02 Valves 04 03 Flanges 99 04 Pipes...
  20. 4304

    Need table to update field

    All of the above is true. I did mispell Category in my textbox name. I corrected that, and am getting the #Error message. My apologies for that mixup. In addition, the "error checker" is stating I have a circular reference. Thank you for your patience with me. Of all the times I've...

Part and Inventory Search

Back
Top