Search results

I would like to see if there's anyone who is interested in helping me out with organizing some tables for an Access DB? I have mot of the data elements identified, but a little lost with what to do next.

I was reading and thought this was the way to go, but I am not sure how to do it.

I have several Tabs of information in Excel. All of the tabs are organized and formatted in the same manner. It will take too lonng to copy and paste the data into one spread sheet. Is there a formula that I could use to assist with the consolidation?

Ok, try this...

Ok, see if this works.

It won't allow me to print screen/copy/paste.

Ok, I am a little lost right now because even when I try to build a query and run it, I don't get any returned data. It seems like the tables don't get their relationship.

I have 6 tables (Pharmacy Data, Pharmacy Admin, Reinstatment, Comments, Exclusions, Dates, & Notice) and they're all set with KEY ID, which is the Pharmacy ID.

I created the Form through the Wizard and I was thinking that it created the query when I had identified what data that I want from each table.

I don't think I understand. The data was pulling over and then I added a few more fields to the form that were not initially there. Then, I started to have the problem. Any clue what may be causing this?

I have a form that's created that pulls info from 5 tables. SO, when I click on the Record Source (in the design view of the form, top left corner), should the Record Source list all of the tables that the Form is pulling data from?

Ok, that worked... Thanks a lot for the assistance! Now, one more question, now that I have worked with the Record Source for my form, it appears that not all data is pulling over from the tables. I have 6 tables that are linked to this Form. My question is, how do I make sure that all 6...

I created the Form with the Wizard, so I was able to select the fields (from the Wizard) that I wanted from the Table - not all of the fields from the Table populate in the Field List. This is where my problem is. The Form is created from a table, not a query. Ideas?

I am new to Access and having a problem. I created a database using several different tables. All tables are linked through a primary key on each table. I created a form and everything went well, until I realized that I forgot to select a few fields through the Forms Wizard that I wanted...