Hello. I need to calculate the diference between diferente hours, but those
hours are are in diferente recordsets.
Like this:
-----------------------------------------------------------------------------

I'm looking to take the lesser of 2 data values (in different colums) but
only when the data is greater than 100.  Here's an example:
Col A    Col B    Desired result
664    0    664

Hello,
I've got a button that when pushed will declare my VarCurrQry variable as a
parameter that I then want to pass to a query.
From reading posts it looks like I need to set up a module but I'm getting

we have migrated the machines from one domain to another. after that users
are not able to access the access database simultaneously.
please suggest

I would like to ask for your assistance with merging two queries into
one to achieve a desired outcome.  The first query counts the total
occurrences for each ANI.  The second query counts the total for a
specific condition of each ANI.

Hello.
I'm creating a querie from another program. It register the time of each
employee get in and get out of work. But the machine that read cards and
register have problems, well it's not it's fault it'as just the way that it's

Please help!
I would like to place a command button called "Clear" on my form to delete
the current active record and enable the entry of fresh info (with a new,
unique autonumber).

This statement returns a syntax error, indicating I may have entered
an operand without an operator:
IIf([alteredchoice]="no", "Unaltered at Intake", IIf
([alteredchoice]="spayed" And [spayneuterbillingstatuschoice]="prior

I have used Access for a number of years, although mostly just basic
functions, and now have the new 2007 version.  My question stripped down:
I have a table with a few thousand lines of data, the important fields being
1) the SSN field, which will have multiple lines of the same ...

I am looking at a formula that I wrote that begins Sum(...
Problem Is, I NEVER PUT that at the beginning my formula.  MY Formula
started with IIF(...
Access rewrote my formula.  While technically, this new version should

...much less a SQL statement.
A supervisor several levels above my direct supervisor 'asked' me to include
a chart view option in a database interface I developed, with the underlying
query acomplishing the following:

I have a table made up of fields A, B, and C.  I want to update the data in
the table such that the value in fields C is placed in field A, and field C
is set to null.  thanks for the help -seems like this should be very simple.

I am working on normalizing a poorly designed database for a friends
contruction co. using Access 2003 or 2007.
I have a table with with each job info, the contractor info, and the owner
info.  Obviously this needs to be broken out into at least 3 tables.

I found the code below on here for removing hyphens and adding zeros to a txt
field.  However, where do I put this code?  How do I get this to do it's
work?  Anyways....if anyone has other solutions..please let me know.  All I
want to do is take a current txt field that contains ...

I am trying to create a new field in which it shows the sum  total of 10
fields (Charge Time, Charge Time 2, Charge Time 3, etc.); what is the easiest
way to do this?