Help the new guy!

[Jonski]

I am quite new to Access. What I would like to do is
concatenate fields in access quieries whilst using
parameters, this also needs to be combined with a sub form.

many thanks

 

[GVaught]

Create your query with all the appropriate fields; including any primary and
foreign keys.
Create a calculated field that concatenates your two fields in an empty
column: Such as FirstName and LastName.
FullName:[FirstName] & " " & [LastName]
In the criteria section type: Like [Enter First and Last Name] & "*"

The & "*" Allows to enter a partial name in the event the user can't
remember how to spell a name. Also pressing Enter without entering any data
will return all names.

On the subform you can create a textbox control and set it to =[Enter First
and Last Name] and it will print the value entered by the user.

Note: Subform data is returned based on one or more related keys in the main
table. If you are trying to return data in the sub form separate from the
main form, this will not work. You have to call mainform data to get the
related subform data.

Perhaps if you run through the motions of what you are wanting to do; a
better more productive answer can be given.

 

[Bullschmidt]

Originally posted by Jonski

I am quite new to Access. What I would like to do is
concatenate fields in access quieries whilst using
parameters, this also needs to be combined with a sub form.

many thanks

An example of concatenating a field in a query:
FullName: [FName] & " " & [LName]

And for its criteria you could have:
[What is the first and last name?]

--
J. Paul Schmidt, Freelance Access and ASP Developer
http:\\www.Bullschmidt.com/Login.asp - Database on the Web Demo
http://www.Bullschmidt.com/Access
Sample Access Invoices Database


Posted via http://dbforums.com