Given a table with the following:
ID : int (autonumber)
ParentID: int (nullable)
Information: string

Hi, I'm trying to make an append query to update a table in my database.
The source for the query is a form. There're 2 textbox that will define the
range of voucher# (sequential) and a textbox to define date.
I need the query to append a table based on that information, so that ...

I have a qry with a subdatasheet.  I want to alter the fields in the
subdatasheet.  How do I find the name of the qry being used as the
subdatasheet?

I am importing records via excel from another program. The problem is some
fields has different values then usual. See below please.
Importdate    Name    Checkin is    Checkout is
13.04.2008    Alice    21-23    04:52

I have two exactly the same databases, and now I want to
join all the data/records into just one database. If I would
like to add all the data from one table to another, is it then
the INSERT INTO query that I shall use ?

My original query reads as follow:
SELECT [qryFG/RMList].[Formulation#], RACK.Code, [qryFG/RMList].PRODUCT,
[qryFG/RMList].ContainerDesc, [qryFG/RMList].[PkgID#], RACK.[RACK#], RACK.
[Batch#], RACK.CURRENTINVENTORY, RACK.RESERVEINVENTORY, RACK.[Tote#], CDate

I have a query with a start date and end date and they are date/time fields
it is set up dd/mmm/yy format.
What I am looking to do is in a query have it find dates that are 0-30, days
from todays date

I have address data that looks like this
"P O BOX 123"
I want to replace "P O BOX" with "P.O. BOX"
To end up with "P.O. BOX 123"

I have the following IIF statement in a Query and it is working just fine. I
am having trouble adding more conditions to the statment and I would greatly
appreciate any help I could get.
Postage: IIf([X if 2oz]="X",IIf([Date]<#5/14/2007#,0.545,0.459),IIf([X if

Hi - I have a table of date based data that I wish to view as a cross
tab with my dates as column headings. For example, for a particular
location say I have 3 values for Arsenic, all on the same day. How do
I show all 3 values in a cross tab...access wants to group by date.

I wonder what the difference is between writing the condition
1) not in (2440,1042)
and
2)<> 2440 and <> 1042

Hello, I am desperately needing help with this query.
Basically, I have 4 criteria that I want the query to evaluate correctly
in a form. User has 2 fields to input - individual and company.
But I also want the query to work if a user leave either company blank

I'm trying to find a value in table F (Foreign Exchange Rate) that is the
closest to the date I purchased a product specified in table P, so that I can
convert the purchase price into US $ from a foreign currency
So here's a simplified table structures:

I would like the results of a query to be copied into a word document.
Is there a way to do this in code? For example, a button clicked will
create the query results and place the results in the clipboard so
when the user opens their word document, they can copy the results?

Hi
I dont know how to decrease space between top of page and top of report
header. I have a lot of space between these and I would like to use this space
to include som more data in the report header.