Well, I have a rather complicated problem(Or at least it's complicated to me). I want to create a query that pulls results from between two numbers in...

Hi, I have an Access 2003 Database (NOT a project - ADP). The tables are linked to SQL Server using ODBC. My question is this: Is there a way to call a SQL...

I need to create a querry that needs to have values of two different columns to be looked up in another table. Ex. Table: ChangeDetails Column: Note ...

Hi All I need to do a search for serial numbers - I need to find exact match (easy) but also check for miss types - ie find any numbers that have one or two...

Hi All Hope someone can help with this one. I want to set up a query to run from a bunch of combo boxes. If the user selects none, then all records should be...

I have a prospects database that uses on-to-many related tables. When a prospect is 'dead', I want to archive the record and records in the related tables to...

I need to sort a table and assign a score to the first place (fastest time). The first place would be a value of 1 and slower times would be 2, 3, 4, etc. I...

Hi, I'm still quite new to Access. I've built a query to pull course details from the database. Unfortunately it seems to be causing problems and a part of...

Hello, I have a search form that has a "Start" and "End" field. The entire form works perfectly for other fields IF I don't have the following in the...

How do I get one Combo Box to show a list of options that have been defined by another Combo Box. For example, I only want ComboBox2 to show words that begin...

I have a few thousand records that all contain a date field in the British format of dd/mm/yy. I want to create query that groups the records into months. So,...

Hi, I want to set a field equal to a field in another table where two fields match (if that makes sense. Project Number is Text, Month is Integer, Cumulative...

Hi, I seem to be having with querying a date, I want to return all records that have a date = 01/04/2008, in other words anything from the beginning of...

I have a selection form with a pull down menu of courses listed for that person. I want to make it so an "Admin" can see all courses but other users only see...

Hi, Below is a simple Delete Query I am having problems with. I want to delete all records in Table: where field matches field in Table: . I get the...

Hi, I have a quantity column called 'Qty'. Number values. Quantities range from say... 1 through 5. Multiple records in the table with many different...

Hi All, Can someone assist me with a query? I need field Expr1: to divide by . Rate Total and Contracted rates are in 2 seperate tables I brought into...

Without having to export my data out of Access and do a find/replace in Excel then re-insert back into Access... How can I query "Column1", which has data...

I have a main form with 4 subforms. The 4 subforms source are 4 individual queries. When I open the main form I am prompted to enter the...