Display values in subform based on multiple combo boxes

[vbaInet]

Well that's good to know and that's good for you too

 

[yasmeen]

Will you please help me to write a query for same database.

Query is: I have to add a calculated coulmun in my table called 'pips' and How it will calutate is as follows:
- I have pairs of trades in the table and subtraction of 'price' of pair is called pip of that row.

-We can use 'key' coulum to find a pair. 'Key' has this type of value: 244/1/-9934863, So each pair would have the first and last part of the value same. (for example if we have a pair, its values would be 244/1/-9934863 and 244/0/-9934863). These 0's and 1's denote for 'sell' and 'buy'.

- then Subtract the pair (large value - small value)
- then i have to figure out that what is the pair name from 'description' column. If its part of value contains 'JPY' then i have to multiply the subtracted value with 100 otherwise it will multiplied by 10,000.

It is very difficult for me, i don't know how to start it. I need these calculated pips in my table field, so that when i run my '1st dec' form, i will display the calculated pips in the subform with other coulmns.

Thanks

 

[vbaInet]

If you create a new thread I'm sure we can look at it and propose a solution.

Will you please help me to write a query for same database.

Query is: I have to add a calculated coulmun in my table called 'pips' and How it will calutate is as follows:
- I have pairs of trades in the table and subtraction of 'price' of pair is called pip of that row.

-We can use 'key' coulum to find a pair. 'Key' has this type of value: 244/1/-9934863, So each pair would have the first and last part of the value same. (for example if we have a pair, its values would be 244/1/-9934863 and 244/0/-9934863). These 0's and 1's denote for 'sell' and 'buy'.

- then Subtract the pair (large value - small value)
- then i have to figure out that what is the pair name from 'description' column. If its part of value contains 'JPY' then i have to multiply the subtracted value with 100 otherwise it will multiplied by 10,000.

It is very difficult for me, i don't know how to start it. I need these calculated pips in my table field, so that when i run my '1st dec' form, i will display the calculated pips in the subform with other coulmns.

Thanks

 

[yasmeen]

Ok i post it in new thread, thanks

 

[mcgilla]

Can this somehow apply to a single combo boxthat just lists the Year? And making data within a subform show only the dates within that year?

 

[vbaInet]

Can this somehow apply to a single combo boxthat just lists the Year? And making data within a subform show only the dates within that year?

In your case you don't really need code.

In the record source of your subform, you need a field that gets the Year() part of your Date field. So you would put something like this in a new column in the query:

YearFilter: Year([DateField])

Set the Link Master Fields property of the subform to the name of the combo. Just type in the name, don't click the elipsis button.

Set the Link Child Fields property of the subform to YearFilter.

That's pretty much it.