Search results

I was thinking I might be able to use an IIF function? IIf [Date] is between [Start Date] and [End Date]........(first formula above) but I am not sure how to go about writing it I keep getting error messages.

I unfortunately am not able to do that but I have been made aware that the reason the query is not returning the information that I want is because I need to include two different date criteria in my formula. I was also formatting the date value incorrectly which was confusing access. So this...

It is summing correctly for my M151-1A data and for the Production standard in my M151-3 data. For the total conforming data it summing all of the data for shift three and then creating a running total from that. Essentially it is ignoring the date criteria that I have set up for the entire...

I agree the data should have been stored as a numerical value but unfortunately I am working with a pre-existing data base which stores information all the way back to 2012. When the data base was set up the operation field was set up as a text field in order to be able to include those text...

I have uploaded some screen shots showing the information in my queries in both design view and data sheet view I hope it's helpful to give a more visual description. The [Date] criteria I am using is an existing field in my query so that my running total is summed by ascending dates. As far as...

Is there a way to sort text as numbers in access without omitting the data that contains text values? I am currently trying to sort by operation which includes the values 1,2,2A,3,10,11,12,....ect. When I currently sort these values because the are stored as text they appear as...

I am having some issues in access using the DSum function to create a running total in access. I am trying to create a running total for both my Production standard and total conforming parts by using the date as the criteria. I am also doing this in a totals query which is set to pull data...