Search results

I got it stupid mistake... I rearranged how they were layed out in my table and had the criteria in the wrong column...

I figured it out I had another parameter in there. But I need both.. For example under due date if the date has passed and its not completed its over due but if the date has passed and its completed its not over due.. In the due date i have the criteria as "< Date()" not what should I put in...

That didnt work it isnt pulling the action items that are overdue..

Good Morning, I am trying to run a query based on a date. Under my "Action Items" Table there is a column labeled "Due Date" it is the data type "Date/Time" and ion the table shows up as "M/DD/YYYY". I have a query called "Overdue Action Items" I want this query to only pull the items that have...

Thank you that was it... Such a simple mistake :banghead: .. Thank you for looking at it for me. And I will take a look at that article!

I did try what you had posted and it still prints both records... Is there anyway I can privately send you the database?

I changed it and it is still printing all the records idk why... should i have parameters on the report or something. I tried a different coding way and it did the same thing.. this is what else i have tried but it would print all the records as well Private Sub Command317_Click() On Error...

Here is the code: Private Sub Command317_Click() DoCmd.OpenReport "Bread Mold Report", , , "Swab Date = #" & Me.Text307 & "#" End Sub And I have it in a button on the form. When the user clicks the button a pop up comes up asks for the date and then still prints all the records.

I have tried that code idk if i am putting it in the wrong place or what but it isnt working for me.

Hey guys! I am trying to get a report to print out one one record that I want.. I feel like this should be easier than it seeming to be.. I want it to be able to be sorted by date and the user just picks a date and one record is printed out on page. Right now every record that is stored is...

This worked all except for when the number lands exactly on one of the lower acceptable, actionable and upper acceptable, actionable. It is supposed to be a greater than (not a greater than or equal to) For example: Specified Weight=37 L. Acc=35 L. Act=33 U. Acc=39 U. Act= 41 Right now if...

I have figure it out thanks though. I put the query in a subform and used the requery VBA.

I am trying to show the result of the query in a textbox on a form. My problem comes in because the query takes two numbers that form to run and I cant seem to get the form to update after the two numbers are entered into the form. I want the user to be able to enter in the two different...

I need to run a query in a form right now I have it as a button where the user presses and the result shows up in a different query screen. I am trying to figure out a way to show the result of the query directly onto the form. I have tried a subquery and it doesnt seem to update at all based...

You can use conditional formatting based on a query? It has to be off the query because as the specified weight number gets bigger so does the different rating ranges.. I tried using conditional formatting on the text boxes at first but then i figured out that the ranges change. I tried to use...

Thank You so much I didnt even think about using an AND function in there it worked. Another quick question Im not sure is possible.. Is there anyway to implement this into a form. Say the user enters the specified weight and actual weight on a form can I put a button or something to either say...

I am having a problem to get my query to run properly. I have a huge IIf statement that doesnt seem to be working but Im not sure what is wrong with it. What it is supposed to do is return a good, actionable, or poor based on a specified weight and an actual weight. So what the query does is...

I thought about what you said. I changed it to where the user can input the deduction but I put a validation rule on it to where they can only enter the numbers I want. Thank you for all of your help!

Theres no need for it to be copied to a new table the same table would be fine thats how it all has to end up anyway. I appreciate everyones help Im just going to tell my boss it can not be done and use excel. thanks anyway

So in scoring a bread loaf there are 12 different sections each allotted an amount of points. Those points add up to 100 (total score). Now if something is wrong in any section there are deductions that get deducted from the sections score. and then all sections scores are summed and given a...