Search results

thank you. It works perfectly now. :) But now it says I am "missing operator" in the created date field. know what that's about?

right after the words "created date". created dateBetween [Enter Start Date] And [Enter End Date] I am not too savvy with codes. I don't really know their principles.

is there a specific format that i need to have it in? The field currently just has"created date" in it. It keeps saying invalid syntax.

alright so have open the "Query Parameters" box, but what do I need to put in to get it to do what I want?

I have a report that displays Item, Transaction, Quantity, and Created date. i need to have it so that when I open this report it asks for the date specifications. A beginning date and an ending date. How do i get it to do this?

Can you upload any picture from you computer into a form or report and put it in the Header?

There was a field in a template for inventory that I downloaded that I did not need so I deleted it. It was a field for location, but all of the inventory is located in the same area. But when I go to the reports for stock levels by date, item, or reorder level a pop-up appear that states...

Okay so I know that the Foreign key is simply the primary key from another table, but how do you assign it? Does someone have to go and look it up and then type it in every time they make a new row? And do unique keys have to be assigned or how does that work? And if I use the Pk from Parts...

Thanks again. I need to leave this office for now, but I will be on tomorrow 8am-5pm eastern time. I will undoubtedly need your assistance. If you are available that is. I feel better about this new database already.:)

what does FK and PK stand for?

would the Parts and Inventories fields be the same? Also what type of different fields would there be from the orders table and the order line table? So my tables should be: Inventories, Parts, Orders, Order Line Items, and Vendors?(invoice # is a field in the orders table)

Alright. That really clears things up for me. thank you very much!

VERY helpful, but when you mention the "Inventories" table would that be a table that simply showed input/output of the inventory or would it update to "parts" table to show how much total there was at any given time?

Okay so I would say that it is safe to assume that my attempt at my first database is crude at best. I was just wondering if any of you design pros might be able to help me figure out what I need to create. Alright so this Database is meant to keep track of inventory items that are held in a...

Thank you Big Pat I found your reply to be very informative. :D

I looked at it, but I am just not really sure how to do that. I guess I will just have do a lot of researching around this site. I only have a few weeks to finish this project though and I am kind of nervous. I had NO previous access experience and have been given the task of creating a...

Not really sure what the AA1 signifies. To be honest I would probably need a good tutorial for something like this. All of my access knowledge thus far has come mostly from messing around with it and I am sure I have several misconceptions on how things work. So would I need to make a query...

Alright so i have these few tables and a couple of forms to go with them. I was just wondering if anyone would mind taking a look at the structure of my tables to see if everything looks okay, or if not any suggestions would be much appreciated. This is my first attempt at a database.

How do you make a query that takes data from one field and get it to subtract from the correlating field in another table? For instance: I have 43 Gears. The next day 4 of them are used for repairs. So I have one table "Item Use" with Gears-4 and the original with Gears-43. I need the 4 to...

Note: I did try searching before posting Alright so I have a table titled "Current Inventory". This table consists of item IDs, the item name, and the current amount of that item among other things. I currently have a form which edits a table titled "Inventory Use" which is used to display...