From: "Tony" <tonymason@netspace.net.au>
Subject: Simple Query
Date: Friday, 6 July 2007 10:29 PM
Hello We are developing a database for our Aboriginal Community

Is it possible to get the results of my crosstable into a make table?
TRANSFORM Count(qTop3_Dates.[SERIAL#]) AS [CountOfSERIAL#]
SELECT qTop3_Dates.Hospital, qTop3_Dates.[Service Type], qTop3_Dates.CLINIC
FROM qTop3_Dates

My query looks at a textbox from a form as part of an IIF statement as
criteria in a query.
[CorpID] = IIF([textbox] = "a410132", Like "a*", [textbox])
When the statement is true, no records are returned, it should return all

My impression is that the following query should not run / work, but it does.
The query is
select *
from tbl1 INNER JOIN qry1 ON tbl1.id = qry1.id

I have 'Table1'  with 3 fields: MonthOfFlight (text 3 digits), USExchange
(number), CANexchange (number) and 'Table2' with 3 fields: Flightdate (date),
Agent (text), amount (number).
The layout of table1, should be like this:

Please help me. I want to find the average of the number of timestamps that
are in several tables. When i run the following, it will not work because I
can only use avg with a number datatype. (at least, that's what i understand)
I am just learning the syntax rules. the following ...

I am getting a compile error with the following function in a query.
dtdiff: DateDiff("d",[Query Name]![Date Field Name1],[Query Name]![Date
Field Name2]

I have the following dataset of numbers stored as text (I would like to leave
it as text so that the leading 0s are not dropped):
02345
1234567

I have to parse a string, C:\WINDOWS\Help\AGT0405.HLP, in a query and split
the FileName.  I have written expressions so that "C:\WINDOWS\Help\ show in
the folder path column.  I also wrote an expression to put the FileName into
a column, AGT0406.HLP.  But I need to also split ...

Is there a loop construct in Access SQL or is there a way to simulate
one?  Can I add a number of records to a table with one of the fields
sequentially numbered?  Without using VBA.
INSERT INTO tblTable

  This seems simple I but cannot figure out how to make it work.
I am trying to make a query with 2 columns.  'Record ID' and 'Reference
Record ID'.
Record ID is of a variable length and comes from my Table.

Need Help to convert a Pass throug Queries to other type??

I have a table with 2 million records.  [Partnr] and [nha] are the fields I
am working with.  [nha] is the next higher assembly to the [partnr].  
What I need to do is build a query that will take a [partnr] and find a
match in [nhr] and then find a match in [partnr] and then find ...

I create an unbound control on a form as either a text entry box with format
of Short date or using the MS Date and Time Picker Control 6.0. I then create
a simple select query with an expression field set to the value of the date
control on the form. When I run the query this ...

I am trying to refer to a value in a column of an existing combo box to set
the criteria in the SQL Statement Query builder for what is displayed in a
second combo box.
I have tried using the criteria statements: