Designing an Invoice

G

Gregc.

G'day

I'm designing an invoice, using the reports function in Microsoft
Access. I've used the following for Title:

Title: =[chrFirsName] &' ' & [chrGivenName]

Whever I view this, it comes up with 'Enter Parameter Value:
chrGivenName. Could someone tell me why this is happening. I am a
newbie to MS Access.

Thanks

Greg
 
D

Duane Hookom

Are you sure you have a field in your report's record source "chrGivenName"?
Did you spell it correctly? I would have thought you spelled chrFirstName
wrong as there is no "t" in your example.
 
G

Gregc.

Duane said:
Are you sure you have a field in your report's record source "chrGivenName"?
Did you spell it correctly? I would have thought you spelled chrFirstName
wrong as there is no "t" in your example.
That was a typo, when I typed it onto here.
 
D

Duane Hookom

Again,
Are you sure you have a field in your report's record source "chrGivenName"?
 
V

Vantastic

Hope you've figured this out by now, but if not:

From what I can see your quote marks are wrong. Use double quotes to define
empty spaces and the such:
Title: =[chrFirsName] & " " & [chrGivenName]

Cheers
 
Top