Search results

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...

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...

Imagine that you see a column of values and then a total at the bottom. The only issue is that the total value does not appear until you click on it. It is almost as if it is lazy and needs to be reminded of its obligations. Can anybody think of a setting that would cause a total value in a...

The cropped report view '12.jpg' attached image shows an on-screen report view. Lines 1-11 display nicely. 12 is protesting. 13 is a loyal party follower. The properties view 'properties.jpg' displays the offending field and her parameters. Can anybody speculate, promulgate, or opine why...

Good afternoon. Here is the data I am evaluating: 07/17/2013 8:08AM - Mailed Disclosures to Applicant - Bsmith08/21/2013 4:58PM - Do not have correct address - Jhayes09/13/2013 3:17PM - Do not have correct mailing address - Arogers This is 3 separate conversation entries. I am trying to force...

Hello. Plog was kind enough to get me started by responding to this question over in queries: I am trying to return a value in an expression (call it FundedPeriod): CurrentWeek, CurrentMonth, PreviousMonth, based on a date value in field [funded_date]. Here are the criteria I am using...

Here are the criteria I am using: Current Week: DatePart("ww", [Funded_Date]) = DatePart("ww", Date()) and Year([Funded_Date]) = Year(Date()) Current Month: Year([Funded_Date]) = Year(Now()) And Month([Funded_Date]) = Month(Now()) Previous Month: Year([Funded_Date])* 12 + DatePart("m"...

I read this resource often, but never joined. It is a great wealth of information for which I am grateful. Better late than never, eh? Most of what I do is Access front end to a read only SQL back end hosted offsite. Namaste.