Search results

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

Still not able to figure it out . . . Ok I've tried everything that was suggested but I'm still not able to print out the report that I need. I'm not sure but I think the problem lies with using DCount on a query result. As soon as I remove the "Between/And" criteria, the formula works. This...

mission, thanks for the advice, but I couldn't get it to work. I still don't understand why I'm not able to summarize the data for the required dates??!! :confused: Could the problem be with the relationship between the query and main table? Or maybe I should use the ServiceID instead of...

Tiro thanx for the help! It worked out, but now the report will print all 151 pages and only give summary data on the dates specified. Is there anyway to make the report only print out all records that occur within the specified dates AND summarize all of the events that took place within the...

The error message says "#Error". I was able to use the Count Function to count how many total recordsets there are, but now I'm trying to figure something else out. My query has a "Between [beginning date] And [ending date]" criteria associated with it and I think that's where the problem...

I'm attempting to summarize a report that was based on a query (qryDate) using the DCount function but I can't seem to get it to work correctly. First I'd like to count the number of incidents [Incident ID] so this is what I thought of: =DCount("[Incident ID]","qryDate") but for some reason I...