How can I create Primary Key autonumber field by SQL Command? For existing data start from 1 and end at the end of rows Example: Field Name : Id Auto Number...

() why this sign appears in cross tab query

Where can i find example help web page explain crosstab query? thank you

Hi, I'm trying to match up data between two tables - Table 1: Last name, First name, Address, City, State, Zip, Date of Birth (approx 45,000...

I have a table with 41,000 individuals (their first and last names) and a separate table with 45,000 individuals (with first and last names and dates of...

I have a query involving 23,000+ records (where 5 numbers are averaged per record). Is there any way to speed up the process? Thanks.

I need to calculate the average earnings for employees for their last five years of employment. Does anyone know how to do this? Some employees will have...

I need to calculate the average earnings for employees for their last five years of employment. Does anyone know how to do this? The table is set up with...

I need to calculate the average earnings for employees for the last five years of their employment. The table I'm working with looks like this: employee # ...

Thank You and I hope You Enjoy answer this Difficult Question I have form (Continuous) and I’m using filter to filter data : The date is like this: Dates ...

thank you I have 2 dates: Tables1 Begin date end date Company ID 10/12/2004 20/12/2004 hp 1 15/12/2004 17/12/2004 ...

Thank you begin date end date subtract number in days 1/1/2004 5/1/2004 4 15/1/2004 20/1/2004 5 I...

table 1 ID BeginDate EndDate 1 1/1/2004 5/1/2004 2 10/1/2004 20/1/2004 3 10/2/2004 ...

Thank you Query 1 (avilable) ID from to RN NN Total company 1 1/1/2004 ...

Thank you query1 (table1) Id companyname Attemployee 1 Hp 10 2 ms ...

Thank you table 1 ID comapany empname 1 ms a 2 hp b table2 ID ...

Hoping for some help here. I have two tables in my database that I'm trying to join. A simplified example TABLE1 Article Year 1 1995 2 ...

Don't know if this is possible @ all, as from searching the newsgroups I can't find a particular article that is requesting this. I have two tables as per...

I want to make a query on an OrderDetail table that sums the sales for year 2007 by customer. This query will be used to make a table, the table will be used...

Hello all, I am trying to create a query in which data is displayed for the current month beginning with the first day of the week, first week of the month...