Query format field (1 Viewer)

[Nita]

Hi, I have a query to create a table, and one of the fields need to be long texto, but my query makes it shor texto, meaning that most of the information does not appear. The filed I nedd to format MesAnoValor: ([Mes] & " de " & (left(tabela1]![datatotal];4)) & " - " & (Format ([Valor];"currency"))

 

[strive4peace]

hi Nita,

If I understand your question right ... A MakeTable Query will create a Short Text field but not a Long Text one. If your table needs to have Long Text, then make the table design yourself and, instead, use an Append Query

 

[vba_php]

furthermore, i dont' think you can combine currency with text in a field. see here: https://support.office.com/en-us/article/format-function-6f29d87b-8761-408d-81d3-63b9cd842530

 

[strive4peace]

that shouldn't be a problem, @vba_php -- Access should implicitely convert it to a string to concatenate

 

[Nita]

Hi,

I concatenated that field in other query, and the query itself does not give me more then the 255 char. t is the concatenated field that need to have more than 255 char.
Anyway, your replay will help after I resolve the above isue

hi Nita,

If I understand your question right ... A MakeTable Query will create a Short Text field but not a Long Text one. If your table needs to have Long Text, then make the table design yourself and, instead, use an Append Query

 

[Nita]

This field have no problema, it worked perfectly

furthermore, i dont' think you can combine currency with text in a field. see here: https://support.office.com/en-us/article/format-function-6f29d87b-8761-408d-81d3-63b9cd842530

 

[strive4peace]

I just tested appending to a table with long text -- no problem for me ...

 

[Nita]

mine just return 255 char, the rest of information does not appear.

 

[strive4peace]

check your table design for that field. If "@" is in the Format property, then delete it

 

[Nita]

My filed:
Mensal: ConcatRelated("Mes", "Teste1", "ID = '" & [ID] & "'", "QuotasSolicitadas)
In the query it's not visible the all when the result is above 255char.

 

[strive4peace]

hi Nita,

could you post a sample database that illustrates this problem? Thanks

 

[Nita]

Hi,
There it is.
Thank you

 

[strive4peace]

thanks, Nita -- I'm doing something else right now and don't have time to look ... perhaps someone else will jump in?

as I said before, however, my assumption is that changing Unicode Compression to match doesn't mean that previously entered data will use it until values are changed.

 

[strive4peace]

There it is.
Thank you

hi Nita
it is showing more characters for me ...

I opened it with Access 2007, but also have Access 365 loaded, so maybe that is making a difference for me? Does the sample you gave me work ok for you too? Did you try it? If it does work ok for you, then perhaps you just need to export the table and then bring it back in again.

 

[strive4peace]

or maybe use the sample and import everything from your other database into it ...

 

[Nita]

I have it in 2 databases, with same code "ConcatRelated", I used copy, paste.
And what want it's a mix of both, one of them gives the all info, and the other compile 1 just one record.
It was suposed to be 1 record with all the info.

 

[Gasman]

I get as below?, and I only have 2007

 

[strive4peace]

hi Nita,

It was suposed to be 1 record with all the info.

If you only want one record, then just one record needs to be in the source. Is there a field you can GROUP BY?

 

[Nita]

I am working with 2016, but I have 2 databases, I am going to send it, for you to see if you understand

 

[Nita]

The ID?

hi Nita,



If you only want one record, then just one record needs to be in the source. Is there a field you can GROUP BY?