Search results

[/INDENT] I want the record to show, but it needs to calculates after the value is entered in the deposit% text box. As I explained, it seems to calculate after the deposit$ text box value is entered. And at that time there is not yet anything in the deposit% text box, but there will be.

I am uploading a stripped down version of the db. Open up the frmQuote. Then click on the button to make the non cancel agreement. There is a control on this form - amt2pay. I want this control to display the sum of the values in the Total field on the subform on frmQuote. upload is a zip...

I should have explained, I have already found this solution but it does not wwork for my specific situation. If I try your suggestion it just shows a $0.00 in the calculated control - see attached. I think the problem is that as soon as I enter a value in the deposit$ box it performs the...

OK, another one for me to beat my head against a wall on I suppose. I have a form where a user will enter a deposit dollar amount, then a deposit percent, then there is another calculated control on the form that displays for them the total amount of the quoted purchase. The calculated control...

Yes, I make sure the form which contains the subform stays open. I am uploading a screen shot of the form(s) to illustrate. In the image you can see the main form, the subform and the control I am trying to reference which is on the subform. again, to make it simple let's say: My main form is...

Still not working for me. There has to be a way but, what am I missing. It looks to me like, in reading the chart - I want to be in the section that says: To refer to a control And Not in these forms because I am referencing a text box and I am not on the main form or on the subfor - I am on a...

Let me try it

I can denitely believe I am not referencing the forms correctly. I appreciate the lead but...I am still struggling with the correct syntax on the text box for my new third form. Possibly I am dense, the linked chart is confusing to me. Suppose my main form is called - frmMain, and my subform is...

I am struggling with this. Tried searching for the answer as am sure it has been addressed, maybe my search skills are waning as well but, not finding the solution: I have a form with a subform. The subform has a bound text box that shows dollar values for records (this field/text box is titled...

Thanks, this may be what I need. I have not had a chance to get back to it yet. Stay tuned.

I have an odd request. Was not even sure how to title it, explaining it will be a challenge as well. But will give it a try: I have a report based upon a query. I queried the same table twice - seperate queries and then joined the two queries in the query that the report is based upon: Query 1...

SOS, Got it, sounds good. Thanks a lot.

SOS, Good God! that works. And correctly as well. Easy enough. Thanks!

I have a table that has values that are data type test, My values in text look like this: 2.62 5.00 60.00 Is there a way in a query to format this text as a numeric percent of: 2.62% 5.00% 60.00%

I have a table that has values that are data type test, trying to change the data type to percent and am not seeing what I hoped. My values in text look like this: 2.62 5.00 60.00 When I go to design and change data type to number, field size to decimal and format to percent it returns: 262.00%...

Yeah, the replace function works fine. Thanks!

Another easy one I am sure: How do I replace a character in a string? For example I have values in a field like: 12345 123-45 12-345 And I want to remove the dashes. What is the easiest way to do this in a query

That's it! Thanks!

Appreciate the suggestions, like them both but, it does not result in a currency format on the value returned..????

Sigh....missing something easy again...damn, this frustrates me. Anyway, I have a query that has a field which is an expression. I want the result to display as currency. Ultimately this is going to be a control on a report. But I have tried formatting the control on the report as currecny and...