Lets Try This Again
I am creating a service database.  and I need some help on adding multiple
records automatically.  Currently, I can do one at a time, but i would like
to be able to update multiple records with just 1 click

I have this query and cannot get it to work. I know the syntax is wrong so
can someone please help me?
strSQL = "select * from TableA" & _
           " where Field1 = " & ex_field1 & _

I'm needing to display the correct area code for the corresponding postcode,
row two is the example i'm needing to display. The postcode is already there,
it the area code i need the formula for.
          A               B

I have a table which inculde two fileds. Field 1 called "Injection" is a
Yes/No box. Field 2 called "#of Injections" is a number column. I want to
have an automated function, where if "No" is selected in "Injection", "# of
Injections" automatically fills in a value of "0". How do ...

I'm doing some work cleaning out old unused forms, reports and
queries. I have been going through each report in a database (There
are A LOT), determining its row source query, then marking it for
deletion. I will eventually end up going through and deleting all the

I have created a weekly service database, and I am trying to automatically
add a record to a table.
Main Table:  JobID -
Service End -   Job is no longer on service.

In the Provider field, the provider names entered as HELFRICH, SHEILA. I
would like to make it appears in the report as Sheila Helfrich. Please help.
Ex: HELFRICH, SHEILA to Sheila Helfrich
Thanks

I'm trying to create a calculation that includes 1 field from my main form.
The calculation will be put on the subform. This is what I have for a formula
in the control source field:
=(Forms!PSHourlyRate!HourlyRate1-[TotalCost])/[TotalCost]

I need to be able to find the latest date of multiple record which belong to
a parent record, but only if all the child records have an actual completion
date.
I have all my children records in a table linked to the parent record using

Hello got a question for you all,
I am using access to create a content management solution.
initially it seems pretty easy
i would create a table for each type of document template. and the

I have a form with a subform.
The formfPerfEmissionGua) has a field called FuelClass.
(Gas,Liquid,Duel,Multi)
The subform(fPerfEmissionGuaDetails)is based off of a table called tFuel

Is there anyway to assign a field as the primary key when using a make table
query?
Thanks,

When viewing/printing reports reports we are only getting one line of data
per page. So instead of having a 5 page report with 60 entires we have a 60
page report with 1 entry per page. Is there an easy way to solve this
probelm?  

hello i have the following txt box withis code
                [ data required]   [from this qry]  [id from form] [id from
qry]
=DLookUp("[steps taken]","qry steps count","[employee id]=[employee id]")

I am sure there is a simple solution to this but my brain doesn't seem to be
working at the moment.
In my dataset one field has the value "Data Quaternity" and the other values
are NULL (but could be another string) and I want to exclude any records from