Hi Folks ,
I will say right away that I am not familiar with Access other than knowing what it is.
I have picked up a bit, googling, and will do my best to use the correct terminology.
My friend runs a cemetery. He has been using Paradox from Corel to manage around 15000 records of current and future residents. His drive with said software was failing but i did manage to open Paradox and export the data in every format it offered (III, IV, V and .CSV) before it completely crapped out. The only database software he has in hand is a 2010 version of Office with Access. Access accepted the .csv and now I have the table in Access. He has to be able to search almost every field and combine search these fields as well. I made a form and a corresponding query. For the criteria I watched a video from 2011 using Access 2010 and straight up copied the criteria he used in his query to combine search.
If there is a field in the table that is empty in a record, the query does not return that record.
So if I search by FirstName it only returns the records that have entries in all the fields not just FirstName.
In his video all of his fields in the table had a value in them. Mine do not. Some fields like YearOfDeath are empty.
Could someone suggest a bit of code that might work when some of the fields are empty or perhaps a better solution? My googling in this dept. frankly has not taken me far.
I will say right away that I am not familiar with Access other than knowing what it is.
I have picked up a bit, googling, and will do my best to use the correct terminology.
My friend runs a cemetery. He has been using Paradox from Corel to manage around 15000 records of current and future residents. His drive with said software was failing but i did manage to open Paradox and export the data in every format it offered (III, IV, V and .CSV) before it completely crapped out. The only database software he has in hand is a 2010 version of Office with Access. Access accepted the .csv and now I have the table in Access. He has to be able to search almost every field and combine search these fields as well. I made a form and a corresponding query. For the criteria I watched a video from 2011 using Access 2010 and straight up copied the criteria he used in his query to combine search.
Code:
Like "*" & [Forms]![SearchForm]![FirstName] & "*"
So if I search by FirstName it only returns the records that have entries in all the fields not just FirstName.
In his video all of his fields in the table had a value in them. Mine do not. Some fields like YearOfDeath are empty.
Could someone suggest a bit of code that might work when some of the fields are empty or perhaps a better solution? My googling in this dept. frankly has not taken me far.