I've been tearing my hair out over this, so any help on this would be
greatly appreciated and, I'd also start to look less like Opi from Family
Guy!!!!!!
The first three arguments work perfectly, however where I get stuck is

I have two columns: DivisionID and RegionID - there are sometimes more than
one Region per Division, so there would be for example three records for one
division if there were three regions in one division.  I want to still have 2
columns, but a only one record for each division.

I created an expression to fill null fields in one of my tables with a
designated default date using the IIf function.  The null fields were filled
but when I apply a <=[question] criteria, records containing the default
dates are not always included, depends on the criteria date ...

I need to create a fixed width text file in the format:
Learner details record
Learner aims record
Learner aims record

I must write a report for a dance competition, and a set-only approach
escapes me.
routines, dancers, scores:
- routine n <-- --> n dancers

I want to count the number of cmdes from table CMDS and update field
CmdNb in another table CUST
UPDATE CUST SET CmdNb = (SELECT COUNT(*) FROM CMDS WHERE CUST.id =
CMDS.id);

I have the following query:
SELECT 1402 AS ACCOUNT, [YY Saldo 1402].SummaförAMOUNT AS HB, [YY Saldo
1402].ACQ_AV_ACCRUED_INT AS SESAM, [HB]-[SESAM] AS [Diff HB SESAM]
FROM [YY Saldo 1402]

Hi I have a very basic phone records file which I download and run a
query on. I have a couple of expressions for formating and calculation
to make the data show in minutes. It all looks great until I select
the totals button in the records which gives a row at the bottom of

How do I limit my query's reults, if i want the user to enter in the
filtering critera.
I know that you can the box-brackets [ ], but what if you only know
part of the filtering field.

could you please give me some more info on how to do the above.
Thanks

I am trying to workout a way that I can run a query that will search a number
of columns and bring me the latest date back for that id number
example
AddressID Appt1 Appt2 Appt3 Appt4 Appt5

Hai,to every one
here is my question
I have designed the coding to collect the feedback report from the user
,which includes Name of the user, staffno and comments.But when I click on

Playing around with Subqueries I've noticed that whenever I do anything to
change the query in the Design view, a bang (!) appears just in front of the
brackets that section off the subquery. Then I get an error about the ! when
I try to run the query

I am looking to move data as a whole, not sure if what I am looking to do is
possible or just wishful thinking.
Setup:  I have a database with several tables, some are background type
information, using SSN number as the primary key (only one entry per table).  

In my job I currently use Excel to track information.  I have a group
of employees that provide treatment to a large list of patients each
day.  Every employee keeps track of their treatment time in minutes on
a schedule sheet which they turn in at the end of the day.  I have a