I have two Tables in a database & I have made a Join between the Reference fields.However, the data in the two Reference fields that I wish to find duplicates...

Access 2000 I have a text field that has a combination of text and numbers. For example, in one field there might be "ex 500.00" or "el 650 ...

I have a date field that is formatted 05/12/2004. I need to use the date in a crosstab query that will group by month/year like 05/2004. I'm currently using...

Several hundred records in my database are duplicates except for the data in one field. I would like to create a new field or fields and somehow "append" the...

Hi Im using a command button on my form to open a parameter query. The query runs and asks for input and then shows the query results. How can I populate my...

Running Access 2000 I'm setting up a update query to calculate someone's age based upon two dates and insert that age into a table. So I want to find out how...

Hi Derek. It might help to understand how Access works, so you can then choose the best way for you to work. Internally, Access stores date/time fields as...

Hope someone can help. I have a query with a formula that combines a series of textboxes to form one result. There are a series of messages from 6 text boxes...

Hi all, the query listed below inserts the rows returned by a query into table tblTeamTask. How can I change this insert query into a delete...

I have a table of projects in my database, and a table of employees in a M2M relationship. I want to make a query that generates a list of projects that any...

I have a database that tracks projects for a given customer. Each project has a unique number- for each project we list dated status entries. For instance,...

I have a table that is laid out in a crosstab format. Using a union query i have been able to take the colums and join them but i can't seem to create the...

How can I compute very basic statistics for the results of a query? All I'm really interested in is counting the number of unique values in one or more fields...

I'm looking for a way to report on missing data. I've got a database that requires daily entry of 81 processes by individuals. I'm looking for a way to...

Hi, Let me paint a picture...Access 2000 frontend, linking to a SQL Server backend, inherited database, me - fairly new at this! :o) The developer has, for...

I am trying to show all employees. If I setup the query to show where they are equal it works. What am I doing...

Hi, I wanted to use a select statement to retrieve only the most recent date from a date formated column. The table I am using contains a large number of date...

Hi all, this may be a stupid query (sorry... couldn't resist!). How does one get to the underlying SQL in a query without having to pass through design...

Hi, Is there a visual basic command/language to run a query without having it open in access? What I am doing is picking items from a list box in a...

Hi, Using Access NT I need to filter all records out that are less than 10 in the total the query I have is as follows:- TRANSFORM IIf(IsNull(Sum()),0,Sum())...