What is a good date function that I can use to grab the 13th month in a period of time? In this case it would be January 06. I want this to be an automated...

I have a query with 2 fields. Field one contains either a number or words. Then I have another field that contains just words. Example: Field 1 ...

I have a query with 2 fields. Field one contains either a number, a blank record, or a word. Then I have another field (field 2) that contains just...

I am running an update query where I am updating one field in a table with the contents of 3 fields from the same table. The query works fine but it updates...

Hi, Please help... I have a query that looks at Customer Details and in this query is a field with the Job Type, There are a number of Job Types and what I...

In my database I have a table with two columns: "DocumentNumber" and "DocumentDate". For...

I have a imported file that reads all fields as text. My problem is that I have 3 text fields and need to turn answer into 2 date fields by an append...

I download a file that contains text as you see below. I need to remove the .... The problem is that the "." is not really a "." its "..." as one. So if...

Hello there I need to build a complex query which have relationships from 4 tables. and this query must be updatable. Because the data on the tables is very...

Hi, Fisrt of all - I am fearly new with Access.... I have a database for orders. It includes NeedDate and DeliveryDate. Now I am trying to make a crosstab...

I have 2 tables--employee table and department table. Each with "division" and "cost center" fields. I want to compare both fields in employee table...

I need to find all of the oracle servers running on our network, running on various machines. Is there a tool available that can seek out these servers Name...

i want to contruct 2 PIE Charts which shows the failure rate of an automobile. 1:if a particular component of that automobile fails at 10th run and the...

i have a series of steps which start from complete dismentaling of a machine to re assemly and checking of it.like first a machine is passed through...

Hi, I have a query that I email out as a excel document. Is there a way to set the page setup to landscape, and margins to 0, this way the recipient doesn't...

Hello and thanks for taking the time to help. I have two tables ('lastvalue' and 'percentile'). These tables contain among others fields as...

I have 3 fields in a querry. I have field number 1 in a querry (called Original_SVS_ID) that can contains: hurricane undeliverable high value one...

I have 2 tables that I'd like to compute the Price to sales ratio 1) daily prices with fields of dDate, Tkr, Price - going back 10 years 2) quarterly sales...

I have a ONE to MANY relationship with Contacts and their multiple Addresses. I know how to make it so that the ONE record shows up only once when I use a...

Hello, I am trying to password protect my opening form and log the information. It works great but one thing. When I close the database and reopen I get the...