Query Trouble

[TiffyMilly]

I would appreciate an insight into either of these problems, I'm currently
assembling a database for periodicals. In this database I want to create a
search that will locate records by thier code #, then following that search
add up the cost values. This way the library can see where they are sitting
in thier spending budgets for each periodical subject department. I'm
currently trying to combine the following two SQL Statements:

SELECT [Direct Serials].[Direct Number], [Direct Serials].Code, [Direct
Serials].Title, [Direct Serials].Publisher, [Direct Serials].Address, [Direct
Serials].[City/Province], [Direct Serials].[Postal Code], [Direct
Serials].Email, [Direct Serials].[Web Address], [Direct Serials].[Renewal
Date], [Direct Serials].Cost, [Direct Serials].[Method Paid], [Direct
Serials].[Subscription Type], [Direct Serials].[Sub - Start], [Direct
Serials].[Sub - End], [Direct Serials].Frequency
FROM [Direct Serials]
WHERE ((([Direct Serials].Code)=[Enter Code:]))

AND
SELECT [Direct Serials].Cost, AS SUM([Direct Serials].SumOfCost)
FROM [Direct Serials]
GROUP BY [Direct Serials].Cost;

I've been working on this all day and I just can't seem to figure out what
it is I'm doing wrong.

In addition to this, I have created various queries to search this
database, by title, subject, renewal date etc. and I'm successful in yielding
results, however they are returning in table view and I would like them to be
presented in form view. How can I do this.

If anyone could help me, the assitance would be greatly appreciated.

Sincerely,

Tiffany