I'm a Access newbie, so please forgive my ignorance!
I have a database of Texas companies with a lot of different information.  
I'm trying to run a query pulling information from just Dallas & surrounding
cities (I've successfully run it for Houston).  My problem is that I'm

Help.  I am trying to prompt a user to input criteria in a cross tab query.  
In a normal select query this would be accomplished by [enter name] in the
criteria.  I have searched the newsgroup and found that you have to input the
prompt under Query - Parameters.  I have done this ...

I have two vlookups being done in Excel that I want to move to Access. One is
a closest match numeric and the other is a closest match alpha. For example:
The numeric:
Cell value is 3.250

I am having a problem with a CrossTab Query. I am trying to sort by month
dates which are spread over a few years. Unfortunately, Access does not make
any difference between, for example, June 2005 and June 2004 and the value
concerning these two dates appear under the same column. ...

I've imported an invoice from excel into an Access table, tblInvoice.  The
table has an ID number column.
I need to figure out how to "copy down" the PO number so it is on every
detail line below it.

I've used the find duplicates wizard and yes, it shows me the records with
duplicates but I need all but one of each removed. It doesn't make a
difference which record is kept from a chronological order point of view,
but I just need one of each kept. How do I do that?

In Access, how do I create a date formula that does not count weekends?

I am trying to populate a dropdown box with a list of field names once a
table is selected. I am using the following query to populate the list of
tables from the access database:
SELECT MSysObjects.Name as tname FROM MSysObjects WHERE MSysObjects.Flags =

can anyone help me with this i have a table of renters who have pay for their
rental property each month on the 1st. The details are entered on the 1st. I
want to run a report on the 3 rd of each month that tells me who has not paid
for the property on the first.

I'm having the following expression in a query.
O0503: Sum(IIf([Category]="Outcome" And [Period]="200503";[Amount]))
Now, instead of having "200501" "....02" "....03"  written in each column I
want to base the year on a parameter value. Hence I would like to have

I am trying to do what I thought would be simple, but am finding it
difficult.
I want to write a query which extracts all records from a table suign a
date criteria. I want to store this date somewhere, and then next time

ano ano
Dear,
  I have one table to do as the running number from 1 to 200, for example,
this table name "Tblrunnumber" and the field name 'num' property as number.

I have a tablequiery which i run which shows KPI's for the week, it looks
like this
01/01/2005
a

I'm having a query where I sum a number of records using an IIf function
which gives me a dynaset looking like this;
                      Budget 0501    Forecast 0501     Outcome 0501  
Budget 0502 ..

I have created a couple parameter queries and would like to create a query
that when ran would prompt me to choose one of the parameter queries I have
already created is this possible?  For example:
I have q1, q2, q3, q4, q5 (query example names).  I run q6 and it prompts me