I have a loan database that I want to write a query to reflect all active
loans with or without a current month's payments. In other words, I want it
to select all active loans even if there was no activety during the month. I
have 1 query that pulls out all active loans; ...

I have table (tblReceipts) that has a receipt field with the data type set to
text.  This was done because receipts are sometimes entered as 1a, 1b, 1c, 2,
3, 4a, 4b etc. depending on the type of transaction that took place.  I need
help setting criteria in a query so that I can ...

Folks:
This is such a simple query - and yet it's driving me crazy!
I have several fields in a table, and I use an iif function to set a new
field based on the others.  To remove any problems with data type, and

Is there a way to pass parameters to a server via ODBC Pass-Through queries
in Access?
Example:
Doing a "select * from ThisTable" on a certain table in Oracle 10g at work

I want to create a query where:
FIELD 1 CUSTOMER ID
FIELD 2 CUSTOMER NAME
FIELD 3 OPTION 1

I am tring to find duplicate records and i have that working just fine but i
would like to take the set_version and within the duplicate records only show
the records that are not duplicated under the set_version column. I hope this
makes sense. any help would be great. I have ...

When using an option group in a form by assigning each catagory a number.  
How can we pull up the catagory name instead of the number in a query.

Is there an equivalent of Excel's AND() function in Access?  I have looked
for threads related to "multiple conditions" but they all seem to be about
multiple conditions yielding the same result.  I would like have my formula
yield a certain result only when two or more ...

I'm trying to run following query:
SELECT DBA_t_order.t_order_faktnr, DBA_t_order.t_order_ordernr INTO _table1
FROM DBA_t_order
WHERE (((DBA_t_order.t_order_faktnr) In (SELECT DISTINCT

I have a date field in my database that represents the date a payment was
made.  The date can be any day within a month.  There's also a field
representing when the payment is through, which should be three months later,
on the last day of the month.  I'm trying to update the ...

I would like syntax query for delete duplicates records without data in the
Field1:
Ex:
Id   Field1   Field2   Field...

I have a crosstab, when I put the normal date the information shows but when
I try to change it to a relative date, the query is empty and no values show.
HELP!!!!
PARAMETERS [forms]![PDate]![StartDate] DateTime;

I am writing a query that combines 2 budget tables.  The only problem that I
am having is the following:
table Budget Account Detail
fields  Account Number

A combo box was assigned as a criterion in a query like
[Forms]![0019_WorkPlanConsult]![Combo6]. When I updated the combo box and
tried to open the query, Access shows an error message "Microsoft JET
database engine does not recognize  '[Forms]![0019_WorkPlanConsult]![Combo6]'

I have a form from a table - i have a field Staff name and a field National
Insurance Number on the form;
because it is linked directly to the table and not been created through a
query i want a way that when i input the user name the NI number