Hello,
In a report that I've created, I have a text box which I would like to show multiple elements in the same box to be sure that the spacing is just right. The 2 formulas that I'm trying to put in one box are:
=[SGL] & ", " & [Fed] & ", " & [Borr Src] & ", " & [Avail Tm]
and
=IIf([Action Requested]="Deleted","fro m","to")...
BlackJack17
Last Activity: Dec 19 '07, 05:16 PM
Joined: Oct 2 '07
Location:
-
2 formulas in a text box
-
Great. Thanks for all the help! I should be good to go now. -
Sorry about that, I meant to put in in the last post. Must have been too excited to hit submit.
Here's the string:
=DSum("[Trial Balance Amount]","DDRS Data","[Acct] = " & [Acct] & " AND [Program Description]= '" & [Program Description] & "'" AND [Fed]= '" & [Fed] & "'")
Like I said, it's telling me that strings can...Leave a comment:
-
String up to 2048 characters long??
Hi all,
This is based off of a previous thread that I had but it's a whole new problem. I'm entering a DSum formula into a text box on a report and I keep getting an error message back saying:
The expression you entered has an invalid string.
A string can be up to 2048 characters long, including opening and closing quotation marks.
The funny thing is that the formula that I've entered that is... -
Yeah, I unfortunately need to sum on all 15 fields. It has to do with a line of accounting which is comprised of 15 different elements, all of which I need the total for each unique line.
As for the 2048, I'm under the impression that a formula in a text box can only be 2048 characters long. Is this correct?
As for summing in the query, I can't seem to find a way to do it. The query is based on table DDRS Data and...Leave a comment:
-
You all are amazing. A new problem surfaced...
As I tried putting all 15 fields in the formula, I ran into the 2048 limit. Is there any way around this?
I swear I'm almost done with this thread.Leave a comment:
-
Great, that worked perfectly. I have one other follow-on issue...
I need to add additional elements to the formula to include fields like [Program Description] and [Fed], among others. Here's the formula that I put together to include [Program Description]:
=DSum("[Trial Balance Amount]","DDRS Data","[Acct] = " & [Acct] And "[Program Description) = " & [Program Description])...Leave a comment:
-
I thought you were supposed to put text boxes in square brackets. Could that be my problem?Leave a comment:
-
DSum function in a report
Alright you all have been so helpful with everything else that I thought I'd run one more issue by you. I have put together a report that is driven by a query. This query (Unique Records) returns all unique records in a table (DDRS Data). Each unique record is a string of elements from the table (15 different ones total) and I'm trying to get the report to sum the multiple dollar amounts that appear for each unique record. I've used the DSum function:... -
Sort and group on more than 10 fields
Is it possible to sort on more than 10 fields? That is all that the menu allows me. -
Can I put that on the Criteria line of my query? Or do I put it somewhere else?Leave a comment:
-
Find "11*" in a table, but not 11* using a wildcard
I have another newbie question for you guys... I apologize in advance for how simple it is...
I've got a string of data, included in that string is 11* as it appears, the * is not a wildcard. I'm using the function
Like "*" & "11*" & "*" to find any records that have "11*", again, the * is not a wildcard. But it's interpreting it as a wildcard, so I'm getting 1105 and... -
Awesome, thanks so much!Leave a comment:
-
Access macros - automatically hit enter/select OK
Alright I've searched the forum and have found nothing on this subject so I'm hoping that you all can help me out.
I've put together a macro that contains a series of delete, update, and append queries. The problem is that with these queries, Access asks if you're sure you want to run them and tells you how many records it's deleting, etc. This is tedious to sit there and hit enter or select OK for all those text boxes. Is there...
No activity results to display
Leave a comment: