Search results

Thanks, much obliged!

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"...

1. Thanks for the tip. I'll see about making those changes (and keep the weird characers for the captions instead of actual field names). 2. For the query to pull the information I need, that criteria is necessary (at least as far as my admittedly limited knowledge of Access goes). My...

SELECT [Non-HS Positions].[Posn #], [Non-HS Positions].[Employing Unit], [Non-HS Positions].[REO #], [Non-HS Staffing].SN, [Non-HS Staffing].[Last Name, First Init], [Non-HS Staffing].Rank, [Non-HS Staffing].[MOS ID], [Non-HS Staffing].[Start Date], [Non-HS Staffing].[End Date], [Non-HS...

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...

What fvdb is saying is that nowhere in the formulas you've shown is there an indication of where the date should be. Which parts of your formulas represent the date?

I've tried that already; oddly enough, the width remains at 22" when I do that, even though it should be 17". Come to think of it, 22" is "Letter" size x 2. So I don't understsand why I can't change that value once I've selected "Legal".

My employer uses Legal, so there's no getting around the issue that way, unfortunately. For some reason, I'm unable to make the width larger than 22", which leaves about 4" (not counting margins) of space I can't use.

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...

Thanks. I'm still trying to get a grasp of programming logic.

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...

Turns out, all I needed to do was change the Row Source to "Y" only in the field's property sheet. But thanks for the help, folks, it's much appreciated!

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...

Oh and thanks for Date() > DateAdd("yyyy", IIF((Date()-[DOB])/365<40, 5, 2),[Medical Test]). It worked like a charm, and that's a good start for where I'm going.

I definitely plan to, however my time here as an intern is short, and my performance is being graded. I don't even know where to start; I've basically been told that I'm trying to run before I learn to walk (when I talked about building an IF formula). A lot of the examples I'm seeing online...

I'll watch this from home tonight; no video streams of any kind are allowed where I'm doing my internship.

I just checked with my employers, and the answer made my problem even trickier. If a test is taken past the age of 35, the 5-year rule still applies, but the next medical test has to be taken no later than the age of 42. So this means that a 36- or 37-year-old would have the five year...