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

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

¼ìÄê¤ý, ¦ÊÅܬP§g, r102030r, ¥§¶ø·s¤B 4 ±ø¥´¹v¥J.

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

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

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

My query returns: OpenDate, CloseDate, DaysOpen with iif(NZ(T.CloseDate,"")="",Now() - T.OpenDate,T.CloseDate - T.OpenDate) AS DaysOpen It seems to work when...

I have a table with date fields and . I would like for the query to show me only the calls that have no date (are null) or if the date is greater than one...

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

I am looking for a way to tell a query to check the current day of the week then assign a number. For example: Currently, my data is driven by a 'data date'....

Dear Helpful users, As a Newbie to ACC2000 I have created a dB for our Service Dept where we record Customer details in one table and Repair details in...

I've made a function that would calculate only business dates between current data and a date field (Nxt Cpn Dt). I've used the function dhCountWorkdaysA in...

Hi all, I've got a union query that requires 2 parameters. I'm using vb6 to make a select statement based on this query but i don't know how to pass...

I have copied the IsLoaded module from the Northwind DB into my own DB. I have successfully used this code in a macro condition. Can I use the IsLoaded...

I have a table that I am trying to match up the Last Name, First Name, and Date of Birth to another table . I have created join properties for those three...

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

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