will dcount work 2 tables First has Aircraft with Start and Stop values and unique event ID AircraftID StratHours End Hours Event 546 ...

Trying to do some data mapping of user information from our old system to our new one. Structu 1 Main Tables (old system) - UserFunctionLocation (Contains...

like union i need intersect which give me the comman records from two table i have two table having comman field but the number of record is different and...

Can anyone help please? Report Gross Grand Total and Sales tax Total are off by a penny or 2 The amounts are being generated by the sum expression below...

I need to search for the last name of client and last name of spouse, two seperate fields. I'd like to be able to ask for the last name once and have both...

I have merged a table of "lapsed customers" with a table of "all customers" where just lapsed show with all the customer info, such as emails. There are many...

I have a table where some users entered tab characters in a particular column and I have to find them and delete them. How to find them? Can I use CHR$...

Hi, We are using MS access front end to a Oracle back end database. A number of the forms use pass-through queries. We are using a global user name and...

Hi All, I am trying to run the following query from OleDbCommand object but getting an exception. UPDATE SET FilePath = REPLACE(FilePath, 'd:\\',...

I have the following expression in my query: Expr2: IIf(="Yes",-0) "SCHW ADV NETWORK - New" can now either...

I have some sales data and in the quantity sold filed the qty of the item sold is combined with its unit of measure. For eample; 5 ea, 10,000 PAC, 125 EA,...

Please help I am new to Access. I get a Aggregate Funcition error from Trvl_Start when I try to run this where am I going wrong? SELECT Sum() AS Total,...

Gross Order Total and Sales tax Total in Main report are off by a couple cents. ----Order Details Table---- OrderDetailID - Primary Key - AutoNumber - Long...

I am building an expression where I add the first 4 months of sales so that it is contained in one column. However, when I run the query I receive all the 4...

I am looking for a query that will show the last two occurences (by date). The date are within a range of the year 2000 through 2006. The issue I am coming...

I am trying to setup a form which shows the clients info & only thier dogs info. My goal is to be able to us a drop down combo box that will bring up each...

Hi, i wanted to create a query that would run and like a parameter query you have enter a criteria and then run the query, is there a way of creating a...

Hi I am new to Access and I need help! I am trying to create this query and so far this is what I have: SELECT Sum() AS Total, tblAttendan.TRVL_START FROM...

i have a table tblFundAccruals w/ field names IndexNum, PID, Month, DueAmount. .. these amounts will be accrued every month plus the unpaid amount in arrears...

Hi all. I'm new to access and trying to write a contacts database for a college project. A contact can have many disciplines, and each discipline can have...