Search results

Well, yes the list is limited so people cannot enter anything, just pick a state from the list. I'll try to explain a little better :-) The table looks like this: Unit: ----- 1st Virginia Infantry Regiment 2nd Pennsylvania Infantry Regiment 1th Alabama Infantry Battalion In the query I use...

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...

It worked when I made a new query to count the old one. Thanks.

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...

Never mind, I got the result I wanted by making a union query instead.

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...