Search results

I'm building a relatively basic inventory database as a placeholder until a sophisticated program is rolled out in a few months to track inventory and production. I did a data dump from an Excel sheet to get all the product info; however, I created a quantity field, which wasn't on the...

I've posted a similar question in "Reports", however I was thinking that perhaps I could create a query that would pull the information I need. I have a database that lists every employee's birthday within my directorate. I'd like this query to only pull the employee records of those whose...

I've built a database that lists the birthdays of all the employees in my directorate. I'd like their names to be highlighted in the yellow in the report I've created when their birthday is coming up in 30 days or less. I can't seem to find a formula that will help. For example: one person's...

I've built a database where my employer can keep track of the 131 positions he is responsible for, along with the information for past and current staff. I created a field in the Positions table called [Currently_Filled], and the options are "Yes", "No", and "TBA" (To Be Assigned). The "No"...

In the query I've created, I want only the records that show an [End Date] that is greater than today's date to come up. Thus, I've entered >Date() in the criteria under Design View. When I clicked on that column to sort the date while in Datasheet View, I get this pop-up (except my expression...

Good afternoon, I'm designing a report and made the page size "legal". When I click Print Preview, about a third of the second page is blank; however, in Layout View I can't move my fields any further to the right. The report definitely needs to be two legal pages wide because of the amount of...

Good morning, I've created two tables (one called [Positions] and the other called [Staff]). They are linked by the position number, which is the primary key in [Positions] and is a required field in [Staff]. I'd like to make it so that if the position number entered in the [Staff] table...

The database I'm building will enable my employer to keep a historical record of which staff member has held which job. To that end, I've created a field called [Current Position Holder], with only a "Y" or "N" being acceptable entries. One of the reports I'm designing should only include the...

I have a two-part question. 1) The database I'm building has a [Medical Test] field. This test needs to be taken every 5 years by people under the age of 40, and every 2 years by people above the age of 40. The people's ages are entered in a field called [DOB]. I'd like the conditional...

I have a field called [Force Test] which is set up as a Date/Time. It represents the date where a test was taken. This test needs to be taken annually, so I'd like the date to appear in red if the taking of the test is past due, as well as having the date appear in green when there are 3 months...

Greetings from Ottawa, Canada. I've learned the basics of Access during my Business Management course at a private college, and now I'm on internship. I'm expected to build a database, but what they would like goes beyond the little I've learned in class. I stumbled across this website while...