Search results

I have a table with over 500 records with the following fields. Category, Date, Grand Total, Total Male, Total Female. Many of the records have the same Category and Date. Is it possible to create a new table which combines the records with have the same Category and Date and also total the...

Is there a way that I can seup my report so that a new header page with title will be generated everytime the category of a field changes ? Thanks.

I have a form with a command button that adds a new record. My problem is that after I get the new record, I have to click into the first field before I can begin data entry. How can I get the cursor to begin in the first field ?

Is there a way for me to customize my form so that when I press the "Enter" key, I move to a new record ? Thanks.

It works. Thanks

I have a table with about 1000 records. The record has an Item field, a Code field and an Id field. The Item field in blank but it is a combination of the two other fields. Is there a query I can use to combine the Code and Item fields and then put the result into the Item field ? If so...

I have a report that is sorted and grouped by category. Is there a way for me to setup my report so that it will force a new page whenever a category changes ? Thanks

I have a table in case number order where many of the records have duplicate case numbers. I was recently told that a Group By query would enable me to eliminate duplicate records from my table. Can you show me the format ? Thanks

I have an Access 2000 database with about 1,000 records many of which have duplicated case numbers. Is the a way to create a query that will delete the records with the duplicate case numbers or create a new table with only the first occurance case numbers ? Thanks so much.

I have an Access 2000 database with about 200 records in case number order. Some of the records have duplicate case numbers. When I print a report all the records are printed, even the duplicates. Is there a way for me to print all the records but only the first record of the duplicated records...

I have a table that has 75 to 150 records. The Class field is the same on many records. Is there a way for me to run a qurey to create a new table which contains a grouping of the Class field.

I have an existing report. Grand Total Total class total female male hiking 5 2 3 hiking 4 2 2 hiking 6 3 3 swimimg 7 4 3 swimimg 2 1 1 etc.... How can I get the report to print the...

Very nice...thanks Pat.

I have a database with 12 fields. My report prints this information grouped by the Case field. Many times the group will be made up of multiple records. When this kind of group is printed all 12 fields will print 3 times even through all the information is the same except for the last 5 fields...

What is the difference between entering data into Access using a standard data entry form or using a data access page ? Is one better than the other ? Thanks

I did not think of that. I can create a table template with all the fields, then append the new table into the template. Easy is always better. Thanks

I will be importing tables which need to have additional numeric fields added to them on the fly before I can use them for calculations.

I have 5 page report where the report heading prints only on the first page. How can I modify the report so that the heading prints on all 5 pages ? Thanks.

Is there a way for me to use code or a query to add fields to an existing record layout ? Thanks

Is there a way to use VB to print a report so that I get a new page with header everytime a certain value changes ?