| Recent Answers from Bob Heifler |
 |
2008-11-19 Problems in Splitting date and time: Swaroopkumar, For time there might be none so the lenght is probably less than 10 therefore (len([RECEPD])<10) Time:iif(len([RECEPD])<10,[RECEPD],Mid([RECEPD],InStr([RECEPD]," ")+1)) Bob Heifler...
|
2008-11-19 Custom Primary Key: Natalia, Keep it one to many 1 family to many students. FamilyID - autonumber in Family table and same field FamilyID is a foreign key field (just long integer) in the Student table. Bob Heifler MyAccessProgram...
|
2008-11-17 joint queries: Use the UCase and Format functions: SELECT UCase([Ingredient]), [Unit], Format([cost], "$##,##0.00") FROM [Name of First Query] UNION SELECT UCase([Ingredient]), [Unit], Format([cost], "$##,##0.00")...
|
2008-11-17 joint queries: You need a union query. Here is an example of the SQL that you will need to past in a SQL view of query (It can not be done in the regular view): SELECT [Ingredient], [Unit], [cost] FROM [Name of First...
|
2008-11-14 Selecting a value in a subform: Try adding the word Form: Forms!Soldier_Information!History_Subform![Form]![Reason] = "1a;2a;3a;4a" Bob Heifler MyAccessProgram.com Find example files at: http://www.myaccessprogram.com/Download...
|
| More Answers for "Using MS Access" |