Hi people, how to convert this value that was originaly imported as text data type to date data type like this, example: Original value as text Saturday,...

Is it possible to convert a number format to a text field. For example, when the user enter the number 56, the query format changes this to "fifty-six"?

I have a table tracking marketing campaigns and I am developing a query to pull information for one specific campaign. I added a prompt to the criteria...

With this statement: SELECT VariableTable.SectionName, VariableTable.VariableName, IF VariableTable.SectionName = "ADS" THEN VariableTable.TestField = ...

I have two queries - one that totals up labor hours by job number and another that then uses these totals in calculations. The problem I am having is that if...

How do I calculate the median in Access?

I have a table that I append with info on a daily basis. Sometimes, the company that provides me with this info is sending me updated info for previous periods...

I'm having a problem inserting a record into my access database with an auto-generated field. I'm using ASP to update my database, but when I try to insert...

I'm trying to produce a report that will show when a machine needs service, which is calculated by evaluating data in two tables - a service records table and...

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

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

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

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

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

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