Search results

Hi, In a crosstab query, I got to group two fields from a table. I selected one field as row heading and other as column heading. And I got the records grouped under those headings. What if I want to get the percentages of the groupings instead of the number of records? Please help me...

Hi DocMan, I am not obsessed or anything. After trying a lot in query thingie, I moved on to create a table becoz its not working out. Each "cell" in the query/table I want to create has a different expression. This expression is the formula for counting the results of another query. Can u...

Hi all, I have a database in MS Access. I built a query to obtain a subset of the database. Now I have the query. I want to summarize the results of the query in "summary" table in the same database. This summary would be as follows: Destination Purpose Count Percent Home...

Hi all, I have a database in MS Access. I built a query to obtain a subset of the database. Now I have the query. I want to summarize the results of the query in "summary" table in the same database. This summary would be as follows: Destination Purpose Count Percent Home...

Hi, Please look at the following code. CREATE TABLE tblDeshome ( [Destination_Purpose] TEXT(10) NULL, Number_of_Trips INTEGER NULL, Trip_Percentage INTEGER NULL ) inth = Dcount("[PURPOSE]","trips","[PURPOSE] = '1' Or [PURPOSE] = '2'") intw = Dcount("[PURPOSE]","trips","[PURPOSE] = '3'")...

Hi alexie, What if I want to enter values into the new table. The code below is what I wrote in SQL view of the query. CREATE TABLE tblTripgeneration ([Destination_Purpose] TEXT(10) NULL, Number_of_Trips INTEGER NULL, Trip_Percentage INTEGER NULL) inth = DCount("[PURPOSE]","trips","Purpose...

Hi Doc Man, Thanks. I got u. The query would be enough. I dont need a table. Bye Penmetsa

I have a problem. I have a query in my database. I have to create a new table with new fields (not the fields in the query). This new table is like a summary table of the query. How do we create a new table with new fields? And can we "count" the number of records in the query and display...

Hi Birdy, Can u please explain how to create an Unmatch Query. Thanks Bye Penmetsa

Hi Pat, Thanks very much for the info. But I want to deal directly with the table using VBA. Because, occasionally I may change the data in the table (with all the information) and I want the new table to change automatically. With query in between, it won't be quite automated. So, I want to...

Hi, I am a new entrant to this forum. And I am novice in VBA Programming. This forum is great. I have a problem. In my database, I have a Table with all the records (with all the information). I need to create a new table with only those records which have two fields not equal. I need to...