Recent content by Remdul

Ah, I see! Thank you very much, PHV! I just have to redesign my switchboard now to that I can have this one form open all the time. Not quite sure how I will do that yet, though. This form is definately very helpful for folks like me who are attempting to learn access. :) Once I figure out why...

Sorry about my vagueness there. WHat I did was I created a form called Date, then put within it two text boxes called Date1 and Date2. WHERE ((([ACO Report].[Date of Pickup]) Between [Forms]![Date]![Date1] And [Forms]![Date]![Date2])); When I ran the query, I recieved input boxes much like my...

PHV, I was unable to get this way to work, unfortunately. I kept getting prompted with search boxes as I ran the query. Aceman1, I am afraid I do not know a whole lot about the Visual Basic side of Access. How would I be able to set/change the variables as the need called for it? I put it in as...

I have a database that counts a number of events between a certain set of dates. The code looks something like.. SELECT Sum([ACO Report].[Board Fee $]) AS [Boarding Fee $] FROM [ACO Report] WHERE (([ACO Report].[Date of Pickup]) Between [First Date:] And [Second Date:]); There are 20+ queries...

Hrm, this is going to be a hard problem for me to explain. I havce a MSA Database I have been working on for 60+ hours. During the final touches of the database, something happened that has me very confused.When I open my database, it opens MS Access, but my switchboard is missing. On my...

It looks that that gave me the same problem as before.. Perhaps I need to change something in the rest of my code to get it to work? Thanks again! You've been very helpful so far Randy! Bryan

I appreciate you trying very much! I will continue to research this also. It's a very confusing matter, for attempting to get some simple data, hehe. Thank you again, Bryan

Is there any way to have the report run the query? Bryan

Here's some of the data, very small portion on it. If you need more, please let me know. Type Date of Pickup Pup 1/1/2006 Dog 1/1/2006 Cat 1/2/2006 Dog 1/2/2006 Dog 1/2/2006 Dog 1/3/2006 Pup 1/3/2006 Dog 1/3/2006 Pup 1/3/2006 Pup 1/3/2006 Pup 1/3/2006 Pup 1/3/2006 Cat 1/30/2006 Dog 1/31/2006...

SELECT Type, Count(Type) AS [Pets Processed], Format(Month([DateProcessed]),"mmmm") AS [Month Processed] FROM [ACO Report] WHERE DateProcessed Between #1/1/2006# And #12/1/2009# GROUP BY Type, Format(Month([DateProcessed]),"mmmm") Sorry about that! And thanks very much for your help! Bryan...

When running this code, Randy, It gives me The type, how many total, and the wrong month? Cat, 48, December (for 1/1/2006) Bryan

Yes, all the queries are created from the Main Table, ACO Report. It gave me an error when I tried to combine them into on report using the wizard saying that didnt work, so I used subreports. Bryan

Thank you very much Randy! I am not entirely sure I set it up right though. SELECT Type, Count(Type) AS [Pets Processed], Format(Month([DateProcessed]),"mmmm") AS [Month Processed] FROM [ACO Report] WHERE DateProcessed Between 1/1/2006 And 9/9/2009 GROUP BY Type...

Howdy, I am attempting to design a database for a local animal shelter to count how many dogs come through in a year, and I am fairly new to the access field. I have 5 queries, each specific to the type of animal... I have Dog, Cat, Kit, Pup, and Other. The SQL code for my 5 queries look like...

Is there a way to search the Access Pages? For example, you can use the Find button on forms (Command Button) to search the database for a record. But I hate not found a way to do so on the web pages. Thank you, Bryan Elliott