Search results

Hi CJ, I have done some more analysis and it appears the problem occurs when the ordered quantity is lower than the lowest quote quantity. When this occurs and there is only one quantity in the quote file, there is no problem. However, when there is more than one quantity for that item, it...

I'll try to look at more examples. Happy Canada Day to All Regards Ed

Hi CJ, I was doing some more reviewing into the query results and noticed some problems with too many output records for an input. I zeroed in on item Z102823-1-- and have attached a file that shows input data, lookup data, actual output data and what I was expecting. Both of the input...

Yes, I did. Just saying that you hit it out of the park!!!!

Hi CJ, Looks like your query is working. I didn't notice the multiple quote records for same item with the same quantity with the same or different prices. I have gone back to the supplier of our system to see how they select a price from the quotes to put on the order when there are multiple...

CJ PS There are about 5 records in the formatch table that do not have a set of corresponding records in the quote file. I am reviewing this with the user. I assume this will not cause a problem, just there will be no match for these records. Thanks Ed

Hi CJ, Have attached my skinnied down version of my database. Only two tables. Regards, Ed

Hi CJ, Looks like the same error message, This occurs when I try to save the code. Regards Ed:eek:

HiCJ, I have attached the error message. I tried to copy and paste the PrintScreen on Friday but it obviously didn't work. This error message occurred when I tried to save the code. Regards Ed:)

Hi CJ, Would it be of any help to give you the source and lookup tables, if there were a way to get them to you? Regards, Ed

Hi Plog, thanks for your help, tried your queries but to no avail. My source query has 1767 records comprised partly of an item and a PO number, the combination of which is unique. I had to do it this way because each different PO for that item can have a different quantity ordered and...

Hi CJ, sorry I couldn't have been more definitive on my needs but I am running this from a ODBC where I analyze results to see what needs tweaking and learn as I go along. There was an error message about ()'s with an IN statement, so I added brackets after the IN and at the end. However, when...

Hi CJ, again thanks for your patience and being here in my time of stupidity. For the month I am reviewing, I have 1767 unique records in the order file, i.e. a concatenation of the Item and the PO. When I perform the query to select quantities and corresponding pricing from the quote...

Hi CJ, Thanks for your continuing patience. I put in the new code and I am getting a message saying "At most, only one record can be returned by this subquery". What I need is one line returned for every line in the OrderQuery. Regards Ed

Hi CJ, used your code in the SQL window as you said and received an output. I was expecting the number of rows to equal my qryItemsForMatch query but they were short. I have attached a file and it looks to me like the code is going to the closest or exact match between ord_price and...

CJ, I have tried using your code and get a syntax error in the sub-query. Also, I looked at the way the matching should go to select the closest match and it has to be based on the closest quantities, not price. I have revised your code to try and address this but to no avail. I think the Q...

Thanks CJ for your quick reply. Two questions. One is what you mean by the "Q" in the attached code - " FROM QuoteQuery Q WHERE"" The other is where would I use this code? Can I use it in the design view or would I have to add it to SQL statement within the query? Regards, Ed:)

I am trying to supply my sales manager with a report that will compare unit selling price for what was quoted versus what was actually billed. Our quote table is based on items and these can be quoted at various levels of production, e.g. for 100 units, 300 units, 500 units, etc.. I have...

I am working with a linked database (ODBC) and cannot really skinny down the data. Is there something else I could give that may assist?? Thanks Ed

I have attached a file that contains two images of the same report. This is in report layout and the command buttons to the right direct the user to another report that they may wish to view. As you can see from the top report prior to any of the command buttons being clicked, it is a clean...