Hi there,
I have just started using Access 2003 in the last couple of months and have a couple of problems i would like some help with please for a project i am working on.
PROBLEM 1.
I have a ComboBox (cboSelect) on my form (frmSelectCompany).
I am populating this combobox with [CompanyName] data from my OrderTable.
The problem is if a company has made more than 1 order that company shows up more than once in my combobox, but i only want 1 entry for any CompanyName in the combobox.
Is there any way of limiting the combobox (something like, only putting CompanyName in combobox if it does not already exist)?
PROBLEM 2.
I would like to grab data from a table, but only if a certain field matches a set value.
I was thinking i need to run a loop looking for the value in the table, then if found get that info, but i have no idea how to do this.
Basically i need the calculation below to run in a loop checking a table to see if [SELL PRICE]=[Price]
=IIf([SELL PRICE]=[Price],IIf([SALE QTY] Mod [Quantity]="0",[SALE QTY]/[Quantity],([SALE QTY]\[Quantity])+(([SALE QTY] Mod [Quantity])*[SELL PRICE])),[SELL PRICE]*[SALE QTY])
Any help with either of these problems would be greatly appreciated.
Thanks
Graham