Search results

JHB: You have created the Table [tblMinMax]. This should be the input. You have created another table tblNumbers]. Where from this table come from ? This should be the outcome of a query but not a table because I do not want to create this table. I want to get it as an output of a query...

I don't know if I am able to clearly show my problem. I have a Table [Table 1] This contains 3 fields. [Minimum No] [Maximum No] [Increment] The data is as under: Minimum No - 12.03 Maximum No - 13.12 Increment - 0.01 Now I need to create a Query [Query 1] This query should have a field...

There is no addition involved. I am looking for an answer as under: Query: [Numbers] Field: Number Values 12.03 12.04 12.05 etc etc 13.11

I do not have a trigger. But I will create the table which contains the minimum number, the maximum number and the uniform increment. When I click on the query, system must be able to generate the numbers in a field 'Number'. Possible ?

Thanks, friend. [Table 1]: Minimum Value - 12.01 Maximum Value - 13.11 Increment - 0.01 Answer will be in a query [Numbers]:

I have a range say 12.03 to 13.11. I need to generate all numbers falling within this range with 0.01 increment. (This increment is based on the numbers; if the numbers have 2 decimals, it should be 0.01. If the numbers have 3 decimals, the increment should be 0.001. Both the numbers will have...

GEMMA: Yes, the freq above and below add up to the same number i.e. the total number. But in order that both the events should happen together, simultaneously, the combined probabability would be the product of individual probabilities. I have re-arranged the numbers suitably now. First SQL...

Perhaps, the first SQL will result in 16 rows and 2 fields. (Item-BelowValueFreq) The second SQL will result in 16 rows and 2 fields. (Item-AboveValueFreq) The third SQL will result in 256 rows and 4 fields. (Item-BelowValueFreq-AboveValueFreq-CombinedValueFreq)

I think that there would be 3 SQLs in this case. The first one and the second one will limit the query 1 and query 2 to 2 columns. Third one will be made using the output from the first 2 SQLs.

It is necessary to have the 2nd and 3rd columns too; in the output. So that the output has the format Item-Probability below-Probability above-Combined probability,

I have this problem in probability that defies me and I need the help of Access experts. I have a query which provides probability of occurrences for items A,B,C,D below 5, 10, 15 and 20. Yet another query gives probability of occurrences for items A,B,C,D above 5,10,15 and 20. Now I need...

Thanks again. I was thinking of finding the highest cumulative frequency for each pair and subtract the cumulative frequency for a particular value (below the value) to get the frequency above the value. Total frequencies = freq below + freq above a value. Will do your idea also. Rgds

Plog! We got the cumulative frequencies below the buyingvalue. Can we get the same above the buying value ? Please see output 2.

You are absolutely right, plog! Absolutely brilliant and is working. Thanks, a million, my friend!

Are you able to open the excel sheet, plog ?

Thanks for your interest, plog!

Uploading the data.

Don't know how I can attach the table. As I pasted the excel data, it all got mixed up and is shown in a row.

Data looks like this: Pair BuyingValue Freq AUD/CAD 1 1 AUD/CAD 2 1 AUD/CAD 3 1 AUD/CAD 9 1 AUD/CAD 13 1 AUD/CAD 14 1 AUD/CAD 92 5 AUD/CAD 93 1 AUD/CAD 95 1 AUD/CAD 96 2 AUD/CAD 98 2 AUD/CAD 100 1 AUD/CHF 1 1 AUD/CHF 3 1 AUD/CHF 6 1 AUD/CHF 96 4 AUD/CHF 99 2 AUD/CHF...

I have this Access query that has the following fields: Pair: These are various forex pairs like AUD/CAD, AUD/CHF, etc, etc..totally 54 pairs. (All unique names) Value: This is a field that contains values of the forex on a 1-100 scale. This is on an ascending scale, starting from 1 and going...