We have a program that just moved to a MS SQL 2000 back end from Pervasive. The old Pervasive backend would allow the same string in the primary key as long...

Hi All, How can I display current date and time in query output? Is there a way to do this? Thanks in advance

I have a group of engineers polling servers to learn what Middleware is running. I would like to give them a dataset to update as they get the info from the...

Hi all, tia... As of now I do this via DAO Recordsets, but I assume there must be a way to handle it via query (also assuming that a query will always be...

I am trying to create a tool for yearly employee performance reviews: each employee is ranked on 5-10 different "competencies" and their behavior related to...

One of the control on the form is FldMon. It is a number field. There is a calender on the form. It is ActiveX Control: Calender0 Class is...

Hello, I am using Access for a university assignment. I created a query to find the most expensive items from my table. I have sorted the query results in...

I need to perform a query that will show me all of the items that were posted between two separate dates,such as 05/26/2009 - 10/24/2009. Can anyone please...

The following is one of the fields in a query. Expr3: IFF(DateDiff("d",,)=14,( & " X" & " 12"),( & " X" & " 6")) and are datefields in the table...

Hello, Is there an easy way to duplicate a record in a continuous form? More yet, how would you write a query to duplicate the current record based. I would...

all my database are developed in Access 2003... When viewing the queries in 2003 there is a 'Description' field. This is always viewable for all queries AND...

Hello All I'm sure this should be simple - but can't seem to get it! I need a query that takes various integer values (say 'monthnumber'), and returns an...

using access 2007, i have a query that shows Event Type State Date/Time* DayCount ALARM ACT/UNACK ...

Access 2003, XP pro, semi-novice I have a table "Expression" where records are similar to the one below: & " " & & " is " & & " " & & " " & & " has a...

I have an access database which has many queries which are leftover from various tests and temporary data extract needs. Is there a tool which can tell me...

My query is based on one table listing employee names, ids, and salary. In my query I used the min funtion to display the lowest salary; however, I'm not...

I have two related queries/tables. One: TRANSFORM Max(MeritsMain2Total.Total) AS MaxOfTotal SELECT CadetsName.CadetID, MeritsMain2Total.CadetName,...

I have a query consisting of the fields productid and customerid.It shows the products bought by the customers.These products are bought with...

Hi there everyone At present, I setup the function that calls the Open DiagBox, which works well, with the exception of including the shell commands that go...

I have 2 question: 1. I export data from excel 4.0 to Access 2003, in Excel my data have text format, I want change data to date format... example my data in...