Search results

Nobody can give me good advice? I write below is an example maybe understand me better. Basically I have to apply the logic of stock FIFO (First in First Out) Table Orders : Part Number A B A C Table Stock : Part Number - Serial Number - Date A - 1 - 25/03/2011 A - 2 - 25/02/2011 A-...

Thank you both. Unfortunately, the serial numbers do not correspond to the oldest part, so I can only use the date recorded. Now I try to use what you've written, and I'll let you know Here I report the code that I wrote but that does not return only a serial number corresponding to a code...

Hello everyone, I am writing for show my issue with a query. I have two tables : "Order" & "Stock". Table Order have "Code Number" Table Stock have "Code Number", "Serial Number", "Date" I'd like to create a query that takes the serial number that belong to the Code Number, and...

i have used the ivbanet's Advice on post #3 is right, i don't know where i made a mistake Thanks

Ok Thank You very much now is all right!!!!

Hi, I have two dates, Shipping Date and Delivery date... I wrote this on a query Select ID CoDe --> from Table1 --> where (DateDiff("d",[table1].[shipping Date],[table1].[Delivery date],2)>2) What's Wrong ? The Query doesn't work...:(:o:o:confused: Thank You

i resolved my problem Thank you for all...

Ok, now i am busy at work tomorrow i show a sample!!! Thank You very much!!!

excuse me, now I will try to explain better! Table "A" is a table with lots of data, for example, I have "mickeymouse" has been shopping "Monday, Tuesday etc", then through other query I have the table "B" which of course contains when mickey mouse had be shopping but only the day "Monday" So...

Hello everyone, I still need your help ... I have two tables "A" & "B" ... "B" is the result of a selection of "A ". I would like to count how many times is the name "Mickey Mouse" in the "B" and how many times has this in the "A" and then calculate the percentage of presence with the...

Ok now i am trying!!! Thank you very much!!

"If your field only has Months how do you expect to know which weekday it is?" My field is format date Month/Day/Year; "You mean you want to remove Fri, Sat and Sun from the calendar or not allow users choose those days?" I want a selection query wich don't pick up record where the day is...

Thank you very much vbaInet!!:) Just enough time to get to know the forum and then i hope to be useful to someone!!

Hi, thank you for your answer... The table A and B are related with a Code. My control is about data of a month, if i use your mode i have to make every month put the number of the days(Friday Saturday and Sunday) before to start my control ? I understand right? There is not a criteria wich...

Hi to all, I need to know, how can i have a control about a kind of a day (Work day or Holiday Day) I have to know if the day in a table "A" was Friday,Saturday or Sunday; if the day i check is like Friday, Saturday or Sunday, i don't want that day will be into my selection table "B". How...

Hi to everybody, i am writing from Italy. i work with Access for hobby , i help some friends wich want have a control for their activities. Congrats for this forum is very rich of very precious information!!! :):)