Search results

My DB table: FIELD1 FIELD2 other fields 1 FY11 other-values 1 FY12 other-value 2 FY12 other-value 3 FY11 other-value display results: FIELD1 FIELD2 other fields 1 FY11 values 2 FY11 N/A 3 FY11 values for the records that don't satisfy filter condition, display its FIELD1 & FIELD2 value, but...

Ultimately, I want to pass through the entire DB once and produce a set of outputs broken into 3 parts, instead of writing 3 SQL that pass through the DB 3 times to produce 3 separate sets of results. MyTABLE: GROUPfield FYfield VALfield (whole #) 1 3QFY11 1 1 4QFY11 2 1 1QFY12 1 1 2QFY12 1 1...

I'm a C++ programmer, this is my 1st ever Access project. I feel my options are limited in Access. What I need to do is to generate a report from 1 Access table. What I've been doing is create queries, then create reports based on the queries. The requirements are getting complicated so a...

My table: CHAPTER FIELD1 FIELD2 1 NULL “No Stat” 1 “No Stat” NULL 1 NULL NULL 1 “No Stat” “No Stat” 1 otherVal otherVal The result that I want: CHAPTER COUNTfield1 COUNTfield2 1 4 4 I want to select records that contain either NULL or “No Stat” in either FIELD1 OR FIELD2 then Count #rec for any...

my DB table: CHAPTER FIELD1 FIELD2 1 text1a text2a 1 text1b text2b 2 text1c text2c I want to do the following: For each CHAPTER in the DB: 1)COUNT all FIELD1 records that belong to this CHAPTER 2)COUNT all FIELD2 records that belong to this CHAPTER 3)DISPLAY the above 2 counts on the same row of...

How do I add a total of values in multi fields of a record? My dream query result: field1 field2 field3 total 1 1 1 3 (how?) 2 2 2 6 (how?) TOT: 3 3 3 9 (how?)-this is grand total Please help me...

To all pie chart lovers in the Access world, Can Access generate pie charts? The reason that I ask because Excel can. If so, what utility in Access can I use to do that? I'll be amaze if Access can do this. ;)

I created a report based on a query, when I run the report, Access prompts to enter [table-name].index number. I just press the OK button, the report runs fine. Why does it do this? How do I fix this? I am asking for help from all the Access experts out there. This is the 1st time I work with...