Recent content by bmal

Good point, Galaxiom. See, if I complain too loudly about this *achoo* industry software *gesundheit*, they might take my data out of a warehouse and make Matzo Ball Soup out of it. :). So instead I walk into a padded room and scream. Just kidding. It's all good, and the software works very...

Here is a description of why I use pass-through queries. My Access database links to a SQL database. One SQL table in particular is north of 256 fields. I happen to want to report on one of those fields. So I use a pass through to pluck two or three fields out using the pass through query. It...

I feel guilty and need to confess that I didn't spend more than 10 minutes looking for a solution on this. Kinda jumped the gun; should have given at least 60 to finding a workaround. Sorry guys. I'm usually good about that. I think it's the 13 hour day thing catching up. I am still...

I have the same situation as the OP. Here is my query expression: File_Status: IIf([Current_Status]="Prospect","01. Prospect",IIf([current_status]="Application","02. Application",IIf([current_status]="Sent To Processing","03. Sent To Processing",IIf([current_status]="HMDA Complete","03. Sent...

CJ London and Galaxiom - those are very helpful comments. Thank you. Now I realize that I was on the wrong path with regard to the Replace() function. I will read those references and see if I can put the knowledge into action and share what I ended up doing to accomplish the objective...

Hello. Here is a snippet of the table design. Noteworthy...this is a linked table to an SQL database.

Hello. Here is the exact field value from table (the field type is long text): -------- 11/26/2013 11:20AM - File withdrawn. - Mailed withdraw letter to applicant. - Blake Adams 11/21/2013 3:40PM - Will withdraw file - Sam Rogers -------- here is what works perfectly: Field1...

Thank you, spikepl, for that. Perhaps I am too novice to understand how to use that in this example. Furthermore, I probably did not explain my situation clearly, either. I am making a report from a query. The field of interest is a conversation log which does not lend itself to friendly...

hello. I am trying to reformat a string of text so that it is easier to read on a report. Based on the text, it seems like the best thing to do is to insert a carriage return before a date/time stamp. Here is the data (it's a conversation log)...it is three unique conversation log entries...

If this topic has been thoroughly hashed out I apologize. The thing is I cannot find a definitive article that says this can or cannot be done. The idea is to display in a report a field with 50 records in two separate columns of 25 records. Is this possible or am I completely off the...

If you have a table dedicated to Categories and a separate table dedicated to Tickets with a common field (such as Category_ID), your task is doable by using a join in a query - 'join properties-show all records from Categories....' and then use Totals and do some Count and Group by to get your...

This is interesting. Unless I'm off my rocker, I would have addressed the OP's task with a Union Query. I do this with debit and credit journal entries all the time that I want in one output. As long as the fields are the same, the criterion for Service_Interval can be distinct.

Can you please elaborate on the report events in Report View? Print Preview does work properly and does display all the information, however, that is not how the application is used. People want to use Report View which offers command button functionality, etc. I will continue to play around...

report view. We do not print much; screen viewing is sufficient.

yes. Both those are true.