Access Sequential Dates

Question

I am trying to get access to auto date an order entry. So 1/1/14 is a Monday and they are selling someone hot dog that day. 1/2/14 is Tuesday and they are selling them one Hamburger. Each day of the week is always assigned a specific food. People submit preorders and we have to enter the data into the database before it is served. I have a subtable for each order content and when adding them I want Access to automatically put the next date so I don't have to type in the 1/1/14, 1/2/14, etc.

Also it would be great if access automatically did not use weekend dates.

I am not able to code at all, and could not find any information on this so it might not even be possible.

Thanks in advance!

Answer 1

I'm looking for something like they said in http://www.experts-exchange.com/Database/MS\_Access/Q\_28039643.html#view-all

Answer 2

I tried making the append query. I don't know how to formulate it to more rows. I'm not sure that this fits my purpose. The food that each person is ordering has not already been entered to the table and I don't think the append query will help me in the initial data entry.

Do you think there is any other way or am I doing the append query wrong?

Thanks

Answer 3

On main form have text box to enter/select how many entries for the order and have it run an append query to add that many records in the "Food per Order" table upon enter.

Answer 4

I have two tables for orders. One is called "Orders" and has info on the administrative stuff: name, date ordered, cash or check, prepaid or not, etc.

The second table called "Food per Order" is linked to it by the Order Number which is the Primary Key in the Orders Table. Then I add the individual food items that the person is ordering to the "Food Per Order" table. (They can order one meal in advance or weeks or months, etc. So you can see how if someone ordered months in advance that would be 30 + things to enter.) I need to give each item ordered the specific date it will be served so the user can use my queries and reports to see how much food he is making daily.

When I have to enter every food item it is really time consuming. I also considered creating a Week Option where they can put in the computer that they ordered a meal for every day of the week and not individual days but I am having a hard time with the relationships between the dates. Ideally access could automatically put the next date in on my "Food per Order" table to save some data entry.

If you can think of any better ways to structure it, I am all ears!

Thank you!

Answer 5

Post what your table structure is like - field name & data type.  What is the relationship between the tables?