I am getting undefined function "Left" error message with the below function. =Left(,3) I want to get the first 3 letters from the left of the data. Does...

I have a table with soccer results and want to calculate th e points of the won lost or equal gamein a query. Example: result portugal - holland 2-0 gives 3...

Here's what I got Table 1: name=Employees key=EmployeeID fields=address, phone, active/inactive Table 2: name=Trainings key=EmployeeID, Training

Hi. Can anyone help?! I have two identical tables (accounts2003 and accounts2004) though one contains last year's data, and the other contains this year's...

I would like to use the same criteria in multiple queries, and be able to change that criteria in one central place (like on a switchboard or a...

I have a fairly simple table that I am trying to query and am having problems with one of the parameters. There is a field that simply holds a Yes or No. I am...

I am trying to create a grade book for my wife. What I need help with is adding or appending all students to a new assignment. Is there a way I can create a...

Dear all, I have 3 tables: A, B, and C that contain student records. The tables have the same structure, but they're for different semesters. They all have...

Hi all, I was just wondering if it is possible to 'loop' a query that I've created. Basically, the query is designed to let the user input a record's "Unique...

I have an unmatched query using two different types: Table # 1 has a text data type and the serial number appears ex. 139. Table # 2 has a text data type...

I have a crosstab query that is pulling from a query that uses date between and . works fine with the first query, but when I try to run the crosstab, it says...

How do I write the query to identify where exact duplicate entries have been entered for two fields, but a third field differs. Example of results...

Hello, I have a query that is designed to pull login ids by comparing last name, first name. If the first name is a nick name the field returns blank. Can I...

Hi, I have a problem with a form I'm using for entering customer orders. The main form () contains customer info and 3 subforms; 1. subform contains a list...

how do I ensure the date be stored in one format without any dependance of the regional settings of the client

Problem In a multi-use database, how do I restrict a user from having access to certain records and allow it for others. The scenario is as follows: The...

I have a database with an employee table. There are duplicate ss#'s in this table I want to create a recorset that shows the duplicate records. In Access...

My understanding is if the query is grouped by EmployeeSSNumber then the number will only appear once. In order for the EmployeeSSNumber to appear more than...

On a balance due report, I get the Nz value of 0 to appear on all lines. The 0 replaces actual payments. What is the wording to show that if a payment is...

I have a couple of question. 1. Does it matter if you have the same primary key in different tables, or is it better to have an autonumber as the primary key...