If I have a record that contains a field that is a type-code and another
field a number, is there an expression that will allow me to state if certain
information is present in one field of a record, then change the quantity to
a negative value?  

Big Query Problem
I have This Fields In table1 (Design View)
ID        Autonumber PrimaryKey
ClientName      Text

When I create a query and make it an append query the query wizard asks for
the table to append and then adds the fields in the append to row but adds
square brackets around them and then when I try to run the query complains
about the brackets. Is this fixable other than going ...

We are in the process of trying to clean up a mess in our database. I have
used the find duplicates wizard to identify dups based on FieldA. Is there a
way that I can assign some type of an identifier to indicate which duplicates
match each other? For example, record 3 and record ...

I know this is a very simple question but...
I'm just learning SQL and have been going through a step by step book.  I'm
confused about what the difference is between an equi-join and an inner join.
Are both the inner join and the outer join just 2 different types of

I'm using a list box to create the parameter for a query and whatever I name
my text box, I get a request to reenter the parameter when I run the query.
The query always runs fine but I can't understand why I have to enter the
parameter twice. When i create the query I use the ...

I have the following query, which works OK in that it does give the correct
output, BUT when I initially run it I am asked for the parameter [Annual WTE
salary]. But this value is calculated, correctly, as another field in the
query. If I just hit the enter key the query runs, and ...

I have created a series of Parameter Queries in a db (Access 2003), using the
square brackets [  ]  to fill - in a Criteria.  How can I specify the maximum
number of characters allowed in the fill-in box, for example we have state as
two characters, MD, PA, Ca in the tables and ...

I have 2 tables joined by an acct # but diff data in the 2 other columns.  I
want to delete the row of information from table A that have a matching acct
# in table b.
ie:  appl   acct #   amount (table a)        appl    acct #     amount

I have an expression that seems to work fine, unless the [EndDateofRank] is
populated.  Iif the [EndDateofRank] is populated, it subtracts it from the
[AcademicYearEnding].  I can see that this is exactly what the expression
says, but not what I need.  I need the difference ...

I'm trying to use an expression to create a field name in a query.
I have an "Employee" file. that has fields "Sun", "Mon", "Tue" ... "Sat"
that contain their normal number of hours scheduled.
I have a function DayName(schdate)  that uses the Weekdayname(date) to get

I have a table that contains a filed called "Accnt_Code", the data in this
field is from 1A to 9Z, what I need to do is create a parameter quesy, where
the user may input, for example a group of Accnt_Codes, for example 1A to
1Z, and also be able to input individual Accnt_Codes, ...

               I've progressed a filter in a query of mine TODAY CHARGES to
lookup up records according to the following SQL:
SELECT RUNDATE.DATE, RESPEL.ROOMNO, RESPEL.SURNAME, RESPEL.NAME,
RESPEL.COMPANY, PRICELIST.PRICE, RESPEL.ARRIVAL, RESPEL.DAYS,

I have records in a TABLE that look like the following:
Jklebowski (Logged Out)
lawilliams (Logged Out)
etc.....

Hi. I have Table1 and Table2.
Table1 and Table2 have a relationship. One record in Table1 has many records
in Table2.
I have the need to duplicate all records from Table2 according to a criteria