Recent content by Twillz

I got the coe to work thanks for your help. Here is the working code. SELECT coitem_linenumber AS linenumber, formatQty(coitem_qtyshipped) AS qtytobill, item_invuom, formatQty(coitem_qtyord) as qtyord, formatQty(coitem_qtyord - coitem_qtyshipped) AS qtybackord...

I tried your code and now nothing is come up on the report. Thank Twillz

Can someone please me help with this query? Here's what I'm trying to do. I have a report that shows: item number, item description, qty, etc. The problem I’m having is that I want to show an alias for the item if it has one, if not I want the item description to show instead, but only the...

Ordered is a blank field and I want to enter in how many a need in that field .

I made the queries but still can not update the ordered field

SELECT tbl_SubKit.Part, Sum(tbl_SubKit.QTY) AS SumOfQTY FROM tbl_SubKit GROUP BY tbl_SubKit.Part; and I would to have two more fields added

I have this query that is a total query. Here are the field in the query: Part = Group Qty = Sum What I would to do is have a inventory form that show the parts(group), the Qty(sum) and ordered, I have the form and it shows the parts, and qty but I can't update the ordered field...

Sorry Andreas, Work put me on a new project. But I did not get it to work. What I did was I used the query to ask the user for the record that they wanted to look up and it would show the record on the search form. Sorry it took so long

Can you write a query that would look in different tables for a record from what is enter on a search form. Example Table1 Table2 ID Id Customer Customer Reason Reason Date Date The records would be looked up by...

Thanks Andy I can see the records when there's only one tabe in the query but I can't get the query to work with around 10 tables. If I get the query to work maybe the form would be easier to work on. Thanks, Will

Andreas Here is the SQL statement SELECT [Did not ship due to other reason].Ran, [Did not ship due to other reason].Customer, [Did not ship due to other reason].Reason, [Did not ship due to other reason].Turn_Around, [Did not ship due to other reason].Rep, [Did not ship due to other...

Andreas Thank you for taking time on me, but I still can't it get to work. When I check the search button the result form open but no record, I have tables, shipping, parts, built, (theres more but if I get those tables I can get the rest)each table have the following fields: Ran, Customer...

Hi Andreas Thank you so much you are a lifesaver. I have one more question (sorry about so many qustion new when it comes search form, and finding records) I made the forms like you said but when I enter a ID the results form opens but no record is shown, and in the query do I need to add all...

Thank you! I'll give it a try. Will the user be able to update the record and it will save in the right table? Thanks Will

Thanks for your help. Can anybody help me? I would like to create a search form that can find records from multi tables that have forms linked to the tables. And when the record is found it will open the form that is linked to the table where the record is stored. Can somone please help me...