Recent content by JeRz653

Hi All, I apologize if this is not in the correct area but, I am unsure where this falls. I have a form that starts out with one field, [FamilyID] and a search button. The intent is to search the database to see if that exists. If it does, then the user would be sent to the IssueEntry...

Hi All, I have a database that I am building to track customer issues. It currently has 2 tables: tblMembers and tblIssues. Currently, IDNumber is the primary key under the Members table with a one to many to IDNumber in the Issues table. I'm having trouble comprehending how to solve an issue...

Hi everyone, I have a database that I use for customer service. It has a dashboard form that gives counts for open and closed issues. Within my database I have a Expected Resolution Date field. Is there a way to have text appear if for example, there are 2 record that have the current date...

Hi everyone, I am beyond frustrated with this because I feel like this is simple. Yet, I'm having issues with it. I am trying to use the average function on a field. The field calculates correctly in data sheet view but when I run a query, it displays with too many decimal places. The format I...

Hi All, I am by no means an expert with Access but I have learned a lot recently with using it and haven't taken a formal class on it since Access 2000. That said, I created a database recently for myself and a colleague which drew the attention of my boss and sure enough, I was asked to create...