Recent content by seamusnboo

Hi, I wonder if somebody could give me an idea. I have this database with the information for various charities organizations. So each organization has name, address, phone, contact person, and many different services that they offer. On the table created for that, each service offered is a...

Hi. I need to create this report from a table that has several YES/NO type of fields. On my report tho, I only want the report to show the data that has YES on the field, and the ones that has NO not to be shown. How can I do that? Thanks

I'm new to Access and databases so my question might seem dumb, but I need some help figuring something out. Well, I have this database where I'm storing information from different charities. So I created a table with their name, address, phone, contact person, and many othe things. Now I need...

We're almost there now, lol. I was able to get the drop down box to jump thru records now instead of changing the record. And I created a form for the user to input the time in/out for each employee, but showing one record at a time. You said with a little tweaking we could get this form to...

The way I'm couting is. I created a query from the original table. I activated the Totals button. On the first field of the query, I selected the survey field I want to be counted and on Total, I selected Group By. On the second query field I selected the same survey field and on Total, I...

Ok, I need further help with that my survey database. I wonder if somebody could help me figure this out. So, I have this survey database with questions for visitors of a certain park. I have several Yes or No questions. I created queries that will count how many Yeses or Nos I have for each...

First I'd like to apologize for not posting on the apropriate category, I'll pay more attention next time. Second well, your expression works, but in some of the products I have a problem. In some of them, when the query finds zero products of certain category, instead of outputing zero, the...

I have this report that shows me the quantity of different products. I also have to show on the report the percentage of the quantity of each product. So I created a percentage field on the report that divides the quantity of certain product by the total number of products and it gives me the...

Ok, nevermind, I just figured it out. Everything is working perfect now. Thanks a lot.

Ok, done that and it seems that we're almost there, lol. It will give me the count of each region, but it is multiplied by the total number of entries. For example, I have a total of 29 entries. The region 9 occurs only one time, and my query shows region 9 with a count of 29, istead of 1. And...

Thanks for the reply. But I still have a couple questions, ScottGem. I created the first query as instructed with the expression Region: Left([ZipCode],1). I also created the second query, and made the first column Region. You said to create the second colum ZipCode. But, where is the source of...

Hi. I'm a newbie to access so I was wondering if somebody could help me with this issue. We're trying to construct a database with information from visitors of a park. The information the visitors provide include the ZIP code where they're from. This information is stored on a field called...

Hi, I need an advice here. We have a database we use at work to register the feeding of animals in a park everyday. Somehow, one of the persons who's assigned to enter the data found an old version of the database and started entering data in it, instead of entering the data on the right...

Ok, I did that, created the "Field" with a query. But now there's a problem. My main form has the Record Source being set as the main table. So when I put this query "field" on my form I get a field filled with "#Name?" in it. How do I make this query "field" work on my main form?

Hi. I'm new to Access and I wonder if someone could help me with this problem I am having while constructing a database. We need to create a database of reservations to a program we offer. We will need to store the quantity of reservations per person. What we needed to do is multiply the...