I need a formula to do this: I just can't seem to get the syntax right.
We have 2 types of buildings, 1 is permanent, 2 is portable. I am summing
all permanent buildings. I want to add the replacement cost of a portable
building to the replacement cost of the permanent building IF ...

Is there any way to select the only the top 5 records in a query or table
that is sorted by amount.

I have a query that has a field with a calculation that is a sum of two other
fields.  I also have another field that detirmines the type of item within a
record, specifically stocking(displays as -1) and non-stocking (displays as
0).

I have a query that has a field with a calculation that is a sum of two other
fields.  I also have another field that detirmines the type of item within a
record, specifically stocking(displays as -1) and non-stocking (displays as
0).

I've got a table where applicant data is entered (via a form) everytime an
application is submitted.  Each time a person submits an application it is
enteed as a new submission, thus I can have duplicate records on a person,
except for the submission date and maybe the address if ...

I've read a few posts on this query and it looks like creating a table
where I input the item numbers in it and linking it to the query seems
to be a good way to get a lot of items in a query. Now what If I have
hundreds of numbers I want to look up? do I input all 100 numbers into

Using Access 2003.  I have a query and I want to put criteria in my the ID
field to not show the record numbers that are the most recent.  For instance
if my highest ID number is 450 I only want to show any records with an ID
number 400 and below.  As new records get added, my ID ...

Problem:
I was able to get my percentage value using a SQL statement where it rounded
up the number using zero "Decimal Places" and "Format" is "Fixed."  When I
take the * 100 off and allow the query to do the math and make the value a

Hi. I posted a similar question earlier in the week. I may not have explained
my problem well. So I am trying again...
My data table looks like this...
Sym    adate    Sum

I have a field: DateLoggedIn, which stores the date when data is entered,
What I am looking for is a function, and how to apply this function, i.e. in
a query in order to calculate an expression a DueDate which will display a
new date, 3 working days from the DateLoggedIn ...

I have a query with one of the columns using the FormatPercent function.
When I output this to an Excel spreadsheet, the percentage value shows up as
text format.  Is there a way in Access to change the percentage value from
text datatype to number datatype before a user can output ...

I have a log file with about 180K records.
I'm looking to create a ranking of most frequently visited pages.
This is the query I'm currently using:
Select top 10  * from

I would like help with producing a SQL statement in Access that will take a
number and divide it by another and multiple it by 100 to get a percent
amount. I would like to do this in a query. For instance, I have created a
query that give me the TOP 10 Institutions where the most ...

How can i build a query where all the rows having -. for example -1, or -2
etc, to be set to o ?

I am trying to run a query to count number of order received in the week
(date range). The problem is some order has more than 1 record with different
operation, so if the order 1100 has 10 operations, then it is counting 10
instead of 1.