ANY Solution........

[Shafique]

hello Everyone

i am working on an INVENTORY database. where i identified some Item Sizes with ' and " and /
but when i run the query some records did not proceed.


where the problem

 

[welshgasman]

If you are going to have single/double quotes in data, then you need to allow for that.
I *think you need to enclose with triple " (It might well be 4 ")

Experiment.

 

[Shafique]

If you are going to have single/double quotes in data, then you need to allow for that.
I *think you need to enclose with triple " (It might well be 4 ")

Experiment

like that.
PRICE :Dlookup("PRICE","OUTENTRY",""[INAME]='"&[MANKERAPOs].[INAME]&"' AND ...........................[ISIZE]&"'"")

 

[welshgasman]

Don't know?, does it work?
You can also use CHR(34) to enclose the field.

 

[Shafique]

Don't know?, does it work?
You can also use CHR(34) to enclose the field.

it does not works.....
i don't know how to use CHR(34)?.
what does it mean.

 

[welshgasman]

You concatenate Chr(34) which is actually a ", but that does not interfere with any " in the variable/field

 

[Shafique]

PRICE: DLookUp("PRICE","OUTENTRY","[INAME] ='" & [MANKERAPOs].[INAME] & "' AND [ITYPE]='" & [MANKERAPOs].[ITYPE] & "' AND [ISIZE] ='" & [MANKERAPOs].[ISIZE] & "'")
i tried it with Chr(34), and Double Quotes but not working
Actually i want the PRICE value from OUTENRTY table of previous Purchased same Item that ordered in MANKERAPOs table where match the INAME, ITYPE and ISIZE criteria
but in ISIZE i have some data with Quotation marks that doesn't match it with Chr(34) and without it procced with syntax error in string.
ANY ANY ANY Solution please.

 

[welshgasman]

Start of small, and take it step by step.
Get it working only with lSize, then add the rest
AGAIN!! I believe I have mentioned this to you in the past?
I tend to put the criteria into a string variable for domain functions if not a single simple criteria.
Then I can debug.print them to see if I have the syntax correct.
Then when correct, I can use that in the function.
Plus, if you cannot see the error, you can copy and paste here or eslewhere, so someone can point out the error.?

 

[Shafique]

i am still stuck......

 

[welshgasman]

Use Replace() in both Isize fields to get rid of any internal quotes.