hi i m new user to ms access can u please tell me in detail how to make a parameter query , how it works supposr i have employee table and i wan to c each...

Hi, I have a table with the following fields (and formats): Model (text format) RegPlate (text format) Mileage(number) InitialValue (number) Forecast...

If I do an INSERT based on a subselect i.e. its going to insert multiple records, and some of the records to be added fail on a duplicate key, will the...

Hi folks... coming from regular SQL and Oracle, i wonderd if you could help me on how to accomplish the following task in ms access. Thanks a lot in advance...

I have created fairly large table to gather hospital audit information. The audit has 70 questions per unit. The questions have a Yes, No or N/A value. I...

Hello everyone, I am creating a query which is a combination of two tables (contains fields from both Table A and Table B). Though I now don't specify any...

I want to create a new field (DBE/SBE Goal) in a query based on information in existing fields (DBE % & SBE %). How do I write the expression to get the...

As I understand Access queries, when you ask it to give you a Sum of all amounts under an index number (such as an item group number), you should get a sum...

I made a calculation in a query based of two other quieris. Now I want to use that querys totals and another field from a different table to add them...

I know I am new at this but seriously, I have a table that has 105,592 records in it. I build a query that works fine until I add the total row in. Once the...

I have an append query that I am trying to run. When I run it the records are repeated. But if I change the query to a select query the records only appear...

I need to insert 3 columns into a table, the first column comes from a SELECT from another table, the second and third columns are fixed values. Does anyone...

I have a schedule table with anAutocount, a date and a class code. Dual primary is AutoCountID and the Date, so that I can schedule more than one class per...

I have a table with Package#, Reference#, PartLocation, and PartDescrip. I am trying to find distinct records of Package# and inlcude all the other...

I have an Access 2000 database with a table that contains the results for several athletics events. The competitors receive 100 points for winning an event...

I'm trying to pull delimited data that is contained within one field in my database. Is there a way that I can isolate and pull one portion of the delimited...

My query runs based on Data Data entered on a form: WHERE (((tblQualityData.IssueCloseDate) Between !. And !.) When I add: WHERE...

I am trying to query in Access for a value in a field that contains a quotation mark (or double quote). Example: Field1 value = "Mr. John Smith I want...

I have a field in a table that lists a person's name as . So the way a name appears in the field is Doe,John. I would like to build two expressions that...

I need Transaction Description for a given TR_NO displayed. My results displayed need to come from the following criteria.. If the first number in my TR_NO...