Queries :: Split Memo Field In A Query

Feb 26, 2015

I have a table that contains a memo that is delimited by line breaks. For each of these breaks i need a new record in the query results that i can then use in a Labelling application.

My current query looks something like:

ID | Product | Pack Size
1 | item a | 1x1000,1x1050
2 | item b | 1x1000,20x25
3 | item a | 1x1000

(Where the , is a new line)

Whereas my ideal output is:

ID | Product | PackSize
1 | Item a | 1x1000
1 | Item a | 1x1050
2 | Item b | 1x1000
2 | Item b | 20x25
etc.

I think im supposed to use the Split() Function though i dont have a clue wherw to start.

View Replies


ADVERTISEMENT

Queries :: Memo Field - Render HTML In Query

Aug 27, 2013

I can select memo field (configured as RichText) as rendered html:

select somehtmlfield from sometable

And have rendered html output:

"normal bold"

Or select it as html string

select Cstr(somehtmlfield) from sometable

And get

"<div>normal <b>bold</b></div>

Is there any way to produce rendered html from string?

I would like to:

select SomeConvertingFunc("<div>something <b>bold</b></div>") from sometable

And have it rendered to "something bold".

View 1 Replies View Related

Queries :: Memo Field Appears In Query In Chinese Or Japanese?

May 16, 2013

Table shows memo text fine..

but when i run a query its shows the memo field with text like: 였A and 愊` and 謍�

View 3 Replies View Related

Multiple Queries On Memo Field

Jun 27, 2007

Hello all,

I'm having a bit of a problem with a query that I am trying to run that searches a memo field, and I hope someone can help me!

Basically, I have a fairly simple database, 2 tables - 1 of the tables has a memo field which has 'keywords' listed in it (a mixture of words/phrases separated by commas, although I've tried with just spaces in between).

When I search using a Query box for 2 keywords using the following query, it can only find the correct records when I enter the keywords in the reverse order in which they appear in the memo field...
query: Like "*" & [Enter the 1st keyword to search for] And Like "*" & [Enter the 2nd keyword to search for] & "*"

If the memo field has data eg, "funding, teaching" (as opposed to "funding, nursing" for example) and I search for 'funding' and then 'teaching' - no results appear.
If however, I search for 'teaching' and then 'funding'... ta da! Result found.

Obviously, whoever searches the database isn't necessarily going to know what order the words were entered into the memo field!

So, is this a peculiarity to Access, or is there something I'm doing wrong?

Thank you in advance for your help.

View 4 Replies View Related

Queries :: Write Back To Access Memo Field

Jun 26, 2015

I am trying to update a memofield from a form.My file.. sign_midi.asp has this partial code.First I pick up the record I want to update.
And then present it in a form.
"
<tr>
<td align="right" height=10 valign="top"><b>Beskrivning :</b></td>
<td align="left" height=10 valign="top" width=250><TEXTAREA WRAP="soft" name="M1" cols="65" rows="8"><% = rs("text")%>

View 2 Replies View Related

Queries :: Extract Data From Memo Field And Put Into New Table

May 13, 2014

Is there a way I can take each entry in a memo field and put it into a text field in a separate table. The database is getting really big and the customer notes field for each record has lots of entries. The memo field looks like this:

8.4.14 Ordered 2 cartons
20.3.14 Ordered 2 cartons
4.3.14 Ordered 2 cartons
18.2.14 ordered 1 carton
30.1.14 ordered 3 cartons SCENTED wipes

[Code]...

I want to take each line and put put the date in a date field and the text in a text field in a separate table linked by CustID. Is there a way to do that?

View 7 Replies View Related

Query A Memo Field

May 31, 2005

Greetings All -

Let me say first I am a novice Access user, just trying to teach myself a few things to make my job easier. So take it easy on me with any feedback.

This is my situation. I am using a web based help desk ticketing software that has an Access DB. I have created a couple of queries and linked them together that seem to be working and giving me the data that I want with one exception.

I am tring to query a memo field, which is the description of a ticket, and the output is only a small portion of what is actually entered in to the table. Is there a way either in my query or report builder to make a change that will output all of the data from the description field?

A couple of things that I've tried on my own are to change the data type for that field from memo to text, however that that puts limits on the amount of data that can be entered in and causes the help desk software to function incorrectly. I've also turned on Can Grow and Can Shrink for the text box for the output in my form.

Any help you can offer would be greatly appreciated.

Thanks.
Jason

View 1 Replies View Related

How To Query A Memo Field?

Dec 8, 2007

Hello,

I have Custormers table.

Name : Text
Address : Text
BDate : Date
Notes : Memo

Sometimes, I need to query Memo field.

I have a CForm which has a field named Search.
I want to query all Notes fields in Customers table via CForm!Search field.

Should I make a query like this? I use IN but I doesn't work.

SELECT Customers.Notes, Customers.Name, Customers.BDate
FROM Customers
WHERE (((([Forms!CForm!Search]) In (Customers.Notes)));

Thank you for your help,

Osman

View 1 Replies View Related

Memo Field Is Truncated By Query

Mar 14, 2007

I am using a 'memo' field in a table because the field size needs to be more than the maximum for a 'text' field (255 characters).

Although the text appears in full in the table, when I run a query to select certain records from that table the text in the memo field is truncated to 255 characters.

Anyone know how to correct this?

View 1 Replies View Related

Queries :: Query Truncating Memo Fields

Dec 16, 2014

I have a query that is truncating a memo field to 255 characters. There is no distinct, group by, format, union or concatenate in the query which are the common cause for truncation.The truncated memo field is comments.

Code:
SELECT HearingAuditTbl.CASE_NUMBER,
Null AS appealcaseid,
HearingAuditTbl.HEARING_ALJ,
Null AS DecisionCode,
HearingAuditTbl.DECISION_DT AS ALJ_Date,
HearingAuditViolations.VIOLATION_NO,
HearingAuditViolations.COMMENTS,
"CATEGORY_B" AS CATEGORY,
NOW() AS DATE_ADDED

[code]...

View 3 Replies View Related

Not Getting Entire Data From Memo Field On Query

Aug 24, 2005

Hi all,

I had table with following data

Table

f1 f2 f3
1 10 aa......
1 11 aaa...
2 10 bb...
2 11 bb.......

f3 is memo field

I had to retrieve data by grouping records based on f1 value
so i gave groupby in totals section to f3 field also.

I am getting the values correctly, but memo field is truncating.
Its only displaying first half arround 236 charecters only.

If i query directly without performing any group by
then i am getting entire data for the memo field.

please any one give the solution.

waiting for your help.


Thanks

View 1 Replies View Related

Find A Word In A Memo Field Query

Jul 31, 2007

Hello,

I asking to see if it is possible to run a query on a memo field. For an example I want to pull all records where the memo field contains the word "Test".

Is this possible?

Thanks!

Fen

View 1 Replies View Related

Update Query Memo Field Question

Oct 7, 2007

I have a field [InternalComments] which is a memo field. Lots of data per customer

Can I make an update query to add data to the existing data without overriding the data currenty there?

Thanks

View 14 Replies View Related

Union Query Truncates Memo Field????

Jan 4, 2005

I created a Union Query for several linked Excel tables. Certain fields in the Excel table exceed 256 characters and Access (rightfully so) assigns these fields as "Memo". I have create a report based upon the Union Query; however, it will truncate the "Memo" fields to 255 (or 256 characters).

As a side note, if I create a report based upon a simple query using only one of the linked tables, it does not truncate the field.

Any suggestions on what maybe causing this truncation issue?

View 2 Replies View Related

Queries :: Memo Append Query Cutting At 255 Characters

Apr 11, 2013

memo fields chopping the content when appending to another table memo field.I have a query that takes in a couple of tables and then appends the content to one larger table.In each of the smaller tables there is a memo filed that when I check it has the entire type content in above 255 without a problem.

When the query runs and appends it to the larger table the content in the memo filed is chopped down.Both tables fields are set to memo I have double checked this.I have seen some comments about unique values in the query properties but these are set to NO as advised but it still does this.

View 4 Replies View Related

Memo Field, Will Show Only Partial Contents On Query

Mar 24, 2008

Running 2007

I never ran into this problem before.
I have a qry, with showing totals (group by). One of the fields is called comments, which is a memo field. I am only seeing partial comments.

When I redesign the query and take out the "totals", I see the entire comments.

Is there a fix to this?

View 4 Replies View Related

Queries :: Split Date Values In Query

Jun 1, 2013

I have a manufacturer that has sent me payments from 8/2/2012 to 05/20/2013 but there was a wide gap where we did not do business from the end of 2012 to April 2013.

How can split the date ranges up in the query so when I create my report, I can get two ranges for the same manufacture.

For example one list of payments from <#12/31/20112# and the other from >#4/1/2013#

View 5 Replies View Related

General :: Concatenate Two Text Fields Into A Memo Field In Query?

Sep 5, 2014

I'm trying to concatenate two text fields into a memo field using an expression in a select query. My problem is that the text fields together end up more than 255 characters, so I need the resulting field to be a memo instead. I can't change the underlying text fields to memo fields because this is a large database used by others who need those fields to be text.

View 3 Replies View Related

Tables :: Split Database - Table Field To Lookup Values From A Query?

Jul 6, 2015

I have a split database and need a field (Combo type) in the table to lookup values from a query in the front end. How do I do this as it doesn't see the querys because the front and back end are split?

View 3 Replies View Related

Converting A Text Field To A Memo Field

Jan 4, 2006

I am in the process of changing over a text field to a memo field to generate more space (in 5 different databases :eek: ) Thanks to all the good info on several searches of this forum, I am pretty clear on how to do that.

The question is... when I convert a field that already has information in it, will I lose the current information?

TIA,

Darnys

View 2 Replies View Related

Memo Field - How To Stop Highlighting In Field

Aug 7, 2006

when i change records, my subform that has a memo field, shows the memo field data is "highlighted". i can make a mistake and hit any keyboard key and the memo field data will get erased.

is there a way to prevent such a problem?

if not, is there a work around. eg, hide the memo field until needed for more input? ideas on both issues?

View 1 Replies View Related

Truncating Memo Field

Jan 26, 2006

I am using

DoCmd.OutputTo to export a query but this truncates the memo fields, but in the db window,right clicking and choosing to export does not truncate the data.


How do I code to output all the data without truncating?

View 1 Replies View Related

Memo Field Not Showing More Than 255

Jun 23, 2006

Hi guys and Girls

I have a txt box on a report which should show comments..
In the background table the field this txt box is bound to has a data type of memo. Yet the txt box on the report stops showing any more than 255 characters! any clues? I know 255 is the field size set for my Txt fields but memo fields should be able to display 65000000000000000 trillion characters with no problems.

When I look at the table the memo field has all the txt in it, it just wont display all the txt on the report.

Thanks for any help guys.

View 1 Replies View Related

Text Vs. Memo Field

Jul 28, 2005

Are there any other advantages in using a text field verses a memo field other than memory allocation? Memory allocation seems like such a small issue these days.

View 3 Replies View Related

Imported Memo Field

Mar 1, 2007

Hi, i have a fox pro memo field that has bill of materials information in like so:EACH KIT COMPRISES

1 CR10070SW 29.60 HALLITE PRODUCT
1 RBS24690 0.82
1 RBS354 0.95
2 RBS345 0.75
1 S95MMEXT 3.90


36.77 PER KIT

I need to take out the carriage returns but keep the items delimited in some way so they all apear on the one line. These are the child parts for kits so i need to keep them on one line as i import them or via a query so i can see the parent part they belong to.

Many Thanks

View 3 Replies View Related

Memo Field Length

Mar 26, 2007

Hello,

If I read the documentation then memo field in a Access table can be 65.000 chars long.
I have three memo fields in a linked ODBC table which is filled by a append query from SQL-server database. The text in these field is cut off by 255 chars.
Does somebody know what the cause of this can be?

1. Is there a limitation/property where I can configure the length of Access memo field? DAO? I have read something about this but I don't understand this.

2. How can I trace that everything is send from the source? Maybe it's cut off at the source site. On this moment I don't know something about a Linked tabel.
Is there a sniffer or trace tool so that I can see what kind of data is realy send?

Thanks in advance

Nico

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved