I need to know if it's possible to do one thing and if yes how !!!
Here's an example of an output of my DB (DB is Fiction of course,but the
question that follow is for real)
ID              report#  Test#       Location               depth        

I'm running the following code in order to insert a field Prod_Date into the
tablt tblRepairRLTemp. Based on the DATE_CODE in tblRepairRLTemp, it should
lookup for that Date Code in the DateCodeLookup table and then substitute the
Prod_Date with the corresponsing Date field ...

I am having a lil bit of a problem trying to do the Following ...
I want to have a Query which brings up a Combo Box / Drop Down Menu
when you choose the specific value, I need it to Display thos
results.

I have a query that displays guest zip codes, which are stored as text
strings.  I would like to add a dash between the 5th and 6th digit if the zip
code is longer than 5 digits (eg, 12345 displays as 12345, and 123456789
displays as 12345-6789).  I don't quite know how to code ...

How do I tell the following SQL from a crosstab query to average the
crossSell.newCustomers field **ONLY** if that field contains a value greater
than zero (0)? I have tried enclosing the Avg function following TRANSFORM in
an Iif statement, but I get an error message.

I have a query where I've placed brackets [Type Area Name] in the criteria
section to get the standard popup so that the user can enter a name.  This
name is actually a drop-down field on my table.  Is there a way to have this
standard popup be a drop-down instead of a text box in ...

I will soon have access to an Access database from which I will obtain
data using a query. I need to append a table in another Access database
with the information from the first table. The field names in each
table are different from the other table. For example, "Case

I have a SQL query that builds a list of shipping order errors.  Each error
report has one Purchase Order Number (PON) but may have many errors
associated with that order.  I aggregate errors based on Description and get
totals of each type.  Date ranges are automatically ...

I have a table where I have a field called name.  But there is a lot of
equal names.  How can I delete all the duplicated records and leave in the
table different names.
Thanks in advance.

Hello -
I am not am expert at developing databases.
I am working on a sales order database that will also track the shipping
records.

I would like to be able to dynamically add/remove subdatasheets (through VBA)
when the user expands the record in the main query depending on the contents
of the record expanded.  In other words, expanding one parent record would
result in one subdatasheet being shown, but a ...

I'm probably being dumb but I've put this in as a criteria on a query,
Between [enter date] And [enter date]      Unfortunately it only asks for the
first prompt and not the last so I only get results if they are the same date
as the first prompt.   What on earth am I doing ...

I'm trying to make a relatively simple parmeter query using record numbers.  
All but the simplest such queries (ie, a simple record number) return one
empty line  where the records should be.  Even a simple OR statement fails,
that is, when I type the Or statement into the ...

Hi,,
If i had a report that looks like this:
QtyOnhand      Qty_initial              Gain             Loss
35                           50

I have a calculating field in a make table query that utilises the following
IIf statement.
SD: IIf([PolType]="10" Or [PolType]="11" Or [Poltype]="27" Or [Poltype]="28"
Or [PolType]="19",DLookUp("[SD]","[TblCharges]","[Class] =" &