Recent content by Treefarn

So up until 2 months ago, I had never touched Access. I was asked to build an database with a bunch of different forms, reports, etc, which I did. It works great, users and management are happy and we are ready to move it from the test environment to the production environment. One of things...

Ahha, yes, that is indeed it. I simplified the query before I posted it, leaving out parts I didn't think were relevant. There was another piece of a where clause to weed out records that didn't have valid dates in those fields. Apparently with both the two where clauses, it was validating...

But the "01" works just fine when I use the DateSerial in the Select, so that doesn't seem like it should be an issue. Its just when I use the results of DateSerial and try to compare it to >60 that there's a problem. There is no data missing, there's only 12 records right now, and all are...

Yeah, its a confused mess because when I can't figure something out, I just keep throwing stuff in there, and then clean it up when I finally figure it out. I tried using the dateserial, but I still have the same 'mismatch' problem. So this works: SELECT documentstable.destructionmonth...

So I am working with a table that has 2 text fields called DestructionMonth and DestructionYear. The data in DestructionMonth is a 2 character month (01 through 12), and year is a 4 character field. What I need to do is find all records where the destructiondate is within 60 days/2 months. I...

The report is meant to serve two purposes. One where the user will be prompted to enter a box #, and one where I will link to it and pass a box #. I think your suggestion will cause the first purpose to no longer work, as nothing will prompt the user for a box #.

If I remove the parameter, then click on the 'Find a Box' report and getting a popup to enter a Box ID will no longer work.

So I have a report that opens via Parameter. The SQL behind the query that runs the report is (I took out alot of lines that aren't necessary to answer the question) PARAMETERS [Enter Your Box Id] Short; SELECT DocumentsTable.OrganizationalID, . . . DocumentsTable.Status FROM DepartmentsTable...

I actually found another thread after I posted. I'm not sure I understand the why yet, but this fixed my problem. I actually can't post links yet, but it was thread 112624. "To be able to post links or images your post count must be 10 or greater. You currently have 1 posts."

I am VERY new to Access, and my guess is this question is fairly easy. Here are my tables Question Table ID Question AnswerID CategoryID Answer Table ID Answer Category Table ID Category So my form shows : Question, Answer, Category And I can display any existing question and make updates...