relates to previous question regarding memberships cards and intia

[newuser]

Hi,before i start my next question i would just liek to say thanks to
everyone who replied to my earlier quetions it is much appreciated,the next
question i have is related to the question regarding the membership cards i
wanted to create.I made the query as told and it works great!
Left([FirstName],1) but how do i get the query to run when opening the
report to display the bales ?? thanks

 

[John W. Vinson]

Hi,before i start my next question i would just liek to say thanks to
everyone who replied to my earlier quetions it is much appreciated,the next
question i have is related to the question regarding the membership cards i
wanted to create.I made the query as told and it works great!
Left([FirstName],1) but how do i get the query to run when opening the
report to display the bales ?? thanks

You don't need to "get the query to run".

The expression should be in the query upon which the report is based. If
you're basing the report directly on the table... don't! Use a query instead;
this lets you do things like calculate initials, select which fields and which
records you want printed, etc.

John W. Vinson [MVP]