Simple church database

[papabill]

I am trying to build a simple database for our church members so I can eventually publish a member directory (with pictures).

The FIRST problem I'm having is that I'm VERY NEW to Access (any version). I've searched high and low for church directory software, but the only ones I can find are FAR ABOVE my budget.

One problem I'm having is trying to take two fields and concatenate them so that Field1 "FNAME" and Field2 "LNAME" can be printed as "FNAME LNAME". Just butting them up to one another just leaves such a gap between the names.

Another problem is setting up a report page to include the photos of each member, their FNAME LNAME, and CITY ST, with two or three members per row.

Does any of that make sense? and can it be done?

Thanks, and God bless

 

[Smitty]

Welcome to the Board!

If you look at the Access templates you'll find one for contact management that includes the ability to add a picture.

As for First Name/Last Name you can concatenate them in a query:

Name:FNAME&" "&LNAME

HTH,

 

[papabill]

As for First Name/Last Name you can concatenate them in a query:
Name:FNAME&" "&LNAME

I'm sorry, as I said, I'm TOTALLY new to Access, so I have NO IDEA how to create a query except to click on what fields I want to display, but creating something like that is completely out of my expertise.

 

[Smitty]

Here's a good tutorial on building queries:

Creating Access Queries

 

[papabill]

I did find an example of what I need by continuing to search the Inet. Now my question would be can you give me a hint where to find information about having two or three pictures (and corresponding info) on a single line in a report?

Thanks

 

[Smitty]

If you found a template, there should be an Attachment field for contact image. If there are already contact reports set up, then in Design mode on the form, you can click the Add Existing Fields button and drag the image onto the report.

You can also use the Report Wizard to help you create your own:

Create Access 2010 Reports

Access 2010: Creating Reports

 

[papabill]

I have searched and searched and cannot find anything telling me how to NOT print fields in a report if OTHER fields are true.

For instance, I have several minor children that I DO NOT want to print their phone numbers. I've tried several things in queries, but nothing works.

Guidance?

Thanks

 

[Smitty]

One way is to set up a query for your report and exclude children there.

You can also apply a filter:

https://support.office.com/en-us/ar...634-b72c-fde397bb7371&ui=en-US&rs=en-US&ad=US

https://msdn.microsoft.com/en-us/library/bb243764(v=office.12).aspx