What info in the table tells you bnmhj is a sub-part of abcde? How do you know how many of bnmhj go into a abcde? John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of M Brovage Sent: Sunday, June 25, 2006 11:25 PM To: [email protected] Subject: [ms_access] Trim, mid, etc now working - thanks for the help ; Another question On this particular database previously mentioned I have to enter data manually into the imported database. What is the best way to go about this. Short Example: Imported database looks something like this Name Qty Price abcde 5 2.50 bnmhj 2 5.60 xyzse 4 1.00 rtus 4 2.00 Calculating total cost in a query I would multiple Qty*Price But because I am trying to do this in Access, bnmhj should be qty 4, not 2. This is because the main part has a quantity of 2, bnmhj is a sub-part. Thus if you use 2 of the main part you are actually using 4 of bnmhj. This main part is not on the same line, it is above bnmhj so I cannot use an iff. I want to put a separate column in the imported database with 2 in it, so the query would be 2*2*5.60. bnmhj is one of many parts like this and also with different quantities. If I used Excel I would run out of rows and resources. Any comments if I am going about this correctly. ---------------------------------------------------------- Whenever I use the trim, mid, etc, in a query I get an undefined function. At work these worked for this database and now at home I get the undefined message. I created a new query using trim, mid and I get the same message. What is happening? __________________________________________________ --------------------------------- Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2ยข/min or less. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> See what's inside the new Yahoo! Groups email. http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
