I have a main form that lists a part number for an item. I need to build a query that returns all other part numbers that match certain attributes of the...

Okay, I asked this question a few days ago and did not get a repy as of yet. But I want to approach this problem from another perspective so here goes again in...

Hi - Any idea why the SQL queries that are created by the Cross Tab Query Wizard cannot be ran in VBA? It starts off with the 'TRANSFORM' statement, as...

Hello, My problem has got to do with the Purpose of Travel field (query created field). Along with for e.g. object code - 2145, purpose of travel is "Sick...

I can't seem to figure out: A) where to write the expression to calculate serial numbers of weeks. B) how to get the expression to calculate the serial number...

First, thank you all who answered my previous questions. And now I have another. Is there a way to remove html tags from a memo field? Like a way to...

I want to increment a field, within a sorted table, resetting the counter to 1 when another field within the same table changes. (I do not want to know that I...

Have read at least 100 posts re #name errors and still can't figure out what's wrong with mine. I have a master form (and table, both called "Client") that has...

I have the following query: The sum(taxcredit) is not working -- it is summing all records by PED (period end date) where as I only want it to sum the...

Hello, I could use a bit of help here since I have not done this before. Tables: tblVitem, tblOrderLine, tblInvoiceLine 1) I want to add a new field to each...

Here is part of my query (a column from the query builder window).. ChildsLocation: (SELECT "(" & IIf( Like "Resident*",IIf(IsNull(),,),) & ")" FROM...

I am trying to find the easiest way to make a report or something that resembles an excel spreadsheet. The closest thing I have found is a crosstab query....

I have the same problem. I have 70 tables that I want into one table. All tables have the same structure with different content. I tried an Append Query but...

Hi ; I use the forms function to record information into a table . There is a primary key defined for one of the fields that allows me not to input duplicate...

I can't see anything wrong with the following StrSQL string but I get this error: Run-time error "3134': Syntax error in INSERT INTO statement. Here's the...

I am matching 2 tables. I need to retrieve the records that do not match.

Our business uses the SQL based Sage business system. I have written a large number of queries on the Sage SQL database tables using the ODBC link to Access....

Here is the SQL for the two queries: Access: SELECT DISTINCTROW Delivery.Promised_Date, Customer.Name, Job.Part_Number, Delivery.Promised_Quantity,...

Anyone know of an easier way to convert a 4-length string to a beginning date (in my case 06/01/(XXXX-1) ) and ending date (in my case 05/31/XXXX). XXXX Is...

No error when compiling but when open form, got 'type mismatch'. Here is the code: Private Sub Form_Load() If DLookup("", "users", "Trim() = '" &...