Search results for query: *

GingerR I am at work right now, without either database. I hope you do understand I am asking about 2 separate Access Files. If you will, let's work the other one and then if you will, help with with this one, it seems a lot harder and the other is almost complete. thanks Army Scott

thanks again GingerR 0) Yes each Buyer is related to only one customer. However, there can be numerous buyers for the customer. Buyer is the name of the individual representing the customer. A) You are correct, there was a company who changed names, (side notte: I build this in Excel last...

GingerR I check it out, but I'm kinda lost when it comes to the forms such as, at the very bottom it has two fields that are know where in the tables. Are they just pretend names or what. Looking at tracking the OnHand numbers. I'll look at it again and get back to you if your willing to...

Wow guys lots of Q's, thanks Ok, there are 2 tables in question table 1 named STEP 1 customer (primary Key) address city state table 2 named STEP 2 customer buyer (primary key) buyerName buyerPhone buyerFax table 3 named STEP 3 Customer PartNumber (each customer has their own part...

This is a big one. I am preparing an inventory for 8 seperate locations. The want to track beginning inventory, actual count, shortages, sold and new new inventory. Updates will be made a minimum of weekly. Want to be able to track sales for all locations. This is a cologn and perfume kiask...

I am using two tables in a consolidated form. I would like to be able when I update the form that both tables be updated. Meaning that the new primary key information placed in the 1st table be automatically inserted to the 2nd table. The items in both tables are CUSTOMER and PARTNUMBER...

I am new to the Access world, but loving it. I have been tasked to create a simple mathamatical formula, however I just don't have the knowledge (yet). I have two columns named OnHand (inventory On Hand) and PricePer (cost per item). I want to create a query with a third column called...

Ken where do I do the "SELECT ......" from. Am I creating a Query? Can I leave the dates as text or must they be converted to be read. It is a download form the Army will they have given me special permission to receive my data directly from them. If you don't mind, can you spell it out...

I am new at this so I appologize for not giving enough information. I am in the US Army and developing a reporting system that shows when soldiers are due periodic physicals (required every 5 years) and annual Physical Fitness Tests. The date for each LAST_PHYS and APRT are in a text format...

I am new at this so I appologize for not giving enough information. I am in the US Army and developing a reporting system that shows when soldiers are due periodic physicals (required every 5 years) and annual Physical Fitness Tests. The date for each LAST_PHYS and APRT are in a text format...

I am wanting to use a table with the date entry of yyyymm and be able to find out when the date is 13 months old. example 200001 and 200101 it is fine, but at 200102 it becomes late. there are processes which must be updated yearly, I need to find out without changing the formula, how to do...