Recent content by firestorm52

Thanks! I'll give that a try.

I'm involved with a project that is currently in its infant stages and I need some help figuring out how to create a report. My department had a custom Access DB made to track bus pass users for our city. It's been about a year now so requests for pass renewals will begin soon and I'm trying...

Once again thanks for your help. My report is finally complete!! On to the next project . . .

Thanks for your advice pbaldy. I ended up creating another form with that asks for the beginning and ending dates (like you said) and everything worked out well. Now I'm attempting to use DCount on a filtered version of qryP3. Of the records that match my criteria i.e. within the date range...

Sorry for not including any explanations. The Sample DB is what the form currently looks like. Users should be prompted for a beginning and ending date to filter the data from qryP3. That's where thee #Error shows up. I've included a copy of the database with the code that I have tried to use.

Here's a sample db . . .

I'll work on getting a sample db together. I forgot to mention that [Time Required] is a variable that was setup in qryP3.

What I am looking for are all records that were completed within 15 minutes of being called in. Is your method faster or more preferable?

Oops. I meant to paste this one instead . . . =DCount("[P3]","qryP3","[Time Required] <= " & 0.010416667)

I have created a db that provides a snapshot report of various maintenance activities since the beginning of the program i.e. when the db was first created/installed. My sups have asked if it is possible to get the report broken down into quarterly segments though and I'm having trouble getting...

Much Appreciated Thanks Mile-O-Phile for your help. I really appreciate it.

I need to change the formatting for a certain field in one of my tables without having to re-enter all 600+ records. Somehow the data type for this certain field was changed from Text to Number. The original data had a 6 digit input mask so there were multiple entries that had preceding zeros...

Thanks for the tip. I tried what you advised but I still came up with that error. On a whim, I decided to copy the query and rename it with the new field included. Somehow it saved without a problem. I then deleted the original query and then renamed the new one with the old name. Don't ask...

Has anyone run into this problem before?: I'm trying to add another field to a query and everytime I go to try and save it I get a pop-up windows that states the following: "The Microsoft Jet database engine has stopped the process because you and another user are attempting to change the same...

Figured it out, but now . . . I was finally able to figure out a solution to my prior problem (Sum[Incident Type]), but now I'm attempting to post the dates that are being reviewed in the report heading. I believe I need to create a subform that will ask for a beginning and ending date...