Hello, I need some assistance. I have a form in access 2003 that is linked to a SQL 2000 Database. I get a #DELETED Message on the form, but the records are...

Hello, I have an append query that gets info from two tables with the inner table getting the last date (max(MyDate)) as part of the criteria. INSERT INTO...

Hi I'd like to know if there is something similar to Sql Server function soundex() in Access ?

I am aware of how to create a table using SELECT DISTINCT to find record duplicates but don't know how to just select the duplicate records. The specific...

I am wanting to arrive at a total COUNT from Query 1 and Query 2. They both work individually, but I want the combined total. I am a beginner and would...

Hi Access users.... I am using Access 2000 with good results. I am trying to build a query based upon selecting a date range. (StartDate, EndDate). Using a...

Hello, I have a query that has a Field named Place that puts an auto number in a row based on where you finish. It is based on another query...

I am trying to use "Like" to return a record containing text in a box on a form. This wasn't working, so I put the actual value in the query and that wouldn't...

I have a database with three main columns: 1) Problem. 2) Description. 3) Resolution. I want to enter a few words in a form, and a query will show me all...

I need some help with finding the "nearest" value and add TRUE/FALSE into an expression field. This is the data as pulled from the...

I open a query in design view in Access and make some modifications. When I close the query, it does not prompt me to save the changes. It does save the...

Hi, I am having a table in MS-Access called CATEGORY_MASTER. The structure is: CATEGORY_CODE CATEGORY_NAME CATEGORY_PARENT We can insert category details,...

I have a query with 2 tables. They are order header and order detail. They are joined by Order Number where Order number can occur only once in order header...

How do you go about adding or summing columns were some columns are empty (Null?)?

I currently have a table of customer information all in upper case, one of the fields is Address. Is there a way to write a query(s) that will change each...

Need example of Dynamic update query. in the After insert Which field in placed in the critier. I have a field called Inventory in my master list form. In my...

Hi group, Sorry for asking it again, but does anyone know how to get to coluun order like the example below? Codigo SubCodigo Order 1 1 ...

I have setup an unbound, multiselect list box to prompt for filters in a report. How do I retrieve the selected values to use a criteria in my query for the...

I have a form with eight (8) text boxes whose values are passed to a query. The query ran fine a few times but now when I try to run it, I get a message box...