I'm designing a "site information" database and I'm hoping someone can help
me with the following questions/issues I've come up against, please ?
I've created a form based on a table to display site information on a
one-at-a-time basis.  I want to be able to search and display the ...

I inherited this database. Each ID may or may not have errors. I need
to find the Total Errors/ID for each month. Each ID is unique
There are two tables as follows:
tbl1 contains ID and Date

Just wondering if anyone knows whether I can add a prompt to a parameter
query to ask whether to show that field or not ?
I know I can tick (or untick) the box in design view to show or hide the
field, but I want users to have the option to display on a form, I just can't

I want to export an existing query (Province Name, District name, Commune
Name) based on the selected value in the list box. I create a criteria
string
Dim stgSQL As String

I want to compare YTD totals for '06 & '05. The expression below produces my
current YTD totals based on a date entered:
Cur YTD: Sum(IIf(Year([cases].[date])=Year([Enter End Date]) And
[cases].[date]<=[Enter End Date],[count],0))

I have the following code in a query expression:
IIf ( [tbl_RemitDays]![Frequency] = "Daily", Date(),  IIf ( [tbl_RemitDays]!
[Frequency] = "CD" , DateSerial(Day= [tbl_RemitDays]![Days] ), WeekDay(Day+
[tbl_RemitDays]![Days] ) )

I may have asked this question to the wrong group and if so, please
direct me to the correct place.
I have a query named "sumquery" on a single table named
FDNS_Production.  The query looks for date parameters using the Between

Ok,
I don't really know how to accomplish what i want.
I have a query that returns results based on an audit.
The query returns results of the last three audits in a form Like this

I have a linked table in which I can't change the data types and the
amount field is a decimal data type. From that table I combine some
other fields from other tables with a make table query. Ultimately I
run a crosstab that gives me the message (Decimal data type doesn't

I have a parameter query in a back-end Access database that I would like to
be able to execute from front-end Access databases, using ADO. The query
creates a view of specific fields from about 15 tables and limits the
returned records based on supplied parameters. This allows the ...

I must be missing something
I have a query created in design view which pulls the following fields from
two aliases of one table:
a.ReportDate

Hi group !
I have a problem with a crosstab query in Access 2000.
I want to pivot by month.
The table contains only data fromthe last 12 months (including the

Hi Experts,
Is there a way to add an autonumber field to a query in Access? What I need
to get is an equivalent of a report unbound field set to =1 and running sum.
I need the query to return i.e.:

I just happened to read the last post with the same name and learned
about the "GROUP BY" query. I am enclosing my SQL and have the
following questions. This is a trial DB with four tblSapDown2006
records and two unique tblMaterialMaster.LocalGroup categories.

I'm using Access 2003 and am trying to use a combo box to allow selection
for the criteria of a parameter query.
I have created a form with the combo box on it andd are using the following
syntax in the criteria field of the query: