Search results

well i created a relationship between 2 tables where: tableA = invoice data tableB = company IDs i have 2 questions that i have been unable to resolve on my own. 1. i want to create a query where i am able to find all of the invoices from a single company using it's ID and add up all of the...

ok i finally got the data to show up! but it is still in numbers. i was wondering if that was normal. i see the company IDs but i always thought that the IDs were supposed to be replaced with numbers but it isn't a big issue for me. i was just wondering. is there a way for me to pick out all of...

small question, my table for company IDs has company name in one field and the ID in another. i made the ID primary on my Com ID table but invoice primary on the main table. is this going to affect the database later on or is it harmless? edit: is the ID number supposed to be replaced with the...

well i only had one table at the time and created my second (which was my second company). i think i'll revise the table to do the list of companies like you said w/ the company ID. i don't think my tables are linked at all because i'm not quite sure what it is. up until now i've been pretty...

yea i already wrote out my design on paper. i've been working on this database for about a month now and i finished the central table. i wanted to create a realistic invoice system that my family could use since they are in the travel agency. the reason i'm using 2 different invoice# is...

i'm not quite sure what you mean by connecting the tables. do you mean using relationships? i tried using relationships and i made a mess. i thought that if i connected all of the fields together then the info would show up but it didn't work so i have no idea how to delete the relationships...

actually, no data shows up period. there aren't even blank rows to begin with in my fields. i tried using one table and the data showed up but when i added in another table all of the rows dissapeared again. does anyone know what's wrong?

as the topic says, i'm a beginner playing around w/ access and i tried to make a query that used 2 tables, but the problem is that when i try to view the query, (since i'm using fields from 2 diff tables may be why) none of the data shows up and all of the fields are blank. i'm trying to create...

i've been trying to tweek the autonumber system to work to my advantage because i want to create a system so it keeps moving down numbers but doesn't have to start @ one. currently my autonumber keeps going 1,2,3,ect.... whereas i've been trying to make it start at something like...

thanks for the help! i finally think i finished the project. now i'm just going to try to tune it up a little so it runs more effectively, but without your help i probably would never have gotten my queries finished (stupid ms office guide didn't help at all -.-"). once again thanks. btw, how...

a problem that i've noticed with my database is that everytime i save/make changes the size keeps getting larger. it was previously around 400 kb but now it is almost 1.5 mb. the only way i know how to reduce the size back to normal is to make a new database and import that data in, but is there...

thank you!! it worked out great (i was struggling and playing around with all of the commands for 2 days already). so if i wanted to do the same with the AR then would it be something like AR$: [sale]? how do i set it up so it only triggers when AR is answered as yes? btw, i tried to create the...

Hi. I just recently started studying Access independently since my school never taught it to me and I'm trying to design a invoice type of database as a summer project. I'm stumped on queries because the office 2000 guide I have only briefly goes over it. Basically, what i'm trying to do is...