Search results
-
O
Sum of Sum
I have a report from a user input query that lists the data and has it broken down into three "tiers" or subcategories. The last tier contains 4 fields, one of which is a numerical value. On the report built from the query, at the top of the third tier I use the =Sum function to give me a... -
O
Microsoft Jet Database Engine
I have a database that opens and runs a few queries such as delete query, append query etc to make things easy for the user. The database is accessed by a link from an internal company website. The problem I have is that sometimes (fairly often in fact) I get an error that says "The Microsoft... -
O
Question Web Usage and Access 2003
I am looking for advice regarding using several access databases from a web page. The history is that I have put together about a half dozen databases that make our life very nice here at our small office. Additionally, I built a small web page for intranet usage locally as well. As it turns... -
O
Convert a text field to a number field
I have a table with 19 fields that gets records automatically added to it daily. The source program that adds the data to the database gets its data from scanning documents and identifies each field to be inserted into the database by a two letter identifier at the beginning of the data... -
O
Clearing of a form
I have a form that has 19 combo boxes which are linked to queries from a table. My intent is that the user should choose the applicable items from the drop down boxes on this first form, then hit a search button at the bottom which opens a new form that is filtered by the data from the first... -
O
eliminating similar records
I have a database that records 20 fields of information about a record. In two of these fields, it indicates if the record has been tested or not and if it passed or not. These are equated to 1 and 0 for yes and not respectively. In one additional field it indicates what type of test. I then... -
O
Removing two letters from a table
I have a table where each field has two or three extra letters at the beginning of each entry. I simply want to do an update query that removes the unnecessary letters. Each field has the exact same two (although some fields have three) letters on each entry. For example all of field1... -
O
Limit Subsequent Records
I believe the answer is probably already here but I was not successful at drawing it out through my searches. What I have is a simple access database with the main table having 23 fields. I have a form that displays the fields and each field on the form is a combo box where the user simply... -
O
Query missing one item
I have a database whose purpose is to gather and query data from identical linked tables with the same field names. The current process is this: I have a macro that deletes all data from a temporary table. I have an input form that the user lists items from one field to get the appropriate... -
O
Add text to records found
I am looking for the simplest way to add text to a record. I have a database that gets its data from linked excel tables. All the table fields are identical. I have done a union query to go through all the tables and find records by a specific field using an input form. It returns a perfect... -
O
Simple Query Multiple Linked Tables
First let me say that I believe I am having a mental block as to the simplicity of this question. Hopefully you have all had a day like this so I am not too embarrased. I have a database that is linked to 13 tables. Each table has the same 7 fields. I simply want a query to look at all 13... -
O
Three queries one parameter input
I have looked through the other threads but have not been successful with my goal. I have a single table with all the data I need, but need it sorted. To achieve that goal I created a report with subforms based on three separate queries. My problem is that all three queries will need an... -
O
Replacing data within a column in table.
I have an older database that has 18000 records or so in it. I have recently begun using a new software that will automatically sort data for me and post it into a database. This is all perfect. What I want to do is merge the old database with the new. My problem arises in that the new database... -
O
Crosstab query error
I have a parameter query which returns me the data I need with two input parameters, a name and a date. The query provides the correct data but I need the output to be in a crosstab query so I created another crosstab query to make this happen off of the existing parameter query. The problem... -
O
Report Query into a Table
I originally posted this in the incorrect forum so thought I should move this to the report forum. I have a query that gives me data which includes dates. The data is captured for a week long period and subdivided by a project name. The result I would like to have in the end is a report... -
O
A week's worth of data starting on a date
My goal is to have the database request a date from the user and with the date provide all the records that are within the calendar week of that date. I can manipulate the input so that the data entered is the first day of that week (i.e. Monday input only) in order to make this easier. If I... -
O
Query help to get a single response versus multiple
Hello and thanks in advance for the help. My end result is to punch in a given date and starting at that date up to current day, sum all exams taken, re-exams taken and giving me a percentage of overall failures as compared to total quantity of tests. I have several fields for a class and exams... -
O
Auto Numbering
I am relatively new to Access but have some minor ability with it and would like to get some assistance regarding numbering. The purpose of my database is to control project revisions. For example let us say you have dozens of technical volumes (projects) with more being added each month. For...