BIZZARE issue can not view data added to table

  • Thread starter Thread starter DBarker
  • Start date Start date
D

DBarker

OK this is where it gets BIZZARE. Apparently I have the
concatenate query working now. But get this when I view
the table it does not appear that the data in there, I
even closed the database and opened back up. BUT when I
copy the entire table and paste into an excel spreadsheet
the DATA IS THERE. I think I have entered the twighlight
zone but I could be wrong. ANY IDEAS PLEASE BECAUSE THIS
IS NEW TO
ME.
 
Concatenate sounds familiar as does query and table but I have no idea how
any of this comes together into a well described question. If you are asking
about a query, the default behaviour should be to provide use with table
structures, sample data, and sql view of queries.
 
OK this is where it gets BIZZARE. Apparently I have the
concatenate query working now. But get this when I view
the table it does not appear that the data in there, I
even closed the database and opened back up. BUT when I
copy the entire table and paste into an excel spreadsheet
the DATA IS THERE. I think I have entered the twighlight
zone but I could be wrong. ANY IDEAS PLEASE BECAUSE THIS
IS NEW TO
ME.
Click to expand...

D, you're assuming that either you're the only person posting
questions here, or that all of the volunteers have eidetic memories.
Neither is true.

Could you please either reply in the thread, or post enough context
(such as the SQL of "the concatenate query") for someone to have a
chance to see what's going on?
 
DBarker said:
OK this is where it gets BIZZARE. Apparently I have the
concatenate query working now. But get this when I view
the table it does not appear that the data in there, I
even closed the database and opened back up. BUT when I
copy the entire table and paste into an excel spreadsheet
the DATA IS THERE. I think I have entered the twighlight
zone but I could be wrong.
Click to expand...

In BIZZARE dimension, you have to look really
hard in the opposite direction to see your records.
(No wait...that was the Bizarro dimension)

If I concatenate the following

Null & vbCrLf & "aaaaa"

I will not be able to "see" the string "aaaaa"
until I adjust the row height of my table.

If I export the table to Excel,
I will see something like

||aaaa

It does not know what to do with
carriage return and line feed.

Could this be what is going on?

One-time fan of Bizarro world,

Gary Walter
 
Thank you because I had mixed feelings how I was going to
respond to that but opted to wait until I calmed down. I
am not an idiot but I come to this newsgroup to get
answers as all of us do and I don't expect to be talked to
like I am stupid. And yes I have been struggling with
this issue for quite a while and have posted in several
places in order to get solutions. But isn't that what
this forum is for???????????????

Thank you again!
 
I am trying to test your theory now, when I used it with
limited small sized text you could see the text in the
table so you might have a point. I will let you know what
I find. Thank you very much for your ideas.
 
Thank you because I had mixed feelings how I was going to
respond to that but opted to wait until I calmed down. I
am not an idiot but I come to this newsgroup to get
answers as all of us do and I don't expect to be talked to
like I am stupid. And yes I have been struggling with
this issue for quite a while and have posted in several
places in order to get solutions. But isn't that what
this forum is for???????????????
Click to expand...

I apologize for the sarcasm. It was overdone.

However, I am still unable to suggest an answer to your question
without taking an inordinate amount of time to do a Google search of
"several places" to find your prior threads. If you would please post
the SQL view of the query with which you're having trouble I'll be
glad to try to help. And again... I should have made this request in a
more polite manner, and I apologize.
 
Back
Top