I have a table which has a list of medications for a patient.
Table: PatientMedications
Field:  PatID
Field:  Medicaiton

Is there a way when I set up a query, I have combo boxes for a user to choose
what they are looking for.  It only allows me to have 9 choices and I need
for it to offer 15.  Is there a way for my combo to show the 15 choices?

Access 2003: How would i write a formula or something within Criteria in a
query to say, If the currency field is "EUR", then divide the price field by
the relative conversion rate in order to make all data within the price field
converted to dollars.

I have a query that pulls records from another query.  When I run that query
on its own, the records that I need to see come up okay.  However, when
attach that query to a report, then run the report, the query records do not
populate the report.  Does anyone know why this might be ...

I need to create a monthly report. My query would ask for the criteria [Enter
A Month] and based on that, display the data for that month. My date field is
in a mm/dd/yyyy format. Is there an easy way to get this done in the query.

I have a query...
SELECT TOP 75 QryPerformAmount.Perform, QryPerformAmount.SongTitle,
TblClick.Tempo, TblClick.Rhythm
FROM TblClick RIGHT JOIN QryPerformAmount ON TblClick.SongTitle =

I'd like to open and execute an Access (version 2003) query from another
program using a hiperlink stored in a dbf table in the program.
The idea is that the hiperlink will give the query the value neccessary to
execute it. The program in qustion is a geographical information ...

I have a problem with a select query in which the names of certain calculated
fields are changed after the query has been updated by an update query.  The
change involves the removal of a space in the field name, for example, the
calculated field name “SiH4_1 (mol/min)” becomes ...

In my query I would like to see the Security Number (I used Group by
this)----Last Trade Time (I used "max" for this one) -----but I also want it
to include the respecitve information for the last trade----Volume and Price.
I've managed to isolate the the Security Number so each ...

I am looking for help building an efficient query that can return the daily
costs for my employees. I have a table with my employee names and their IDs,
and another one with the daily hours worked by each employee, and finally
another table that contains the hourly rates for my ...

I am working with Access 2003 - I have two client databases and I want to
compare both lists, find out what clients are on one list and not the other.
My question is what and how do I create a query that will sort through both
lists and come back to me with names that do not ...

I posted this a couple of days ago... no response.  Anyone have any
insights?  Thanks
Rob
----------------------------------------------------------------------------------------------------------

I have a table with billing of phones.BILLING
(number,month,data,time,cost)
When I build a query NB1 based on BILLING and put few numbers and
months as criteria it calculates immidiately (2s). When I build query

I would like to place a version date (based on the current date) on reports
that are printed for each day of the week. For example if today is "Thursday"
14th and I printed the report for "Saturday" it will show a version date of
the 16th.

I have fieldname COMMISSION that store all the commission from year 2005 and
2006
Im creating a report so i made a query comparing Commission in year 2005 and
2006 on the left side of my rerport shows the 2005 Commission it works and