I am trying to use DSUM to create a running total via Method 1 in MS TID
290136.
I am getting an error in my DSUM statement.  Very simple query:
SELECT SalesForGraph.Week AS CWeek, SalesForGraph.[2006Profit],

Using Access 2007 on Windows Vista:  I am using a crosstab query in a report
and it is working well, except that when I get more than 8 results it cuts
off the later results.  I am looking for a way to display all of the
information in a crosstab query on a report.  Is there a ...

Is there a way to count only non-zero values in a query, and ignore zero
values? The numeric field is substituted with 0 (zero) if it's null. Any
pointers are greatly appreciated. Thanks.

All,
I am trying to do something similar to a VLOOKUP from Excel.
I have a table where latittudes are the column names and longitudes
are the row name (1st column).

I have a database that I have been querying from my visual basic 6
program to take my access DB and convert it to excel.
I use a multitude of SQL queries to get it to the format I desire, but
i have a time column that has both the date and time within them. When

I have a combobox on a form that when an item is clicked on, it opens up the
record that corresponds with that chosen criteria which works fine.  The
problem I am having is that when the combobox is activated instead of names
it has numbers however, when I view the records from ...

In the query design, I want to total the amount of entries in a field.
Using the total feature does not work, because the entries are not numbers.
Any suggestions on creating an expression?

Hey everyone,
Is it possible to JUST save the design side of a query (specifically the
formulas I've added to the grid itself?)  I'd like to use this query in other
database in the future.  I know that it all depends on the table and field

I have a query in which I am running a variety of calculations, many of which
are dependant on others.  I am now trying to set a criteria for one of the
calculations - ([TotalCampFee]-[SumOfPayment]-[FinancialAsst]) AS BalanceDue -
I would like my query to only include those with a ...

My query is trying to reference an open form's combo box in the criteria
section.  I am trying (with little luck) to put in an IIF statement to alter
the outcome in the query.  When I run this query, I am getting zero records
returned.  The form's combo box is set on "All ...

Hi
Need your help please:
My field have:
mohsin

I know the answer to this is probably no you can't do that, but I'll ask
anyway.  I have a table with fields that represent the specifics of a
students classes. LocalID, Name, Teacher, Course, Period, Department and
Level.

I have a master table with 25 fields and each month I receive a table with
updated data that needs to be checked against the original table to identify
any changes in any of the records 25 fields (such as added records or any
changes to any field in any existing records)....I ...

How do I setup a parameter in a query for start and end dates on a bithday
field based on just the month and day of the birthday field?
Example Birthdates: 01/01/06; 02/01/06, 01/31/05, 06/01/69
If user imputs range as start date of 01/01/90 and end date of 01/31/2007, I

I have the following expression:
Expr1: IIf([SCHW ADV NETWORK]=Yes,[TOTAL FEE]*0.15)
But now I need to add that if [SCH ADV NETWORK=Yes New,[TOTAL FEE]-[SAN]
How can this be added to the expression I already have?