Big issue here trying to build a query that lists records whose serial number DOES NOT appear in another table. In SQL, would use the condition: WHERE...

I have a crosstab query that I've created for a Rolling 12 month report. It works great but now I need to add another value to the query. I know that you can...

Hi, I have a table with around 350,000 rows. I have 3 lookup columns to parent tables. I imported another 30,000 records of data to a new table. It is the...

I have a table with flow rate and datetime attributes. I used a "select Min(flowrate) from table group by Datepart(day of DateTime)" query to get the min...

I am wondering, is there a way to display the result specifically on the Pub? .. For example, i group all the same name catagory and then only those i want...

I am using the following which works. i simply do noot know where to subtract a person's lunch in the calculation. The field is called 'lunchTime" and is...

I don't know if this is possible in Access - I can do it in Crystal but haven't been able to figure out how in Access. I have two tables - one shows the...

I have a Datetime field that I need to relate with another field but the seconds portion is messing me up. What function can I use to strip out (or reset to...

Read a lot of posts but ... One table called Address has field cell and field email. no data in those fields. Second table called Cell has field cell and...

I have a form with a StartDate and EndDate (formatted to Short Date). In my query, I want to query for records that are 'valid' per the dates on my form. If...

Hi, I have an database with more than hundred rows and columns Column 1, Column 2 and Column3. I would like to setup new query with DISTINCT function just...

In Access Help under Performance, it says that you can improve query performance indexing any field used to set criteria for the query. It also says to index...

I have 31 columns in a table and 1000 records with several x's in each record. How can I total the x's in each record? I know I can use a query but I don't...

I have tried to post this as a WHERE and or IIF statement question. It should be not this difficult a query. I took my main table NameAddr this file contains...

I have a table with a date field that the user left blank sometimes. Now I need to use it to find out how many monts between todays date and the date in the...

I am submitting data to a source that says the field is limited to 10 items. Items are devided by commas (","). Is there a way I could tell the query to go...

I have two tables, one contains the highest score each team has ever achieved - this has been manually built loaded from the leagues historical records. I...

I understand the issue with Y2K, but I wanted to format a date that reads 02/04/06. ACCESS did not provide a format for the aforesaid date format. How does one...

Hi, I have data like this 03/14/05 13:09:42.0 0 CON 03/14/05 13:10:19.0 1 CON 03/14/05 13:10:21.0 2 CON 03/16/05 00:57:42.0 3 CON 03/16/05...

Hello, first that I have this kind of problem. I am trying to mail merge with a query. I select the .mdb and automatically Word displays wich Query or Table...