Search results

  1. D

    Simple Query Problem

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

    Getting a report to print one record instead of all of them

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

    Query showing up on a form

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

    Formatting based on a query

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

    IIf Statement Query

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

    VBA Code for IIf statement

    Is there anyway to use the After Update feature to write a VBA code for an IIf statement... Im trying to store the value of a field that gives me a number based on which radio button is pushed and it seems that absolutely no one has heard of this...
  7. D

    Calculated textbox to table

    Hey, I am trying to get a value from a textbox into a table I created... The textbox "calculates a number based on which radio button is pressed example if radio button 1 is pressed it returns 0 if radio button two is pressed it returns 8 and if radio button 3 is pressed it returns 15." I need...
  8. D

    Chronological Order

    I am trying to figure how to get some information to show up in chronological order. For example, It is showing up like this.. Week 1 Week 10 Week 2 Week 20 Week 3 Week 4 and so on I want it like week 1 week 2 week 3 week 4 week 10 week 20 Anyway i can do this? please help
Top Bottom