Recent content by kioku

Does any one have links, examples, or ideas on how to create/modify an Access database for Double-Entry & Correction purpose? (double-entering data and then compare for discrepancy for research purpose) My idea is to split a database and have 2 people work on 2 separate Front-Ends, but both...

thanks again. how can i use the "OR" function within SQL? i can't seem to do: IIf([raceID]=2 OR 4 OR 5,6,[raceID])?

thanks for your reply. so if i want to do "=" i can just replace the ">" ? and what if I'd like to do an OR with multiple values, how can i incorporate that in the SQL statement? if I do want to use the VBA code, can i do that in the query? thanks again, since i know little about SQL/VBA.

no, it's not that i need subset of records. i know it seems confusing, but there needs to be 2 separate DBs for the purpose of double data entry. the data is the same, it's just that the data input progress is slower in one than the other. the forms are usually changed in one DB, and to...

so i need to keep 2 DBs with the same forms (But different data) for the purpose of single/double data entry. i have to constantly import forms from DB1 to DB2 because of the form changes, how do i keep the existing data and import it? when i try to use the import wizard, it always imports...

i'm a Access novice. I have tables with existing data in numerical form, and would like to know how I can use Queries or VBA code to update these values into a new format in a new table. for example the original data might be of race type: 1 - caucasian 2 - african american 3 - hispanic 1 4 -...