Is there a way to have an unbound field in a subform do a calculation that
will add the value from another field [AssignDate] to the dLookUp value
DLookUp("[DHallExpiration]",[tblExtraInfo])
I tried it the easy way and get a #Name? error.

I have a table with
Student ID             EventID             EventDate  (for example)
573                        2670                7/1/2007
573                        2716                7/1/2006

Hi, All:
I am using  insert into statement to populate a Table, however,  the
table  has to use one field change with the change of multiselect
listbox value, the other would be an ID from that Form.

I am using a database, that I admit I created before I was the wiser, and
used combo boxes (lookup fields via the Wizard) in the database table.  The
database is now filled with data.
The table has multiple fields, but there are four fields from which I would

I need to build a table using a old database. the field I want has some data
in them but can also have blanks. I do not wan the fields with blanks how do
I accomplish this.

Hi all, query solution I hope !
I have imported a csv address file into access : Address1 Address2 -
Address6
Some fields are blank followed by another blank

In my table I have a field labeled "Points Adjust." The data in the field can
contain points that have been adjusted from 1 to 100,000. I need a query that
will pull a random 10 that have had >0 and <20,000 points adjusted. I tried
to set criteria =RAND()X,XX but this did not ...

I need to query for all records in a table where at least a particular
participant is the same.
The fields I need are all of the following:
PartType.Participants

I've got the following query:
SELECT QuoteItems.SubHeading, QuoteItems.Qty, QuoteItems.PN,
QuoteItems.Desc, QuoteItems.LeadTime, QuoteItems.Optional, QuoteItems.Price,
Quotes.ROE, [Price]*[Roe] AS USDPrice, [Qty]*[USDPrice] AS TotalValue

I have a database created by getting external data (outlook folder) and
creating a table I've got this linked to the actuall outlook folder so it is
updating.
However in the table it generates I have a ton of excess data. So I started

Hello
Is it possible to access the text property on a textbox and us it in a query?
I have inherited this access database and it doesn't work, it simply pop-up
an input box where the query needs data from a textbox (tekst28) on a form.

TABLEJAN
id     quantity     type
1          1            c
2          1            c

Hello all.
Any Decent SQL Editors out there that will clean up the way access lumps SQL
together and makes for easy editing?

I have two tables; one with work orders and one a list of water main breaks.  
I also created a table with just the date from January 1, 2000 to present
date.
I want a query that shows every date and takes data from each of the other

I have a database that includes an Observers table (32 records) and an
Associates table (357 records).  We randomly assign each observer a group of
associates and are currently doing this through a very manual process in
Excel.