Search results

jdraw, the original expiration date is (shelf Life Exp). I have a field that has the number of extensions(up to 3) and fields for the months that i can be extended for each extension.(18mo for first,12mo for second, 6mo for third extension). I need to take the shelf life expiration date and...

I'm trying to calculate expiration dates based on an original expiration date then if it can be extended based on the number in a field use that number then it will add the amount of months in another field and add it to the original expiration date. Here is what i have so far that doesn't work...

The DB is 39M so it won't but I have attached a pic of the screen from the report and what I have in there now. I realized what I might have been doing wrong, I needed to add the NIIN that the report was based on and then do the validation.

Iif(Dlookup([NIIN],"PREX",[Material]),"YES","NO") and different variations of iif isnull plus then ones you guys have given me.

Demand and PREX are both tables. If PREX.NIIN=DEMAND.MATERIAL, "Y" if not "N" I have tried putting them in the same query but it just shows all yes. I've tried ISNULL and IF statement but can't get those to work either. I know I'm doing something wrong but what I don't know.

I'm building a report and I need to validate if 1 field on a table is listed in another table. I've tried almost everything and can't get anything to work. I built the unmatched query to separate the data but still cant seem to get it to work. All help is appreciated. Table: DEMAND Field...

Yeah but I am going to give this to people that don't know access to use and I don't want them to have to do too much to get the info where it needs to be.

Here is the SQL statement. I have put in the "IN" statement with the months but it didn't do what I am looking for. I tried the "(JAN, FEB....) but I want it to show the last 12 months depending on the data that is in the table. Thanks for the help! Chris

I have a crosstab query that I pull the last 12 months of data from but when I update the data it puts the new data at the end of the columns. I have attached a pic of the data and you can see where it should go. How do i sort it to ensure that the columns go where they should. Thanks in...

AUG-13 SEPT-13 OCT-13 Frequency Total Ordered QTY AMD 1 1 1 3 5 .55 Them AMD is what I'm after. The others I have but cant get the formula to work right in the crosstab. I get it to work in the report...

Was the data what you needed?

Here is the datasheet view and the design view. I need to divide the "Total Ordered" by the "Frequency" by the number of months listed on the query.

My database has a crosstab query that counts the number of hits by month. I have two columns that are named "Count of Material"(Frequency) and "Sum of ordered Qty"(Total ordered). I need add a colum to find the Average Monthly Demand by dividing the Total ordered/Frequency/number of months in...

I knew it was something silly I was missing. I have been racking my brain all morning trying to get that. Thanks! Chris

I have a report that I am trying to complete based on several queries. I am trying to count the number of records based on certain criteria and using the following DCount. =DCount("[Calculated time]","IPG1","[Calculated Time] <= 0.04" And [Ship-to party] In...

Yeah I tried to use the same format from Excel to Access but that didn't work and now I know why. I ended up using Access to calculate the time vice Excel. When I down load the file to Excel the calculations are already done which is why I was trying to use them instead of reinventing the wheel...

Ok. Well that makes me feel better that I wasn't going crazy. I'll try to get the data to calculate in a query after I import into Access. Thanks for the sanity check. Chris

I got the formula to calculate the time between the dates but i can't seem to get the right formula to convert over to Access from Excel. How do I need to format the cells to get them to convert properly? If I try to make them DD:HH:MM:SS in Excel, it won't convert the days over. It gives me the...

I tried everyway with the formatting in Excel but i can't get Access to show it the same way. Check the screen shots above.

Here are the screen shots.