@SmileyCoder
Thank you for the video on using a function in a query.
I have used Rabbits' Coalesce function in the query. It is working great. Very simple solution ( though it took some time to fill in the array input values)
Thank you Guys.
I will get back to you all again for more help in my Access learning :-)
Keep Rocking
enigma19
Last Activity: Dec 14 '12, 06:05 AM
Joined: Oct 22 '12
Location:
-
-
@SmileyCoder
I will go through the video. Thanks.
:-)Leave a comment:
-
@Rabbit
Thank you for the reply.
I am a newbie in Access programming. I really have no idea have to use this piece of code to get the desired outcome.
I will go through the Coalesce function (its new to me) and try to understand the code.Leave a comment:
-
TheSmileyCoder,
My Access Guru....Brillia nt!!!
This is exactly what i wanted.
I have one more question. Can i have the same result in a query? In your example you had designed a form with calculate cmd button. I would like to have it as a query with a calculated field, so that i can use this field in another query to calculate the difference between Quantity required and Quantity ordered. That would help me to...Leave a comment:
-
Ok. I will definitely read it.
SmileyCoder.. Thanks a lot. You are very helpful :-)Leave a comment:
-
The table is overwritten each time.
I am using Excel 2007. I am not having CSV option when i do save as. I am attaching the excel file...Leave a comment:
-
What is csv?
Not sure what format that is.
Will an excel file do?Last edited by TheSmileyCoder; Oct 22 '12, 11:57 AM.Leave a comment:
-
No. The lot fields are not variable. In order to simplfy i gave lot1 - Lot 3. I will fix the max lot number at Lot 10.It would be fixed number of fields.Leave a comment:
-
What i am looking for is to check each field from Lot1 to Lot 3 ( from left to right) if it is not null, when true it has to move to the next field till end of field (EOF). When false it has to return the value of the previous field (non null).
Or.
Check the fields from right to left ( Lot 3 to Lot 1) and then return the first non null value.
Anyway would do. But i am just a beginner in Access. Not sure...Leave a comment:
-
@twinnyfo
Some items may have all 3 lots ordered and some may have only 1 till the end. All other column value will be null in this caseLeave a comment:
-
@Smiley Coder
I recieve this table in this format from another team( Procurement department) and the data is huge around 450-500 items and around 10 lot numbers ( Lot 1 , Lot2 , Lot3.. .. Lot10). it is difficult for me to split the data into different tables.I just import into my database and want to use it as such. That is the reason i am trying to find a alternate method to get this done.
I want to know how can the...Leave a comment:
-
looping through recordsets for calculated fields
Hi ,
I need help to solve this problem
Problem definition:
I have a table 'tblItemOrdQty' with item name and its order quantities (Lot1,Lot2,Lot3 .... etc). Each items are ordered in different lots. Some are ordered as single lot.. some in two lots.. some in three lots etc.
My objective is to have a new column ( a calculated field) with the value of latest order quantity for each item.
...
No activity results to display
Leave a comment: