I have several crosstab queries were the end user will be selecting a report
by month.  I have declared the parameters of [Beginning Date] and [Ending
Date] in the query and it works great but upon opening the report, it asks
for the dates twice.  I have read the threads on ...

I am having trouble with a query which involves multiple parts. It is tied up
with asset management. In a nutshell there are three components CRC(Current
Replacement Cost), ACC_Dep (Accumulated depreciation),WDCC (Written down
current cost). Other commponents include difference ...

Here is my report:
---------------------------------------------
            0 1 2 3
04/07   10 20 60 240

The select query I run returns a fully qualified result, suitable for
hyperlinking. I would like to create an expression in my query that returns
this information as a hyperlink instead of the text itself. The goal is to
have a hyperlink created in the datasheet that's returned ...

Hello everybody, I have a question concerning the "Enter Parameter Value"
window that opens when I run a query.
Is it possible to have that as a combobox so that a list of possibilities is
shown?

I need my query to remove all records from view (not show) with a specific
deadline date at 8:01 am in the morning on that particular date EACH day.  So
it would still show the records with that deadline date if someone ran the
query at 6:30 am or 7:59 am, but they would be GONE ...

I'm running a simple parameter query and it's working fine, however when I go
to load the report based on the query it keeps asking for the parameter over
and over again.  
The main report and sub report are based on the same query, but when I

I am want to build a 4 or 5 generation pedigee with access.  I  used the
www.allenbrowne.com method (used dog's instead of horses)
I am getting a Query Too Complex message box.  If I use 3 generations it's
ok but is there a way I can build 5 or more pedigree generation I get the

I have a module where I run an action query - here is the code:
   CurrentDb.Execute "q_FIN_DLM_Misc_Append", dbFailOnError
It is an append query - but it should always have at least ONE record to
append to the destination table, which is called t_Main

Ost Ocity Dstate Dcity price
A    B        C         D       34
A    B        E         F       45
X     C       L          Y      78

I have a table TReport which have a field called vcHeader.
In vcHeader is mention 3 different city names and some other text.
I now want to count how many time each city is in the table
and sort by how many times they are mention.

Hello, I have a crosstab query, for rows I set up the date range parameter,
how can I limit the columns, for example, depends on the rows date range, the
column will shows the differnt date record, but I only need 13 records.
Can I limit the columns?

Is it possilbe to create a Union between two or more queries?  I have created
Union query between multiple Tables but haven't had any luck creating a union
between other queries.  If yes, could someone please share an example of the
SQL that would be used to make such a query?

I have a base query (qselDEQExport2_Test) with the following SQL statement
SELECT qselChemDetail_W_Const.autWellChemDetailID,
qselChemDetail_W_Const.autWellChemID, qselChemDetail_W_Const.autConstID,
qselChemDetail_W_Const.txtConstituent,

I have two tables that contain some common fields.  
Table 1 has 11904 records and table 2 has 9126 records.  Table two was
derived from table 1.  I need to find the 2778 records in table 1 that are
not in table 2.  Anybody have any ideas?  Thanks.