Hi all, I have recently upgraded to Office 2003, from Office 2000, before the upgrade I had built variouse databases carrying different tasks, but since...

I am setting up a querie to check transactions for a fiscal year end. For example, all transactions completed after June 30. I need to complete the querie to...

I have a form based on a simple table, where data gets inputted on a real time basis, with the following fields: time and color value. Example: Time Color...

Can I run a pass-thru query from VB using this command? I have a saved query that works. It pulls data from our AS/400 just as it should. It works...

I am trying to create an update query and get the message shown in the subject when I try to run it. Table 1 is linked to Query 1 by three fields. Query 1...

I have a table (TableA) that contains price coding data (Product#, Code#, Price) as three different fields. The Same Product# could have multiple Code#'s and...

Howdy. Here's my scenario. Fields in table: SecYrsExp SecPts SecPts is based on SecYrsExp. SecPts has a max of 5 points. You receive .5 SecPts per year of...

I have access 2003 running against a SQL database and I created a view that returns the last few characters from a text column (with an AS statement) Now I...

OK, here is the problem. I have a file that contains over 200,000 records, primarily because each field is imported as a separate record. For example, there...

This seems like it should be simple yet I can't get it to work. I want to run the following query based upon a user selected date range (OsObj.Datum) being...

I am trying to analyze four date fields and return the most recent date in a separate field. The four fields being looked at can have a combination of all...

I need to have a form that users can click on radio buttons for the criteria they need. I need all the employees listed, all programs listed and all model...

I have a DHTML application running on IE 6.0 that has a checkbox. When the checkbox is checked and submitted, the value on the server-side comes in as -1 or 0...

I asked this question some time ago but I since lost the emaila and I cannot rfind this on the posts anymore. How do you do calculations between rows? eg If...

Hi Everyone I just wanted to say a really big 'Thank you' to everyone who has helped me over the past year. Some of you may remember answering my many...

Throughout a season a horse will run on a number of occasions. On each occasion that the horse runs it will carry weight (measured in pounds). The horse...

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 guess this question could go in a few places, but I'll start here. I have two queries in an Access database. If I run them from within Access they return...

Hi Is there any way that you can run multiple queries in access as you can in say server. delete * from tblOne delete * from tblTwo I would like to delete...

I want to use a value stored in a table as a column alias. Look at the pseudo code below. --- SELECT a.Name, a.Dim AS b.DimHeader FROM table1 AS a INNER JOIN...