Queries

Set default value to 0 with ALTER TABLE
I have a large database that I need to load massive amounts of data. After appending the data, numerical fields apear as Null, as no default value was created. As I need to create this DB once and again, cannot set the default with Desing View for Tables. Traying to use ALTER TABLE "SET DAFULT" command, by ... 26 Jun 2008 04:20

DAO parameter length
When I run the code below an error is thrown at line 4 when the string sc.notes is greater than 255 characters. Is there any way to allow parameters to contain more than 255 characters? 1 Public Function saveSCToDB(sc As Scorecard, query_Name As String) As Boolean 2 Dim qdf1 As DAO.QueryDef 3 Set qdf1 = EMAT_DB... 27 Jun 2008 07:01

Ranking customer service metrics - Query issue
I'm building a report to rank a series of customer service metrics, such as call time and calls per hour. I have all the data compiled, but the person I'm building this report for wants to have a "grade" for each metric. They've given me the criteria for each grade in each metric, but for the life of me I can't... 25 Jun 2008 19:08

Parameter Query Wild Card
I have a report that is running a parameter query against a form that that has a list box. The list box gets its data from a table that has three records. Office1 Office2 Office3 I can run the report based upon which office I select in the field list however how do I add a fourth record to indicate a wildc... 25 Jun 2008 18:06

Average multiple colums
Hello, This DB is my first project and my question might be basic but never the less it drives me bananas. I need some help to put me strait again! I have a survey db with one table that countain all the answers to my 80 questions. Dept/Pay statu/Service Lenght/Year/Q1/Q2/Q3/Q4.....Q80 I have a query that do... 26 Jun 2008 12:34

Can't access design view
I am using Access 2007 and I have a problem that I've never experienced any any database I've ever constructed. I have an existing database that I updated to the new 2007 format from 2000. I can't open half of my queries in design view. I get the following error message: " is not a valid name. Make sur... 25 Jun 2008 19:08

Pivot Table Formating
I am making a Pivot Chart from Crosstab Query, Can I preserve the formating? i.e. when ever I referesh chart or change the critaria the data lables get lost. ... 25 Jun 2008 16:02

SubQuery Syntax
I received some generous help from the users of this group to get this far. This works great for me. UPDATE tblMain SET tblMain.PrizeAssigned = 1 WHERE (((tblMain.Weight1)=(SELECT Max(Weight1) FROM tblMain WHERE tblMain.PrizeAssigned = 0))); I thought I was done, but I ran into one more issue I haven... 25 Jun 2008 18:06

Mutiple Tables Duplicate Field Query
I am trying to write a query that will show me duplicate information from one field across seven different tables. Example: The Claims Tracking Number field from Table A222 matches Claims Tracking Number from Table A333 and A444. Is this possible? ... 25 Jun 2008 16:02

Not-in Query
Is there a way to run a query that returns data that is in one table to not another? For example, I have a table that gets imported that has client names. I have another table with details of the client names, but I update this one manually. Can I run a query that tells me new clients added to the imported t... 25 Jun 2008 16:02