Recent content by jwrocko

Thanks GingerR - it works exactly like I want.

I want to be able to populate a form field using a query. The fields on the form are: Part Number, Quantity, and Vendor ID. My form, on click, will check to see if I have multiple vendors available for the specified part number. If there is only one, I want the field to be populated with the...

I have a query that produces the desired results, but I need to be able to edit the results. So, the query is form resource. SELECT Parts.Part_Number, Parts.Component, Part_Detail.Manufacture_From, Part_Detail.Manufacturer, Part_Detail.Vendor_Part_Number, Parts.[Tracked?], Part_Detail.Vendor...

The problem I am having is that when one query does not return any results...it does just that - not return any results. That means that it does not provide my drawing-specific information (drawing_number, _title, _description, additional_info). So, this results in one "side" of the report...

yes. what I need now is to retain each BOM's number and information - drawing_number, drawing_title, drawing_description and additional description.

SELECT [BOM Compare].Drawing_Number, [BOM Compare].Drawing_Title, [BOM Compare].Drawing_Description, [BOM Compare].Additional_Description, [BOM Compare].Part_Number, [BOM Compare].Component, [BOM Compare].Quantity FROM [BOM Compare] LEFT JOIN [BOM Query] ON [BOM Compare].Part_Number=[BOM...

first query: SELECT [BOM Query].Drawing_Number, [BOM Query].Drawing_Title, [BOM Query].Drawing_Description, [BOM Query].Additional_Description, [BOM Query].Part_Number, [BOM Query].Component, [BOM Query].Quantity FROM [BOM Query] LEFT JOIN [BOM Compare] ON [BOM Query].Part_Number=[BOM...

When I do my unmatched queries, I need these fields... [BOM Query]. Drawing_Number, Drawing_Title, Drawing_Description, Additional_Description, Part_Number, Component, Quantity. Currently, if the number I am comparing against contains all the parts listed in the main number, I get zero...

thanks GingerR. ha ha...we meet again.

I have a report with two subforms that have distinct ID numbers. I want to seperate the ID numbers from the subform and place them in the main form. The ID numbers exist in seperate tables. Is there a way to either do this, or use a query to populate the text box/label?

ok, thanks, ill try it out.

so, GingerR, you are saying to have two unmatched queries? about outer join - im kind of lost on the whole query. can you give me an example of what you are talking about?

I need to be able to compare two bills of material against each other and only view the differences between the two. I'd like to have a report setup with drawing_info_a on the left and drawing_info_b on the right. pertinent applicable information: Tables: BOM Query - this holds Part_Number and...

You can add a new table lastQuantity. Everytime an item is used, either update the quantity or add the item into it. Its difficult to know what needs to be done without any additional information though.

thanks Gingerr - its working like I want it.