On a employee table that has forename, surname and emailAddress when
the query for this table is using like "*" it works apart from when
the data in one of those field has been removed from a form.
How can the query be modified to handle this case of when there is no

not sure that I understand everything that's going on here.
http://doublingstocks.com/?hop=sreid0120

In the SQL below, can you please tell me ho can I avoid to be promted to
enter:[Further Gross up - 7 Sisters]?
Thanks,
Dan

Hi
I have built a union query (still not complete with all 40 queries but 3 are
built and shown below) that looks like this:
SELECT * FROM [ÄÄ Saldo 2741 summerad]

I have an overtime database which tracts overtime.     At the end of the year
we  equalize the overtime.   We have to subtract the lowest employee from the
highest employee by Class No.   When I create an update query how do I sum
the hours worked and subtract off the hours I am ...

A friend and I are learning these functions in our computer class and our
teacher has no clue what he's doing. So if anyone could help us it would help
out a lot.
So we have to make an Update Query to update a field using the IIf function

I have my SQL pasted below. I need some help. My table structure is as
follows. There is an Issues table with a primary key "ID" and an Updates
Table with a field for "IssueID" that is linked to "ID" as one-to-many. The
idea is that for each issue we can create many updates taht ...

I am wondering if it is possable to prompt my users for which "table" they
would like to view.  Everyday our logs get backed up as the current days date
"04APR08" and they are saved as a different table each day. I would like to
create a query of some sort to prompt the user for ...

I have one table with loan number and dates "A","B","C","D".  The dates are
all different, and the date in "B" is greater than "A", "C" is greater than
"B" etc.  Also, If there is a date in field "D", then there will be a date in
"A", "B", "C".  Likewise if there is a date in "B" ...

I need help please with IIF statement for my query. I have a large list of
mbrs with ids were a family will have the same id consisting of text and
numbers and ending with a letter  or number that if it is a family the ending
letter or number will increase by one number or text.  ...

I have faced an issue which I need help with.
I am trying to do a concatenation of comments on consecutive rows grouped by
a certain ID.  I have a list of comments against an id with increasing dates
which I would like to concatenate on to one record per ID as shown below.

Hi - I have an access database with over 400,000 entries and need a query
which will display those values that appear in the database only once. For
example, if my database hase the following entries:
a

I hope someone can help me with this.  I have a very large list of mbrs and
addresses.  Due to mbrs dependent on main subscriber there are multiple
instances of addresses.  I can use mbr ids because they consist of text and
numbers at random .  I need to narrow list to only once ...

I'm trying to append records from table 1 to table 2. However, only matching
fields/columns from table 1 will be appended to table 2. For example, table 2
has 30 fields but table 1 only has 12 fields that match the 30 in table 1 and
should be appended to table 2. When I run my ...

OST    Ocity    Dst    Dcity                   Region                 Carrier
MI    kalamazoo    NJ    Parsippany    EC
OH    Cincin    MA    Boston                   EC
NJ    Dover    MI    Detroit        MW