Child ID Access

Tecktonik vol.4 CD1 02 – Swen Weber – Bassman (Chris Count access mix)

Duration : 0:5:6

(more…)

Keeping track of traffic on my site is not an issue but most of my readers access my blog through RSS feeds. I haven’t found a good way to figure out how many people have subscribed to my blog and how many read each article. Any tips would be appreciated.

If you go to www.feedburner.com (it is free) , you can set up your blog/rss feed with feedburner and it will track the number of people who subscribe to your feeds for you.

How can one count anything if not allowed to use any means to do so? One would just have to guess.

I guess it’s easy but i just can’t make it…

Here is the deal. I have a table with 3 columns similar to this:
City | Item ID | Status
NY | 001 | Open
MI | 002 | Closed
NY | 003 | Closed
NY | 004 | Open
CH | 005 | Open

I want to count how many Open and Closed item status there are for each City. The query should return the result in 3 columns like:
City | Open | Closed
NY | 2 | 1
CH | 1 | 0
MI | 0 | 1

I only seem to get one column result right… When I add the closed column in the query, it doubles every result.

Thanks

The way you are showing the desired layout of your results is achieved with a Crosstab Query. You can make it two ways: 1.)Make a new query and use the wizard. 2.)Go to your existing query. Go to Query (on the toolbar) and select Crosstab Query. A new column will appear in your design grid labeled "Crosstab". In your City column select Row Heading. In your Item ID column select Value. In your Status column select Column Heading. Run it. Hope this works for you!

I have been using my access pass for a while now. But I have never considered looking online in my account to see my data/credit count etc. until now. But when I tried to sign in i forgot the username i had used to sign up. Is there any way besides starting a new account to get into my account?

try going to the store and give them your card or info for card and ask if they can access it for u :]

I have a Access database and want to display a percentage on a report. Specifically I need to perform the following calculation.

100*(1-(<# of entries in Query 1>/<# of entries in Query 2))

Since I don’t have a lot of experience with Access I don’t know how to use the COUNT function for this application (I think COUNT would be the function to use). If you need further information on the queries:

Query 1 has fields:
-Employee Number
-Surname
-Given Name

Query 2 has fields:
-Key (Autonumber)
-Employee Number
-Surname
-Given Name

Thanks in advance for your help.

I think the function you want is DCOUNT.

DCount("[OrderID]", "Orders", "[ShipRegion] = ‘CA’")

That example counts number of orders in the orders table where the shipping region is CA.

I want to count only unique values in a pivot table count field setting, not count all entries. This is analagous to Unique Values Yes setting in an Access query.

ive never used Access
so im guessing what you want here

-drag your field into the Data section
-it should default as a count of
- if not, then right click on your data column
- click field settings
- change it to count of

Skip Counting Easy 1’s to 100 with Obie Leff. Skip Counting is a great primer for learning your multiplication tables. Visit http://www.singtolearn.com to see more videos, get song lyrics, download tracks, and buy CDs. Or, become a member of Club Obie for full access to our growing library of educational music videos. Perfect for the classroom teacher to display on their digital projector with broadband access.

Duration : 0:3:12

(more…)

I am a 20yrs old girl (weight 215.6lbs and height 5’6”). I wanted to watch my diet not so much for beauty purposes than health care. I always read health magazine or browse the internet etc etc but it doesn’t help because: 1) The recommended health foods are all foreign food e.g. salad n oats that even if they were locally available it was only in supermarket of malls in major cities plus; 2) it wasn’t cheap and; 3) I don’t know how to substitute it with local veggie or fruits because I don’t know how to count the calories in anything edible. I am currently living in Malaysia. Additionally, I have no access to healthy food because we’re not allowed to cook inside our room in campus and the foods sold are all oily and high in calories. I am also having the intention of doing some exercise. My only source of exercise right now is walking to and fro to classes that included climbing a very high stairs. I am too embarrassed to be seen doing any cardio exercises and I don’t know how to swim. I don’t want a fast result. I just want to have my eating problem resolved and watching my diet the fun way.

Even if yuou had acess to healthy foods they are too expensive. Seriously! I understand the embarrassment of the exercise thing, but if you can’t swim but sounds like your willing to get in the water, the best thing you can do is water aerobics. I know it sounds like you need to know what your doing but you don’t moving your arms, legs walking in the water, up to your neck ofcourse, it is an awesome way to lose wieght. You will know that you’ve had a good work out when you step out of the water, and or the next morning. 15 min. is all! Drink water also. Just limit your portions on the food you do it. You know how a dinner plate has the design around the edge? Don’t fill your plate to the design take it back an inch. I know it sounds funny, but I am overwieght. I’m not obeise and I’ve never dieted or felt I had to but, I am pushing 30, swam and did water areobics all my life, have 3 kids and I haven’t gained a lb. in 8 yrs. IT WILL WORK!! GOODLUCK!

ok so I HAVE to use an if statement to determine how many people are 30 years of age or older in each state. However, I am unsure how to set up the if statement in the query design.

Here is what I got but I know its wrong
Expr1: IIf([Marketing Research]![Age]>=30,"1","0")

what am I doing wrong? Thanks!

the IIF statement in access syntax is as follows:

IIF(test expression, what to do if expression evaluates to True,
What to do if expression evaluates to False)

So it would be something like

IIF([Age]>=30, "add one to total", "do nothing")

don’t know where you’re putting the total so can’t help you there put this is how it would look and why do you the marketing research field there?