Search results

Thanks NBVC, I’m sure that the value in column D, wb1 exists in column P, wb2. Not all of them but, most of them. I'm glad you mentioned about formatting: column D and other columns like P are a mixture of TEXT & NUMBERS. Ex. Address1, Phone Number1 etc. I hope the attached sample...

NBVC, thanks for your reply. My goal is to populate columns G and H in workbook1, from Workbook2. In workbook2 these columns are named different (I attempted to attach sample Excelworkbook to make it easier w/ no luck) I tried the following...

Greetings, Following is what I would like to automate: Take a record from Workbook #1 column D and search if this record exists in Workbook #2 Column P. If the record exists, then take the corresponding record from Column W in the same Workbook (workbook #2) and copy the record in Workbook...

Thanks everybody for your inputs. I’m going to apply your suggestion…. Regards, D

Greetings, I have a worksheet when users enter a valid ID Number that will list a work list which corresponds to that ID number. However, if the user hit Enter without inputting data (ID number), then all worklist are returned, or say if users enter a non existing ID number, then the result is...

Greetings, I've successfully imported XML data into Excel and Access (please see attached striped version) and start maneuvering around. My next task is the following: 1) average invoice total amount for application fees only, broken out by division, for the third quarter of this year. 2)...

Thanks everybody for your inputs. I will start putting something together and post back for your reviews. :) Thank you, Danny

Thanks everybody for your inputs. I will start putting something together and post back for your reviews. Thank you, Danny

survey db Thanks, I'll try to look at examples on the forum and put something together. If I have any problem or not sure about something, I'll post back. Thanks, Dan

Ken, I'm glad you ask. Actually, I should put some time and effort into designing a system that can be used to capture other surveys. The reason is that we have 4 departments (each with diffrent survey questions) and I was asked to design for now just for one department (as a pilot) to see the...

About 55. Thanks, Danny

What would be the best way to capture the attached "Customer Satisfaction Survey" Access, Excel etc. The plan is to take this survey once a month over the phone and provide a report about the outcome to the president. Thank you in advance. Danny

lookup table Well come back Aleb, I was trying to attach the structure of the table to help you see what I did so far, but got a message saying too large. My file is only 152kb zipped. When I created the AppSource field in tblHousehold, I defined it as number (since AppSourceId is...

Ken, thanks for your reply. I'm not sure if this is the right way, but, I opened the form in design view, drag AppSource field and tried the new field, still do not get the drop down option. And what type of query do I need to use (select, crosstab etc.) and what are the fields need to be in...

Greetings, I have created a database to track applicants eligibility process. Just recently, I was approached to add a new field to find out how applicants know about our program (through Friend, Family, School, other etc.) So I created a lookup table and added a new field 'AppSource' to an...

Thanks Aleb for your reply, When you get a chance can you take a look at my attachments (screenshot of the structure of my table) I'm not sure if I have created the table and the relationships right, but on my form, for the newly created field Application Source (AppSource) I do not see the...

Alexei, The centers are connected via a network, but not to our network. (their own network). I have created a dropdown as you also suggested as follows: In my tblHeadHousehold, I added a new field 'AppSource' as a dropdown with dropdown lists: Friend, School, Family, Other etc. I have...

Greetings, I have created a database to track applicants’ eligibility process. Mainly, a Head of Household will call or apply in person for a medical assistance for self or for child #1, child #2 etc. I created two tables tblHeadHouseHold and tblApplicants with a (one-to-many relationships)...

Greetings, I took a new position to maintain a database, which is already in production. The database is split as front end/back end database where the table (be) on the server and the (fe) forms, queries, etc distributed users machine. My question is two fold: 1.I was trying to copy the...

Greetings, I just started a new position and assigned a new project to design a database using Access XP for a non profit organization. They have four departments each with 5 to 10 employees. Some of them have to go out to a site and collect data and others collect data over the phone and...