QUERY PROBLEM ON FORM

  • Thread starter Thread starter JOE FERRANTE
  • Start date Start date
J

JOE FERRANTE

WHAT AM I DOING WRONG???? I HAVE A SQL STATEMENT

TABLE IS ENDITEM# FIELDS I WANT DISPLAYED ARE
NOMENCLATURE, ENDITEM AND PRIMARYASSY.

SQL STATEMENT THAT I WROTE IS

SELECT ENDITEM#.NOMENCLATURE,ENDITEM#.ENDITEM,
ENDITEM#.PRIMARYASSY FROM ENDITEM#

IT DOES WHAT I WANT IT TO DO IT PULLS THE THREE COLUMNS
THAT I WANT WHAT I WANT IS IT TO DISPLAY EVERYTHING IN ONE
FIELD. ALL I AM GETTING IS THE FIRST COLUMN THOUGH. WHAT
I WANT IT TOO LOOK LIKE IS

ENDITEM/NOMENCLATURE/PRIMARYASSY

I GET THIS IT GOES TO THE TEXT BOX OR DROP DOWN BOX OR
LIST BOX. THEN IT ONLY DISPLAYS

ENDITEM/
THE OTHER TWO COLUMS VANISH. I HAVE PLAYED WITH THE
PREFERENCES AND I HAVE TRIED TO EVEN MOVE THE COLUMS
AROUND THINKING IT WAS THAT BUT I AM OUT OF IDEAS ANY
SUGGESTIONS.


JOE FERRANTE
 
Hi,


PLEASE, USE LOWERCASE, IT IS FAR EASIER TO READ IF YOU USE LOWER CASE THAN
IF YOU USE ALL IN UPPER CASE, MAINLY WHEN THERE ARE MANY LINES OF TEXT,
BECAUSE IT IS THEN EASIER FOR THE EYE TO FOLLOW EACH LINE, HAVING MORE
SPACES BETWEEN EACH LINE OF TEXT. FURTHERMORE, SOME CONVENTION IS THAT UPPER
CASE IS USED TO EMPHASIS SOME PARTICULAR ITEM IN THE TEXT, SO HAVING ALL IN
UPPER CASE MAKE THE WHOLE TEXT APPEARING AS IF YOU WHERE SHOUTING, WHICH IS
BAD. THE SOLUTION YOU MAY TRY TO GET IS: SELECT NOMEMCLATRE & "/" & ENDITEM
& "/" & PRIMARYASSY FROM [ENDITEM#].


HOPING IT MAY HELP
VANDERGHAST, ACCESS MVP
 
Thank you I will try that
-----Original Message-----
Hi,


PLEASE, USE LOWERCASE, IT IS FAR EASIER TO READ IF YOU USE LOWER CASE THAN
IF YOU USE ALL IN UPPER CASE, MAINLY WHEN THERE ARE MANY LINES OF TEXT,
BECAUSE IT IS THEN EASIER FOR THE EYE TO FOLLOW EACH LINE, HAVING MORE
SPACES BETWEEN EACH LINE OF TEXT. FURTHERMORE, SOME CONVENTION IS THAT UPPER
CASE IS USED TO EMPHASIS SOME PARTICULAR ITEM IN THE TEXT, SO HAVING ALL IN
UPPER CASE MAKE THE WHOLE TEXT APPEARING AS IF YOU WHERE SHOUTING, WHICH IS
BAD. THE SOLUTION YOU MAY TRY TO GET IS: SELECT NOMEMCLATRE & "/" & ENDITEM
& "/" & PRIMARYASSY FROM [ENDITEM#].


HOPING IT MAY HELP
VANDERGHAST, ACCESS MVP



WHAT AM I DOING WRONG???? I HAVE A SQL STATEMENT

TABLE IS ENDITEM# FIELDS I WANT DISPLAYED ARE
NOMENCLATURE, ENDITEM AND PRIMARYASSY.

SQL STATEMENT THAT I WROTE IS

SELECT ENDITEM#.NOMENCLATURE,ENDITEM#.ENDITEM,
ENDITEM#.PRIMARYASSY FROM ENDITEM#

IT DOES WHAT I WANT IT TO DO IT PULLS THE THREE COLUMNS
THAT I WANT WHAT I WANT IS IT TO DISPLAY EVERYTHING IN ONE
FIELD. ALL I AM GETTING IS THE FIRST COLUMN THOUGH. WHAT
I WANT IT TOO LOOK LIKE IS

ENDITEM/NOMENCLATURE/PRIMARYASSY

I GET THIS IT GOES TO THE TEXT BOX OR DROP DOWN BOX OR
LIST BOX. THEN IT ONLY DISPLAYS

ENDITEM/
THE OTHER TWO COLUMS VANISH. I HAVE PLAYED WITH THE
PREFERENCES AND I HAVE TRIED TO EVEN MOVE THE COLUMS
AROUND THINKING IT WAS THAT BUT I AM OUT OF IDEAS ANY
SUGGESTIONS.


JOE FERRANTE
Click to expand...


.
Click to expand...
 
Thank You it worked
-----Original Message-----
Hi,


PLEASE, USE LOWERCASE, IT IS FAR EASIER TO READ IF YOU USE LOWER CASE THAN
IF YOU USE ALL IN UPPER CASE, MAINLY WHEN THERE ARE MANY LINES OF TEXT,
BECAUSE IT IS THEN EASIER FOR THE EYE TO FOLLOW EACH LINE, HAVING MORE
SPACES BETWEEN EACH LINE OF TEXT. FURTHERMORE, SOME CONVENTION IS THAT UPPER
CASE IS USED TO EMPHASIS SOME PARTICULAR ITEM IN THE TEXT, SO HAVING ALL IN
UPPER CASE MAKE THE WHOLE TEXT APPEARING AS IF YOU WHERE SHOUTING, WHICH IS
BAD. THE SOLUTION YOU MAY TRY TO GET IS: SELECT NOMEMCLATRE & "/" & ENDITEM
& "/" & PRIMARYASSY FROM [ENDITEM#].


HOPING IT MAY HELP
VANDERGHAST, ACCESS MVP



WHAT AM I DOING WRONG???? I HAVE A SQL STATEMENT

TABLE IS ENDITEM# FIELDS I WANT DISPLAYED ARE
NOMENCLATURE, ENDITEM AND PRIMARYASSY.

SQL STATEMENT THAT I WROTE IS

SELECT ENDITEM#.NOMENCLATURE,ENDITEM#.ENDITEM,
ENDITEM#.PRIMARYASSY FROM ENDITEM#

IT DOES WHAT I WANT IT TO DO IT PULLS THE THREE COLUMNS
THAT I WANT WHAT I WANT IS IT TO DISPLAY EVERYTHING IN ONE
FIELD. ALL I AM GETTING IS THE FIRST COLUMN THOUGH. WHAT
I WANT IT TOO LOOK LIKE IS

ENDITEM/NOMENCLATURE/PRIMARYASSY

I GET THIS IT GOES TO THE TEXT BOX OR DROP DOWN BOX OR
LIST BOX. THEN IT ONLY DISPLAYS

ENDITEM/
THE OTHER TWO COLUMS VANISH. I HAVE PLAYED WITH THE
PREFERENCES AND I HAVE TRIED TO EVEN MOVE THE COLUMS
AROUND THINKING IT WAS THAT BUT I AM OUT OF IDEAS ANY
SUGGESTIONS.


JOE FERRANTE
Click to expand...


.
Click to expand...
 
Back
Top