When creating a new Query in Access, how do you go about making the new query
window default to the "SQL View" rather than the "Design View"?  I almost
never use the "Design View" anyway.
Regards,

I have much trouble in adding a column of sequencing numbers to a totals
query to select a unique record.
Instead of this I have joined two columns into a new one, and in this case I
have used the "CStr" function to convert the date into a text string.

I've posted this question before but without being able to get my problem
solved, very greatful to answers!
I'm having a table where I have variable values (in a field labeled amount)
charcaterised by a set of properties which make each value unique, these

Good afternoon
I am attempting to construct a query, but have not succeeded in
structuring the expression.  Anyone's help will be welcome.
I have multiple entries for each date, called DateEntered, lets say

I have a project with a group of unknown queries (views).  I don't recall
ever noticing them until a few days ago, but that doesn't mean they weren't
there.  Here are a couple of the names:
dt_addtosourcecontrol (dbo)

I am making a Statement form for customers owing money for various months.
I want to use the one query for the basis of the statement report.
For this I will have to use two parameters, one for the customer and one for
the month ( Format([InvoiceDate],"mmmyy")).

I've one APPEND query, but I use another 'SELECT' query for selecting
records to be inserted... Following is the query...
PARAMETERS p_MonthLastDate DateTime;
INSERT INTO EmpInctStats

I have a query that wont open in the designer, Is there any way to get the
sql text programatically with VB?
I've tried using AccessObjects but so far can't see how to do it. Access
help is of no use and so is every Access book I have.

I have converted Ms Access backend to SQL server. One of my queries fails to
run. when i click on the run button nothing happens. When i run this query
fromt he report it gives me an error"field is too small to accept data". The
query is a select query with some 30 fields.

I am building an expression in a query that concatenates several fields
together into a fixed width string.  The problem I am having is with the NAME
field.  Name holds 27 characters in length, using characters 11-38 of the
string.  If the name is less then 27 charcters I need to ...

I am trying to make a table that takes a client's Date of birth and the
date/time of arrival and calculate an age. I have successfully used a
function that calculates this data (from seperate tables) and posts the
client age in a new table. I have used this function MANY times ...

Hi all - Access 2003 - XP Pro
I have a form which displays parts/product information. In part of the form
there are controls in which specific calculated data is to be displayed, and
I am not sure if the calculations should best be done in the query or in the

I have to implement some tables for our shipping department.  I know the
table that holds the shipping data in our system, which will be pulled from
the system using ODBC, but I have a few problems in figuring out the best
way to accomplish this task.

I want to add a column to a query to calculate the medians of one field (#
Days Open) in a table.
Any help would be greatfully received.
Thanks

I am using the function Format([myDate],"ww") to get the week number from
certain dates.  I can get a number from 1 to 53, but it there any way to make
numbers between 1 and 9 appear as two digit numbers, eg. 01, 02, 03......
Thanks,