Hi,
I have 2 tables. Table Application and table Connections ( with columns
Application, and Application2)
Example :

I have a dialog box to run a query. I'm having trouble with an expression in
the query. This is the expression:
Flute: [1FluteType] & "" & [2FluteType] & "" & [3FluteType]
In've tried this criteria:

I have calculated field LineTotal in a query that is based on the result of
the multiplication between 3 fields in the same table ie
[Qty]*[Weight]*[UnitPrice]=[LineTotal]
But the simple problem is the weight is either Null or Zero sometimes thus

there is a query X in database. What's the way to get it's code (text:
select....) from code?
thanx
alek_mil

I am very new to this so please break it down for me.
I have a query that returns all jobs on my helpdesk, but I want to
compare the Start Date and the End date and then output the elapsed
time in days and hours minutes? How do I do this?

hi all..
i have a doubt...how we can remove blank spaces
in a column value while retrieving?
i tried using LTRIM(RTRIM(COLUMN NAME))...

Hi, I have a real problem:
1. I have a table with 2000 records where one field contains the name of a
picture file.
2. I have a folder containing the 2000 picture files.

Sorry for crossposting, but as from microsoft.public.access I didn't any
answer from yesterday, I'll try for some advice here too.
I have a query
qUserDevices1:

Friends,
How to reset or change the admin password of MS Access 2003 database?
(I am using VFP 8.)
I tred ALTER USER admin PASSWORD pass1 ``. This command generated an error

I am trying to use 2 cmd buttons on a form to call the same query. These
queries must call data from a txt file and place this data in a table in my
database, at the same time button 1 must insert a column in this table
stating that the data comes from company A. Button 2 must do ...

I have "master" table that is related to 6 other tables by email address,
name, address, newsletter subscription and specific areas of interest (areas
of interest and newsletter subscription are yes/no fields) All of the tables
have "record ID" (auto-number) as the primary key. ...

I have designed a database for all the Company Contracts,  I would like to
design a query that selects the contract details in date order, (that bit i
can do) but my problem is, when sending out renewal letters sometimes I have
to send the letter to a difference address to where ...

I am trying to develop a cross-tab query that calculates the average cost of
different prescribed high-cost drugs for paediatric and adult patients which
I have achieved.  However as a small proportion of the data subjects are
either prescribed a very high or very low dose of the ...

I am running a query with the following function =avg([test1]+[test2]+test3])
I get an error message to say that the test1 expression is not part of the
aggregrate function.  The field name is definately test1, if I omit test1 i
get the same message refering to test2 - Help Plz

I can do a left and right outer join but there is no option in access to do
a full outer join.
Is that possible in access?
Any help will be greatly appreciated.