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

How do I calculate the median in Access?

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

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

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

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"?

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

The macro pauses for the msgboxes when you run a make table query. How do I answer yes to the questions so that the macro keeps running?

I am trying to combine 2 fields to a field with an email address in it containing the fields e.g ID field and name field...

I have a query with 2 tables. They are order header and order detail. They are joined by Order Number where Order number can occur only once in order header...

Using the query below I am getting a strange result in the sub query on line 7. It returns an integer rather than a yes/no data type when run against an Access...

i need to use a sub query with the exists nomenclature. When I try this I get an odbc failed error. The exists sub query is exists (select svc, sum(doll) as...

I saw on a newsgroup somewhere to use the Select @@identiy query to retrieve the value of the last autonumber ID field added in a table... I tried SELECT...

I have created a query with specific data in it. I want to create an expression (or something) that gives me an 'autonumber' always starting at 1 and...

We have an extensive database with information pertaining to incarcerated individuals. On each form, there are fields with dates and identification numbers....

Hello All, I am doing some simple calculations on a form and they are not being generated correctly. Here is an example. Here is the data: HistContractPrice...

I have a date/time called REVDATTIM stored on a remote table in the following format 7/15/2004 8:05:09 AM. I have created a pass-through query in access...

I use a matching records table to select records in a query. This is a multi-user environment where all objects are in a shared database. 1. Is it possible...