Queries
in [Access]
|
Search Tables My client would like to have 6 or so combos on a form, in which they can query any field from any table, and export the results to excel. yikes. i figured the first combo, i can do a list of available tables (tests). then when they select a test, the combos will list all available fields within that table. ... 23 May 2010 19:04
MS Access 2007 Query Separating Info into months columns Hello, I have a contact table (Tblcontacts) that has fields (FldID[PrimaryKey, autonumber], FldFirstName, FldLastName, FldPhone, FldStreet, FldCity, FldState, FldZipcode, Fld0to5, Fld6to18, Fld19to40, Fld41to60, Fld60plus, FldComments). 2nd Table is TblVisits. Fields are (FldID2[Primarykey, autonumber], Fl... 23 May 2010 09:12
Report I'm trying to open Two reports with one command button. But everytime I click the command button it goes to the report2. How can I open report1 click until I get to the last page on report1 then open report2. Is this possible. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.asp... 25 May 2010 09:07
append crosstabs can you append the results of several crosstab queries into 1 table? I'm calc different categories & customers and need to capture "hours" for each area for several different categories: Estimates received - on time? avg days to certify rejected certified Scheduling received - on time? avg days to certif... 27 May 2010 18:11
Query Setup with Two Tables Is this possible in a query? You have Table A Table B There is a link or join between the two tables. Table A is the main table, B is a sub or secondary. When you view the records in datasheet, you see what is there. I want to see ALL THE OTHER records, the ones that do not meet that requirement, the... 21 May 2010 19:28
Access 2003 I get a "type mismatch in expression" when saving a query. Why do I get this and how do I correct this? My suspicion is my customerID and barcode fields are not both autonumbers or the same type to relate but under the relationships they join up. Please help. ... 27 May 2010 17:04
Need help with concatenation function Hello, I've found a wonderful concatenation function at http://www.mvps.org/access/modules/mdl0008.htm. It, however, separates the concatenated values with semicolons when I'd like them to be separated with "<br />"s. For instance, instead of "Value1; Value2; Value3", I'd like "Value1<br /> Value2<br /> V... 21 May 2010 16:08
Export to Text Files Based on Field Value I have an Access table with personal information (e.g., first name, last name, birth date, etc.) for thousands of people. The table is sorted by state. I want to be able to run a macro on that table that will create separate pipe delimited text files for each state with all fields included. Any help would be appr... 21 May 2010 15:03
Total - Total Fields in a Totals Query Any idea why this won't work? TotalDays : nz([Sum Of VACADAYS])+nz([Sum Of SICKDAYS])+nz([Sum Of OUTNOPAY])+nz([Sum Of HOLIDAYS])+nz([Sum Of BEREAVEMENT]) I get an error that say: SubQueries cannot be used in the expression. Any help would be appreciated! JK ... 21 May 2010 12:49 |