Search results for query: *

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

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

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

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

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

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

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

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

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.

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?

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

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

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

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

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?

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!

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

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

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

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