#5747, "RE: Anyone knowledgable in Microsoft Access?" In response to Reply # 3
Originally posted by optikal just tellin you that i'm not. chillllllll
I'm Chilled. I just need to figure out how to get access to do some shit for my business Invoices. I hate this program but it's working out okay so far till I ran into this problem. If someone knows Access please reply.
I eat emo kids for breakfast
1995 Eagle Talon (SOLD) 72' SuperBeetle 72' Standard Beetle 56' Deluxe Beetle
#5752, "RE: Anyone knowledgable in Microsoft Access?" In response to Reply # 4
I did, but I'm not sure if I know it well enough to help. Go to a local community college and get a text book on it. Sounds nerdy I know, but you would be surprised how much can be done in Access and Excel once you learn.
97 RS- Runs, but never driven 2000 Subaru Outback- Daily Driver
#5835, "RE: Anyone knowledgable in Microsoft Access?" In response to Reply # 9
Okay, so you already have a template. I assume it looks like this
Column1: Column2 Column3 Material material cost retail cost
All the above is already stored in one or more tables, correct?
Next, you want to input in a specific measurement, and output a material cost, and a retail cost. Correct?
Do this by running a query. Put the "cost of parts table" and the "retail parts price table" into the query. You can make a query that calculates all the materials that are say measured by length. You place material into field 1, material cost into field 2, and retail cost into field 3. Into field four, simply input in your length, and after that put *material cost. This will be the total material cost. Do the same for field 5, length*retail cost. This will be your total retail cost.
Finally, you want to print invoices using all the above work. Do the "create report" option, and have them output exactly what your invoices are supposed to look like. There are a lot of options here.
all it sounds like to me is you are trying to link two tables. and just multiply square feet x price to get final cost? If so, there are a hell of a lot of easier ways to go about multiplying two numbers together.
2gnt: '99 RS-T, killed by a toyota, pending rebuild... Daily: Volt Daily #2: '99 EVG ebike- STOLEN by PEDRO
Search
Printer-friendly copy
2 Users in Chat
