Search results

Hi Gemma, i have attached the spreadsheet. I have 2 columns with unequal amount of data. Col A has about 500 names and Col B has about 800 names or so. please help. cheers

this sound really complicated. do you have an example?? or maybe i attach a db for u to help me out eh?

Hi, I have 2 tables with similar data. However I need to compare this particular field called CompanyName in both tables. Reason being human error/exposition data errors. For example, Chef Kitchen Holdings Limited, in one table it is Chef Kitchen Holdings Ltd while the other table is Chef...

Good day people, I have done up a database for the very purpose of printing a directory listing of all our participating clients. I split up the page into 4 columns and I have 3 categories (1 main and 2 sub). Fairly self explanatory. However I do encounter some formatting problems. 1. I...

Let's say my last record is EM004.. then can i "autoincrement" a EM ID for my enduser who is inputing data in the FORM? been trying to figure out how to.. i don't want my enduser to key in the ID (instead it should autoincrement). thus the need to merge text and autonumber.. unless of course...

good idea.. but how?

Hi, can someone help me out with this? I have 3 tables, namely assignment table, employee table and job table. assignment table contains fields: assignmentID, employeeID, NumHrsAssign, Remarks employee table contains fields: employeeID, firstName, lastName, jobID job table contains fields...

thank you so much. you guys rock!!!!!

hmm.. sorry but how to join query 2 to query 3?

anyway, thanks alot.. just that i face a little problem when i wan to show off in the query2 the project name.. i can't.. sigh.

therefore, i should create a query to merge the relevant fields i want? query one should include employee_num from assignment table employee_name from employee table project_num from assignment table project_name from project table all fields to be group by query two should count for...

Hmm.. here is the complete story.. I've an assignment table, an employee table, a project table. Each employee is given an assignment (of various tasks) for the projects assigned.. which means to say.. that particular employee can have many assignments for the same project or can have 1...

nono.. tom peters should have 2 not 3.. can help rectify this problem? i use a group by for assignment_num, employee_name..

Not sure if I worded my subject correctly. Here's my problem.. I've used query to combine 2 tables of data.. Here are my fields.. I've assignment_num field, project_num field, project_name field, emplyee_name field. here are my data.. assignment_num field: 1001, 1002, 1003, 1004, 1005...

pls take a look at my form coding. thanks.. screwed up :(

thanks.. however, i still can't get the listbox to populate the values.. where should i put the coding? in a command button?

oh ya, i'm using Access 97 as well.. sorry that i didn't inform earlier.

presumably i'm planning to use continuous form in detail section..

basically what i'm trying to achieve here is this.. i will have 3 combo boxes.. 1st one is job types (e.g: managers, clerks, carpenters, welders), 2nd one is 12 months, 3rd is the years (from 2005 to 2030 e.g) I will also have 2 buttons - "get" and "save" buttons. so what happen is.. when i...

save the date data.. as mentioned earlier.. if assume i check on the 5th check box .. it should return a value of 05/combomonth/comboyear and if i check 10 checkboxes, i should have 10 records in my tbl.