Queries

Cross Tab Query with DateSerial
Hi, I am creating a cross tab query to capture data for each month of the year. My query is similar to the following (This should give me all the completed courses by month). NOTE: I have numbered the queries for reference (1) TRANSFORM Count(Courses.CourseID) AS CourseCount SELECT Year([Courses].[CourseCo... 28 Jun 2008 11:40

Running Sum Error in Query
I have read several posts and can not figure out where I have gone wrong - ANY HELP appreciated. I get an #Error in the RunSum Column of my query results Number Pct RunSum 11 42 7 512 300 6.36 #Error 15400 P0H 305A 5.51 #Error 08922 02011A 4.61 #Error ... 29 Jun 2008 14:12

Need to find latest date in a query
My query has two fields [prop_id] and [comsdate] where the comsdate field is a date that periodic, recurring maintenance was done on a certain property. In some instances, the property is listed twice because I had used a criteria of >= 1/1/2008. My problem is that i want the query to list all properties that I man... 27 Jun 2008 19:21

Converting text to a number in query
I'm having trouble with a conversion in order to get a formula to work. I have text that = numbers. Example: G++=1, G+=2, G=3,G-=4,G--=5, etc. I need a formula to convert G++ to 1 so that it can be totalled. Thanks for any help. -- SS ... 2 Jul 2008 11:54

make query to return a subset only if not in another subset
I have a table in Access 2003 that list all my accounts, what day I call them, and what week I call them. Some accounts are called every week (weeks 1, 2, 3, and 4). If this is so, the table has separate entries for each week: Account # Name Day Week 3400 Chez Andre M ... 27 Jun 2008 19:21

find all 5 fields with Max date
Hi I want to create a query that will return 5 fields that have the max date or latest date. I can't get the following to work though. Select Drug, Location, Total_On_hand, min, max, Datetime From InMachine Where Max(Datetime) I don't have to show the Datetime, I just need to see in all 200 locations and w... 27 Jun 2008 20:23

same error
I made a new table pasted in the records of unique company names and still get the cannot delete from specified tables -- ken "ken957" wrote: This is the SQL of my post. I changed MinOf to FirstOf but same result DELETE CompanyNamesCompare.*, CompanyNamesCompare.IBAMAT_Company, Company... 27 Jun 2008 21:24

SQL of above
This is the SQL of my post. I changed MinOf to FirstOf but same result DELETE CompanyNamesCompare.*, CompanyNamesCompare.IBAMAT_Company, CompanyNamesCompare.ID, CompanyNamesCompare.ID FROM CompanyNamesCompare INNER JOIN NodupsIBcompany AS DDD ON CompanyNamesCompare.IBAMAT_Company = DDD.IBAMAT_Company WHER... 27 Jun 2008 16:16

Delete Query Cannot delete from specified tables
I have a very long table using a limited number of company names, I have another long table with many of the same or similar company names. I wanted to make a table without duplicates of the the company names used in the first table, then work on establishing relationships with the names from the second table.... 27 Jun 2008 16:16

Eliminate 0 value in crosstab
I have a data dump (over 110k info) that is now set up as 3 crosstab queries. I then have a query to join them all together to see all informaition needed. The problem I am having is there are some 00 values that are causing my AVG's to total instead. I realize that this is a normalizing issue, but this data is... 27 Jun 2008 16:16