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...

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...

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...

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 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...

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...

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

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...

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...

How do I query for records containing the # as part of the data in a field. For example: row 1 FB row 2 #FB row 3 00 row 4 00 row 5 #RE

Hello everyone, I have a question that I am not sure of how I would go about it. (It could be that I am a bit of an idiot). What I want to do is enter data...

Hello I'm using an append query to save data from an Access front end to SQL. It's all working OK - except a memo/ntext field is being truncated to 765(ish)...

i have a query based on a table with multiple fields. one field consists of dates with the following format: 05/06/2004; and another field consists of card...

I have an an append query that copies entries from one field in one table to a field of the same name in another table. I have a macro that opens the append...

I have a query that ran perfectly fine in access 97 and 2000. It's running fine on my client's system now in 97 and it used to run fine on mine in 2000. I...

I have the Work Days function working well as described on the MS site. The problem is that the "Office Closed" function will not work for me or I must be...

I am using Access 2003 and I am trying to get all the colors that are not shipped by supplier S1 using a querie? Thanks for your support. James

Hello. I have a phone field formatted: 9995551212 that I have to change to: (999)555-1212 on fixed width text output. Is there a way I can do this using a...

On a pass-through query to SQL server 2k, is there any way to link to tables from two different databases? Within the query, I need a couple of tables from one...

Using Access 2000: I have two tables that have owner names. i would like to write a query that will tell me the differences. I creaed this query: Diff:...