Microsoft Access Query Help!?
970593
You need to apply NORMALISATION. (Look it up if you need to)\n\nCreate a table for Status with 2 fields - one for text and one for an ID. Put in the different states (as listed in your question) in ascending order (think about this order carefully). Go to your original table, create a lookup field referring to the Status table. When building your query, now use the value of the ID field (e.g. StatusID>2)
421773
MS access will do that, \n\nlookfor help in excel for JET or OBDC
289411
Build a view that joins your two tables.\n\ncreate view EmployeeDepartmentDetailView as Select tblEmployee.*, tblDepartments.* from tblEmployee JOIN tblDepartments ON tblEmployee.departmentNumber = tblDepartments.departmentNumber;\n\nThen do a select on this new view:\n\nselect departmentName from EmployeeDepartmentDeailView where employeeName = 'xy'.
828970
dim db as database\ndim rs as recordset\ndim strSQL as string\ndim strA as string\ndim strB as string\ndim strC as string\n\nset db = currentDB\n\nstrSQL = "Select fieldA, fieldB, fieldC from Table1 where FieldD = fieldvalue"\n\nset rs = db.openrecordset(strSQL, dbOpenDynaSet)\n\nif not rs.EOF then\nstrA = rs!fieldA\nstrB = rs!fieldB\nstrC = rs!fieldC\n\nend if
151888
Sorry, I don't think I can help.  I can use a 50 field table in Access and create a 50 field form using the wizard.\n\nDoes the problem occur running the wizard locally instead of through the thin client?  If it doesn't, you probably need to report the problem to Wyse.\n\nOnly other thing I can suggest (not saying it will make a difference) is see if you have the latest service pack installed for Office - maybe there was a bug???
253594
Sure.  You have to use a parameter for the date in the criterion for each of your queries, like:\n\n    >= [LowestDate?]\n\nor\n\n    = [ExactDate?]\n\n(You set this up by editing the query in Microsoft Query -- add a comment if you can't find this step.)\n\nThen,  make sure the External Data toolbar is showing (using View -> Toolbars -> External Data), click any cell in the results of the first query, and click 'Query Parameters' on the toolbar.  That will open a dialog box which will allow you to set the query parameter to obtain its value from a particular cell.\n\nThen, repeat the same procedure with each query, setting the same cell for the parameter value in each query.\n\nSo, every query will depend on the value in a single cell.
294787
A database will work very well for what you need. MS Access is the only one I have personal experience with. I'm sure there are better apps out there. Create a query based on the cert expiration date and run it as needed.
1182532
Ok, if I am understanding this properly, access is referring to Microsoft Access?\n\nYou cannot open a dbf file from within Access.
996041
http://www.w3schools.com/sql/
346060
just try going to this link\n\nhttp://www.w3schools.com/sql/sql_intro.asp\n\nmight help
862897
Go for MS-Excel or MS-Access.
780343
If you are in VBA in MS Access? Than you can cut the string and used the variable directly and then finish the string.\n\nstudTbl.Open "SELECT * FROM [studlst] where ([no]=" & i &")"
326051
Enter the information you want to search for. In a Microsoft Access database, use a question mark (?) to match any single character or use an asterisk (*) to match any string of characters. For example, sm?th finds "smith" and "smyth"; *east finds "Northeast", "Southeast", and "East". In a Microsoft Access project, use an underscore (_) to match any single character or use a percent sign (%) to match any string of characters. For example, sm_th finds "smith" and "smyth"; %east finds "Northeast", "Southeast", and "East".
250883
Depends on the type of query you want.\n\nYou can use a UNION if your tables all have the same number, types and names of columns:\n\nSELECT name, age, address FROM table1\nUNION ALL\nSELECT name, age, address from table2\n\nOr, you can use a left join if you want all the columns from table1, but only columns from table2 that match on a key:\n\nSELECT a.*, b.name, b.age FROM table1 a LEFT JOIN table2 b ON a.record_id = b.record_id\n\nOr, you can use a inner join if you only want columns from both tables if there are key matches in both tables:\n\nSELECT a.*, b.name, b.age FROM table1 a INNER JOIN table2 b ON a.record_id = b.record_id\n\nAnd you can do this with multiple tables:\n\nSELECT a.*, b.name, b.age, c.height, d.favoritecolor, e.GPA FROM table1 a LEFT JOIN table2 b ON a.record_id = b.record_id LEFT JOIN table3 c ON a.record_id = c.record_id LEFT JOIN table4 d ON b.some_key = d.record_id LEFT JOIN table5 e ON (a.another_key = e.yet_another_key AND e.GPA > 3 AND a.fourth_key = e.fifth_key) WHERE a.record_id > 100 and c.height < 145
692198
when writting querires try using the design wizard, you could add the colums of each table and then add your criteria.\n\ne-mail me a bit more in depth of what you want to do and ill try and help you in more detail
146941
In calculated query field:\n============================\nTotal: [Field1]*[Field2]\n\nIn a form field:\n===============\n=[Field1]*[Field2]
992894
Access is fully programmable, and easy to set up for small databases.  You could probably do this yourself.  I'm not sure you will find an actual "Lost and Found" database, but morelikely find an inventory control or the like.