Search results

Hello! I have a problem that someone might know the answer for: I have a database with 4 columns (Firstname, Middlename, Lastname and UniqueID) I'm trying to make a query that filters out only certain people by typing names in textboxes. My problem is that Middlename and UniqueID may often...

Hello! I have a combo box containing names of certain US states. When selecting a state in this box it filters results in another combo box using the selection as a criteria in a query. My problem is that when selecting "kansas" I also get all results containing "arkansas". I've tried using...

Hello! I use a value from a combobox (filled with a value list) as a criteria in a query. The values are basically names of american states. The works fine but I'd like to make a "Misc" value in the list that catches all record that doesn't belong to any of the states in the list. I thought...

Hi! I'm trying something I thought was easy but I can't get it right. I want to count the number of records in a query and display the result in a textbox. I've tried Count and DCount but it just won't work :-( Can someone tell me the exakt syntax for these functions? My query is called...

I have a query that looks like this in SQL-mode: SELECT OOB1.Firstname, OOB1.Middlename, OOB1.Lastname, OOB1.OOB1, Chr$(13) AS Expr1, OOB2.Firstname, OOB2.Middlename, OOB2.Lastname, OOB2.OOB2 FROM OOB1 INNER JOIN OOB2 ON (OOB1.[Full Unitname] = OOB2.[Full Unitname]) AND (OOB1.Firstname =...

Hello everybody! I'm totally new to this forum and almost new to programming so I desperately need some help. I have a database with the following look: Org- Person----B1-- B2-- B3 ---------------------------------- org1 person1 ---1 org1 person6 org2 person2 org3 person3 org3 person7 org4...