I took over a mess of a so-called database and was wonding if anyone ever
tried to add fields to an existing query and the results wont so the fields I
added. However they did go into the grid. What is the problem or am I doing
somethig worng?

I am trying to append rows in a history query to my tables and I get the big
old key Violations error. It is the same old 3 that keep comming up and they
dont dissapear from the datasheet. This is the field that the join is
attached to with the primary key. The numbers below are ...

I'm not sure how to go about doing what I need, so I defer to your expertise...
I have a table which I need to query  1)  [DestName]  or 2) [TransferedTo]
depending on the value of 3) [Transfered]
Can someone help me with the criteria for this. Exactly what I need is this:

I am using a statement creating a calculated field based on values in two
fields of a query, [Fld1] and [Life] as below:
New Field: IIf([Fld1]="Val1*","ABC",Switch([Life]>=0 And [Life]<=30,"<30
days",[Life]>30 And [Life]<=60,"31-60 days",[Life]>60 And [Life]<=90,"61-90

Is it possible to have a more functional keyword search that returns results
based on the degree of similarity to the word or phrase typed in a text
box???  As of right now, I have a wildcard search (Like * & """" & *)  but
this will not return anything if a) the word is typed in ...

I created a simple parameter query, entering the text of a question,
surrounded by square brackets, in the Criteria portion of the Design view.
There is only one field that contains anything in the Criteria field.
It worked fine for a while, but now it's prompting me for the same ...

Good afternoon,
I currently have a query that returns the following format:
Report #                    dwg #                   dwg issue
1000576                    abc123                     A00

Good morning,
I am a beginner at SQL and have been unable to create the union query to
meet my needs.  I currently have two simple queries.
Qry 01

I have quite a number of queries that I use for gathering 'quick' info and do
not want to feed them into reports/forms.
Can I 'lock in'  a query window size when opening. I have adjusted the size
(in design and open modes) t hen saved but they revert to an original size.

I am trying to use TOP N to create a table and access does not like my code
can someone help me.
   Dim Num As Long
   Num = 2

I'm trying to create a querry that will allow me to run a report based upon a
specific date period
i.e. Report the number of calls received between 1 jan 05 to  15 Jan 06
I want the querry to prompt for the two dates  

I have a query which i need to help automatically changing.
I would like to automatically update the yes/no field in a query to yes.
Image of query below.
http://www.smithspace.co.uk/Query.JPG

I need to create a query based on a master-details tables scenario, where a
record of the master table can have multiple details records.
For example:
Master Table has 3 records with just 1 field called id (values 1, 2 and 3)

I was sent this document through Yahoo! Messenger. My computer cannot open
this. Can anyone help please?

can I use a parameter query to select the table for a query?  My table names
change each month when I add new ones based on date.  But - structure is
always the same.