ugh Need HELP pLz

[HM_Beast]

Hello

Well im studying information tech. and my dam teacher thinks he inveted access, got an exam 2morow and iv been running into one problem on querry, now im a newbie so this must be simple for u guyes (i hope lol)

well in the querry i want to set this :

field name last name Full Name:[name]+[last name]
table student student
sort
show yes yes yes
criteria
or

when im doing this the full name and run it it show the name and last name stuck together , how can i space them ?? please help ty my exam is in 12 hrs lol so fast

 

[KenHigg]

[name] & " " & [last name]



Ken

 

[HM_Beast]

omg lol thnk u very much woohho it worked hehehe ill come here more often this dam teacher of mine wldnt stop challenging me wid stuff we never learned yet . lol im goin to him now with IN UR FACE ill be back for sure , peAce

 

[KenHigg]

That's funny...

uh.... Don't bite off more than we... I mean, more than you can chew....

Ken

 

[Pat Hartman]

While we're at it:
1. Name is a poor choice as a column name. "Name" is a VB/VBA property so you are likely to run into a problem if you need to do anything with this table in code.
2. Embedded spaces (or special characters) in names is poor practice.
3. The "&" is the standard concatenation character for Access. Although the "+" will work as long as both fields are not numbers (in that case, it adds them rather than concatenating them), it does have other properties. Read about both symbols in help so you know when to make an exception and use "+" to achieve some special result.
4. You need an attitude adjustment if you want to succeed in any technical field. It is not possible to be "trained" on every detail and nuance of anything. It is incumbent upon YOU to research and find answers beyond your coursework. You need to "understand" rather than "memorize".