Hi,
I have a function in a query which i say if the number in the field is <1,
then it would print out field A.  If not, then it would print out field B.  
However, i keep getting #Error in the field, whenever i run the query.  My

is the software bad?

the result of 'WHERE field IN (x, y, z)' dosn't take care of the order of x,
y, z.
is there a way to do exactly this: return records in a given order (not ASC
or DESC but x, y, z? i was surprised to see, that something like

Per Roger's suggestion, I've converted a count query to a table and then used
that table to do an update.  The issue I have now is the count query and the
criteria of the dates.
Here's a history of what I have:  a table tblNoShow that lists the times a

Hi guys,
i need to build  statistical bar & pie chart based on defined query i
code. some questions here,
Q1. if i define some depended queriese in code, "query12, query13"

Hi NG,
I cannot execute the following SQL-Statement on a Access-MDB:
SELECT  something,thedatetime FROM mytable WHERE thedatetime>'15.06.2005
03:05:00';

I have a series of dates (ie 1/1/2005 through 6/30/2005). I used the "dddd"
formatting to tell me what day of the week each date falls on (ie 6/18/2005
is Saturday, 6/1/2005 is Wednesday).
I need to list on a report only the information that is on a Saturday.

Hi guys, I have created a form in access which is used to search a
access database. There are 2 cities and each of em has 2 access tables,
I have successfully written the sql query and attached it to a macro
which in turn attached it to the search button on my form. Now my

I am trying to create an Update Query.  I have the following tables:
Table1
Accts    Item    ID
Acct1    01   

Im trying to do a Union Query (?) to combine multiple tables within a Access
database.  Each table holds different mailing lists for my agency. We are
using Access because it is a powerful program -lthough my tables are
non-relational.

I'm trying to structure a query that utilizes a sub-query to select all
records from tblTransactionsALL that do not appear in
qryTransactions-MultipleSponsorsCorrectBankerAllocations for a given
transaction number.  For example:

How do I word the where clause of an applyfilter macro so that it looks in
the contents of some unbound fields in a form for its parameter values?
Cheers
Rhys

I have a database that has to many records. To make it easier on me i would
like to view every 40 record. What type of a formula can i use for it to be
devided in groups of 40

I am running a query through a form by using [Forms]![myform]![cboname]
I used this for when I was using combo boxes, but now I am trying to do it
with check boxes but it isn't working. Does cbo stand for something
specifically related to combo boxes? Is there something like cbo ...

I need to run a simple Week over Week query for only one field (i.e. Total
Revenue) and I need the query, without input from the user, to automatically
return the data for the current week and then the previous week.