I have several fields in my query. i am trying to write this formula
([nMLO]<2) / (total of the xFin column). Ill try and explain this the best I
can. nMLO<2 as a field should be ok.-----I have another field xFin. I set it
to xFIN=1 If I can figure a way to add up all the ones in ...

I have a query that looks like below and I want to add a new column that
combines the projectID and another new column that numbers each entry
incrementally by projectID.  I need to know how to number items in a query by
projectID.

I ask this question earlier and I didnt make myself clear. Hope you can
understant me this time.
[nmlo]<2 with this expression i am trying to count the number of records in
nmlo who are below 2. The numbers in there will range from 0 to 100.---

Good day,
First, here is a list of tables, PKs and associated forms
TblMuseum, MuseumID, frmMuseum
TblArtifact, ArtifactID, sfrmArtifact

I have a table called Contacts.  I have another table called Insurance.  I
want to show in a query which Contacts have a particular insurance.  If I
query the Contacts table ONLY, I get all the records.  If I add the Insurance
table to the query, I get nothing.  I'm sure it has ...

I have a frminvoicepaymentssubform with the following controls:
MaxPaymentDate =DLookUp("paymentdate","tblinvoicepayments","[invoiceid]=" &
[invoiceid] & "And [paymentid]=" & [MaxPaymentID])
MaxPaymentID =DMax("paymentid","tblinvoicepayments","[invoiceid]=" &

I have a table in which I would like to combine two fields. The fields are
LastName and FirstName. I would like to create a new field called FullName
that would have LastName (space) FirstName.
How can I trunkate the data copied from LastName and FirstName fields during

I have a number of check boxes in a query, I would like to dynamically alter
which check box will be displayed by using a combo box in a form. I am having
a mare with this one everything I have tried doesn't seem to be working heres
what I have for each check box in Criteria:

I have a tblCandidates.  Calls are made to candidates.  The date the call is
made is stored.  The result of the call is stored, i.e. "message" left.  The
Result of the call is stored, i.e. "CO".  I would like to cfreate a report
that will look like this:

I have a form with an input box that has a default value set.  I then have a
query that is using this value as criteria (Forms!frmTest!txtValue).  When
the query is ran the value is not being picked up in the query.  Its showing
as empty.  If I physically type in a value in the ...

  ID SDate TenantID State Parm Notes
     1322 19/09/2005 13:52:29 MRC Raise T1 0 Man: £2200,L141
     1323 19/09/2005 13:52:36 MRC T1 Sent 0 Man: £2200,L141
     1324 19/09/2005 13:52:44 MRC L1 Sent 0 Man: £4400,L262

Is there a way to use the LEFT() function to take all the characters until a
space is encountered?
I am trying to normalize data I imported from another program and the City
State and zip are all in one field there are no comma's.

I know it's going to be a real simple answer but I'm trying to exclude
records based on the last three characters of an 11 character text string.  I
want to show all records except those that contain "CM[and any number 1-9]"  
It could be CM0 or CM1 or CM9 - I don't want to see ...

I'm using a Form to have the user enter/select search criteria, eg a
property's address, then use the query criteria expression: Like "*"
[Forms]![SearchCriteria]![StrAddress] "*" , but the query returns no records
(yes, there are valid records to be found).  How do I use a ...

In my query there are a number of Check Box Fields. I would like to be able
to filter out all the other check boxes when a check box is selected from a
combo box in a form.
Heres how the criteria should go: