Search results

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...

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...

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...

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 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...

I have an Excel spreadsheet that I import to Access 2010 that I cannot seem to get the times to convert. The times are listed as below: EXCEL dd:hh:mm:ss which gives me 05:20:52:19 hh:mm:ss@ which gives me 140:52:19 I could use either...

I have a table that i am importing that has alphanumeric content and upon import from excel 2010 to access 2010 it drops the leading zeros. I have tried formatting the excel spreadsheet to every possible combination but it still drops them. What format am i missing? Here is the field names and...

I have an excel spreadsheet that I am building a database for. I am close to being done but ran into problems with the report function. The database that I have has 1 table that has several months of data that I want to run a report for a specified month. The issue that I am having is that each...

Hopefully I can learn more than I know and help some along the way. Thanks for letting me be a part of the forum.