How can i express the percent margin in a query? I have a field PurchasePrice
and a field Salesprice. the field Purchaseprice is the price at which we buy
the products and the field salesprice is the field at which we sell the
products.I tried to substract the salesprice to the ...

Is there away that I could determine which access application is running?
I have an application that when it executes in XP I can display a power point
presentation without no problem. However, when I execute the same code in
Office 2007 it does not work because the location of the ...

I have a data set that has daily trading volume for a list of stocks.
I would like to find a sql that will produce a 20 day moving average of all
stocks NOT equal to IBM,AAPL,YHOO, etc...
Is this possible ?

In the same query, I am trying to get two counts so I can compare them
in a pivot table.
I have
ServicesID

I have a crosstab query that has a parameter that prompts the user to enter
the year of the data he/she wishes to see. The parameter is declared in the
Parameter properties window as an integer and the query runs flawlessly in
query mode. The moment this query is attached to a ...

I have 2 tables with a 1 to many relationship.  There are 3000 records in
table1, but only 1500 in table2 because there is nothing attached to table2.
I need to see all the records regardless.  Is there an update query I can use
to enter a “N/A” in one of the fields in table2 so ...

I have a date field that shows up like this:
04nov2007
I need to filter out those that do not fall within the current month.  If
the report is for November 2007, I want only Nov 2007 dates in there.  My

Just a heads-up in case this bites you, too.
I migrated an application from Access 2002 to Access 2007.
I have a search form for the users to enter some criteria ... the form
dynamically builds a SQL WHERE clause before opening a "results" form based

I have a table called orders with 4 fields, Name, OrderNumber, StartTime,
StopTime.  I have 50 records in this table which represent 50 orders
processed by a person in one day.  I know how to do the time difference from
the start time and the stop for an order, but how do I tell ...

What would be the proper expression to display records only between a
specific date range? <#12/31/2006# Or >#1/1/2008# in the criteria field isn't
filtering the data.

I have a query with 3 tables that represent master item list, count qty and
as qty. When I look at the results in Query, all is well and accurate yet
when I select Analyze with Excel, values change. For example, if a record
shows zero qty in the as of field and zero quantity in ...

I'm a SQL newbie so please bare with me.  I have two tables that I want to
query against and determine what records exist in the first that don't exist
in the second and vice versa.  I'm wondering what is the most efficient means
to find and add the records that exist in the ...

I want to run a query of certain records together with an email address. I
may have a 'Personal Email address', a 'Business Email adress', and possibly
a 'Third Email address'. I may have only one of these fileds completed for
each record, or all three!. When I run a query can I ...

I am trying to make a query that will take 2 dates from a form and find all
the records between the 2 dates.  I have used the suggested coding but am
getting 0 results.  I have pasted the code below.  Any help would be
appreciated.

This is complicated for me. Please help me if you can.
I want to update a table with NewCost only on drugs that the cost has changed.
On the others I want to leave as OldCost. However, I want to keep the OldCost
so that I can run a query to show the savings in that month on whatever ...