Recent content by pop

Well, it was for a report haha, shouldn't post it there.

Yes, but I had no answer in the other section for 2 days, but had one in 30 min in this, sorry for the double post but I need an answer fast.

I have a text box which get value in a form which takes its value from a table, which looks like this : =[Forms]![frmRequest]![cboAsk].[Column](1) from there its ok, but my problem is that I have a Data type that takes it data from a table (table in a table). The table in the other table can...

I forgot an important detail, my table which is in the other table can have multiple values. Thanks, Pop

Is there a way to put a iif statement on a picture, depending on a value, there can be two different picture. thank you, Pop

I have a text box which get value in a form which takes its value from a table, which looks like this : =[Forms]![frmRequest]![cboAsk].[Column](1)from there its ok, but my problem is that I have a Data type that takes it data from a table (table in a table). So how can I take that value, I...

Thank you, work out really well. Pop

Workout great with little adjustment, thanks a lot. But now I have a minor problem with the external database. If the field has a max char of 50 char and the field has 10 char, the other 40 char are replaced by 40 spaces. I was wondering if there is a way to completely remove those spaces in my...

bump!!!!!!!!!!!

Tables: I have a table which is linked to our company's client list (about 12,000 entries). I then have another table which add information for to the other table (a check box, invoice number and the amount). Then I make a query which put the two tables together. Form: This query is then used...

oh i see :P Thanks a lot for your help

I already tried that, but the problem that I had is that the total is the sum of the transaction and I don't know how i can do the same thing with a sum. Thanks a lot for your help, Pop

I have a form which shows the summary of all the monthly transaction. The column are Company, Transaction Type, and total. All the amount generated in the form are form query. What I want is to add a column which would put all the amount that are in USD in CAN $. Here is the form: And the...