Search results

Well, I did that, the system accepted all the data, and didn't complain!... Mock SQL = change table and field names, fields and formulas are the same. The SQL is correct, it gave me all tha data, and the table is fine, all the data was appended to it. It is somthing else. Do you have a clue?...

Hi, This was posted in #3: INSERT INTO PricesForUpdate ( code, PreUpdateConsumerPrice, MinPriceForUpdat, ManualAvoidUpdate, Upd, WholesalerPrice, UpdatedWholesalerPrice, CategoryID ) SELECT Products.code, Products.consumerPriceWithVat AS PreUpdateConsumerPrice, FC.MinValForUpdate AS...

Thanks spikepl for replying! I rarely store products costing a few 1000 NIS, most products cost less than 100. I havn't noticed any rounding effects problems in the past few years the system is working. is this relevant information, or should I expect penny errors?... In any case, the result...

Hi, As written above normalization is the proper way for Access and other relational DBs to handle these types of tasks. Please see if this thread could help you create the query pbaldy suggested, that will help you normalize your data. ATB!

Products is a table, consumerPriceWithVat is a Double.

Hi, back from holiday, Again, the SQL is fine, it gives me fine results in datasheet view. The problem appears when data is inserted to the table. The difference between results in datasheet view and inserted table are presented in post #14

Thank, Ill do that and be back with questions, if any

Hi all you experts! A client organization IT is migrating my Acc 2003 App to VDI - Virtual Desktop Infrastructure. The App runs fine, but much slower - Desk Top and local directories are now virtualized network, or 'Cloud' drives, the App's Front-End looses the advantage of running on a local...

Thanks all for replying! I get no message, not when running in VBA, and not when testing it manually. Would there be a way I'm blocking these messages? code - Double (?! should be Long. This is how the Create Table query created it...) PreUpdateConsumerPrice - Double (the first thing I checked...

in post#3 I've posted the actual SQL, Just modified table and field names, to not enclose what field of products these are, and what foreign currency is in the process... calculations are the same

Hi Dave, and Thank you for your reply! A Null value is fine (and expected in case of a new product being given a price for the first time). The query returns different results when in data-sheet view, and actually inserting the result set. I will refer to the results in the attached Excel: -...

Here is the data in Excel

Yup, but it is actually # of records in products x 1 = # of records in products - FC has only 1 record. Is the lack of a joining field an issue?

Hi, This is the data from the query: 4857 14.0536175251578 16 0 0 9.1868 9.1868 2465 6179 15.0574473483833 16 0 0 9.843 9.843 2465 4132 15.0574473483833 16 0 0 9.843 9.843 2465 3862 15.0574473483833 16 0 0 9.843 9.843 2465 2465 15.0574473483833 16 0 0 9.843 9.843 2465 This is the data...

Hi arnelgp, and thanks for replying, sounds like an extra action, that should work... could you explain why would that be needed? An other piece of information: the Products - FC relation is technically of NxN. Actually FC has only one record.

Thanks again, It's one SQL I save (crtl+s) the query after creating the aliased field, then calculate upon it, in the same query. The fields seem to be calculated fine, and the destination table has correct field types. It seems to me the error occurs on the PreUpdateConsumerPrice field...

Hi Minty, The calculated field works fine (I first save the query with the alias, then calculate upon it, it usually works fine for me). What is missing is the first field: PreUpdateConsumerPrice, it is null in these 5 records. Having it null, the calculation is fine. But they shouldn't be...

Hi CJ, I'll mock the SQL: INSERT INTO PricesForUpdate ( code, PreUpdateConsumerPrice, MinPriceForUpdat, ManualAvoidUpdate, Upd, WholesalerPrice, UpdatedWholesalerPrice, CategoryD ) SELECT Products.code, Products.consumerPriceWithVat AS PreUpdateConsumerPrice, FC.MinValForUpdate AS...

Hi all you experts! I want to insert the result of a query into a Temp table, but some data is omitted: the values of 2 fields in 5 rows The correct data appears in the query result, not in the table. Any ideas of what could have happened between the query and the table? Thanks in advance!

Google has way more knowledge on my network, my computer, and of me... And they have proven to know what to do with this knowledge!