I have a table with financial data that has column headings as Months, and
the first row contains the description eg.
                Jan      Feb      Mar
Salary      1000     500      3000

I cant seem to get the query I run to select its criteria from the form Im
putting the comand button on. The criteria im using is
forms!Formsname!ContactID even though I have contactID ref on the form it
still asks me for ContactID Parameter.

How can you use the condition Like with user input, ie I want a query
that will return items Like whatever the user inputs

I have the following expression on a query.
ProjFinDate: IIf([TMBG]=0,"",DateAdd("d",[PresentDays],[TMBG]))
I get the Expression typed wrong or to complex error. does any one have any
ideas. Thanks

I need to create 5 or more name badges for an agency that registers 5 or more
people to attend a conference.  The name badges will bear the agency name and
the agency will then assign the badges to the people it chooses to send to
the conference.  I need the query to support a ...

Trying to update a DAP based on a query but the navigation bar is not active
to add information and the data fields are not updateable.

I have a crosstab query that I need to work more like a left outer join than
an inner join.  Instead of this:
               1/2005        2/2005       3/2005        etc
12345-1       33              22               11

I am trying to set up a formula to query for dates that are 90 days or older.
What is the formula I need to use to successfully query for this information?

I come from an Excel background, so I find that I am at a loss.  I am trying
to build a database to code in old invoices.  Different bits of information
need to be tallied and reported on.
From what I can glean from the instruction manual, I should be able to

I have a simple query running off of one table local.  Here is my problem:
I am simply trying to total the following fields from the same table with
the same format (Double) for each record but it gives me blanks.  No errors
it just won't give me any results.

I do a lot of creating/testing SQL statements in Access that pull data from
MS SQL Server or FoxPro or other data sources, then copy and past that SQL
statement into ASP pages.  However, sometimes the syntax is slightly
different.  For example, Access talks to my linked SQL ...

    Hi! I have a field in my query called DateRateAssigned. I would like the
next field to be DateRateAssigned minus one month. Right now if
DateRateAssigned is 1/1/2005 and in the next field I put in
"DateRateAssigned-1" I get 12/31/2004 instead of 12/31/2004. How do I

I have a form in a dbase for college to record applications. Then say a few
weeks later the students get accepted or refused. So i have a form for
acceptances and a form for refusals. In the acceptance form - which has
student details and sub form has the status given and date ...

I read the below question and the answer but I still do not understand how
you got to what you wanted.  I'm new to the expressions and the select. can
you please explain more to me on how you set up your query and where you put
this information in.  for the expression, can you ...

Here is my Statement in SQL View. I need to have a sum for Fields Current,
[1-30], [31-60], [61-90],[91-180], [181-360], [360+]. From what I understand
it should be (Sum([Current]) It will not work. I am getting frustrated. As I
run my different queries, I need to export them to ...