Search results

Is there anyway to update the criteria in a query from a form. Say I give the user a combo box to pick a number of different years. I want those yours to be the criteria in a query.

I imported a table into access and I want to add a column in that has a value for 1 for every row. Instead of having to go into the table and changing every single one. (400,000) Is there a way of doing it with VBA or a macro? If so how? Thanks.

I need to show the date of the table that the information is coming from on all of my reports. The only thing is, is that when a new table is brought into the database this data has to change to show the new date of the information. I have the dates of the policies which I tried using the max to...

Is there a way that I can manipulate data in pre-existing queries and crosstab queries by allowing the user to pick a variety of years they want the data to come from. Lets say a report is generated from a crosstab query that shows the number of policies there are in relation to the age and sex...

How can I set up a form that asks the user to pick which Report they want to open up and runs it for them?

If I have already set up a query where I have the groupings of information I want but I also on top of this info want to give the user the option to pick which years out of this data they want to put in a report. How can I use the data I already have in the query but only show the years the user...

Does anyone have a copy of a macro that gets the user to enter in a number of years ranging from 1971 to 2003 and gets them to choose a report for the info to go into then opens the report for the user with the wanted years information.

Does anyone have a copy of a macro that gets the user to enter in a number of years ranging from 1971 to 2003 and gets them to choose a report for the info to go into then opens the report for the user with the wanted years information.

I want the user to be able to open anyone of the report that they want to. How do I prompt the user with options and get them to chose it, hence opening the report for them.

How do I prompt a user to enter in a number of years like 1974, 1975, 1978 and 1985 and then bring up only the data from these years in a query. The format that I have to relate the date to is issue date and it is in the format dd/mm/yr. Anyone have any suggestions.

I have calculated the totals in each field in the report footer. Is there any way I can calculate the percentage of each field in the detail area in relation to each other using the totals?

I want to find the percentage of a specific amount of data in relation to the rest of my data. I've set up range expressions to seperate my data into 7 different sections. Now I want to create reports that have the percentages of these sections in relation to each other and 2 other variables. Is...

I want to combine a large amount of data into 7 groups in a query. I want to get the average and sum of all 7 groups seperatly. I want to create a report that divides the 30000 records of numbers ranging from 0 to 2.5Mm into seperate number catagories. 1 - 100000, 100001 - 500000......etc.

What is the best way to combine data from several queries (all data from 1 table) into a report? I want to group data from the table an have accomplished this by creating 7 queries representing the 7 headings I wish to present. How can use a report to present all of this data, hopefully without...