If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Ho do I shift empty cells up in an access report
In my contact data base, I have an unequal number of data for each contact,
some have 3 phone numbers some have up to 8 etc. I would like to print out a directory (phone book) in which records do only show fields that are populated. In other words, one record may only include 3 lines others may include 9 lines but I do not want to display and print a fixed number of lines, only the ones that are populated. |
#2
|
|||
|
|||
Ho do I shift empty cells up in an access report
GBA wrote:
In my contact data base, I have an unequal number of data for each contact, some have 3 phone numbers some have up to 8 etc. I would like to print out a directory (phone book) in which records do only show fields that are populated. In other words, one record may only include 3 lines others may include 9 lines but I do not want to display and print a fixed number of lines, only the ones that are populated. Depends on what the report's record source records look like. If you would post some sample records and how you want their fields to appear in the report, most likely someone can help figure out how. -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
Ho do I shift empty cells up in an access report
Sounds like you have a spreadsheet with up to 8 fields for phone numbers.
Normalize your data using a union query. SELECT FName, LName, Phone1 FROM Yourtable UNION ALL SELECT FName, LName, Phone2 FROM Yourtable WHERE Phone2 Is Not Null UNION ALL SELECT FName, LName, Phone3 FROM Yourtable WHERE Phone3 Is Not Null ......... UNION ALL SELECT FName, LName, Phone8 FROM Yourtable WHERE Phone8 Is Not Null; In your report group on FName and LName. -- Build a little, test a little. "GBA" wrote: In my contact data base, I have an unequal number of data for each contact, some have 3 phone numbers some have up to 8 etc. I would like to print out a directory (phone book) in which records do only show fields that are populated. In other words, one record may only include 3 lines others may include 9 lines but I do not want to display and print a fixed number of lines, only the ones that are populated. |
Thread Tools | |
Display Modes | |
|
|