I need to know how or if you can create query that automatically prints a
record when you run it.

Hello I know its in this thread somewhere but I can't find it.
I have a query that return a 1 or a 0 for a given field. I would like it to
return a text value:
iff([pre sale or Post sale]=1, "Post-Sale","Pre-Sale")

What would be a good book to learn more about SQL language and is there a
criteria that I could use to get just one result even though the item is
duplicated in the table that I am using.
Say customer 655153 is in a table 13 different times, how can I get that

I am running a query on Sales data, which contains Opportunity Status and
Fallout Reason field.  In the Opp. Status field, the options are Closed or
Closed-Won.  In the case where the status is Closed, the Fallout reason will
have a list of various different reasons, such as ...

Hi. I'm going to try my best to explain my problem so stick with me. I am
trying to make a way to base my employee's salary off of Pay Type (Weekday,
Weekend and Holiday), Month and Employee. What I have done is created 3
tables as followed:

How does one avoid parameter queries?  For example, I have a query with two
date fields, and a calculated field [FinalDate]that uses an IIf to determine
which of the two date fields is more recent and to set FinalDate to that
value.  The query works fine.  Then when I specify a ...

I've been trying to export the output of a query as text (csv) using the
text export wizard. When I get to end and hit finish I get "Invalid
Argument". I can export as an excel file fine but not text. Of course it
doesn't tell me what argument is invalid. Any ideas?

I am trying to make an automated monitoring tool for my IT staff to view. The
server I need to query has two files that need to be recorded daily, a db
dump and a transaction dump. I want to make each of these entries be
automated so it sends this information to a Access 2003 ...

I am trying to convert a string such as 071505 in a query in Access to a
date. I used all of the date built in functions in Access 2003 but none seem
to give me 7/15/05 or anything accurate. Any ideas?

I have a data set with 3 columns in a table: Amt, Percent and Type.  Any
given row may be categorized by a Type = 1, 2, 3 or 4.  I have a defined item:
'AdjAmt'.    AdjAmt should be equal to Amt * Percent WHEN the row Type = 2
AND we are in the month of JULY.  Otherwise AdjAmt is ...

I am trying to setup a query that returns the number of occurences in a field
based off the total count of records. For instance if i have 60 records and
out of those 60, 2 were completed by user A, my query result would return the
number 2. Any help is appreciated...

I have a text field containing a number of model numbers and they are
separated by a comma and a space.  Is there any way to count the number of
model numbers in the field and add up all the numbers of records?  Any
suggestion to this issue is appreciated.

Intend to sum a series of values for each day of a particular month.
This is the query that didn’t work. The result just gave a list of the data.
SELECT [AWY003~1].Date, [AWY003~1].Time, Sum([AWY003~1].head) AS SumOfhead
FROM [AWY003~1]

Despite having followed the Help menu suggestions, my MS Access query still
contains way too many rows of data.  Suggestions, anyone?
Douglas Eckert
douglas.eckert@mcconnell.af.mil

This seems like something that should be simple to do.  Trying to query 2
tables with a one-to-many join.  The first table is projects and the second
table is comments for the projects. (See example below.) The join is between
Project.ID.  I have tried using Total:Last and Sort ...