Search results
-
P
Calculating percentages in a crosstab query
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... -
P
Building Table from the results of a query.
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... -
P
Building Table using the results of a query
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... -
P
Declare a variable in ACCESS JET SQL
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'")... -
P
Create a New Table with new fields using a Query.
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... -
P
MS Access Data using VBA
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...