Recent content by Shannon3778

thank you!!! I knew it had to be something simple!!!

I have 2 tables. One is the scheduled time for our associates to take breaks and one is the actual time they took breaks. I have to find a way to compare the 2 tables to find out who tooks unscheduled breaks. Because the raw data comes from 2 different places and systems and are completely...

I have a query that is drawing info from a union query. There is a time column that is bringing over time in long form (ex 10/17/2013 4:00:00 pm) and just the time (4:00:00 pm). This actually works for me b/c it lets me see which table each piece of data came from but I need a helper column w/ a...

I have 2 tables in my database. One is a predicted table that gives the predictions for staffing, etc. The 2nd table shows the actual results. I've created a "Before" query and an "After Query" showing me only the fields that I need to see compared. Now I can't figure out how to find...

I have a report with 3 fields in it. I have made the control source for each field an average of the #'s in the field of the query. I only want it to show 1 record but can't seem to figure out how. I've already listed the cycle option to current record, but it still shows the 3 fields repeating...

Here is a sample... I need a query that will return anyone with a rating of 2 or below in May AND June instead of May or June...

I have a table with associate names and rankings for each month. I need some way to find out which associates appear in 2 consecutive months with a certain rating. I have a query that will allow you to key in which month you want to look at, but I can't figure out how to write the query to...

I've been trying to have it show in my table when all along I should have just been creating a query and then running the report from the query...such an easy fix... guess I'm showing how new at this I am... Thanks for the help!

Everytime I enter in the dateadd("m",1,[date_ mplemented])) formula for the calculated field I get an error that says " The expression dateadd("m",1,[date_ mplemented])) cannot be used in a calculated column...???

I'm attempting to use it for a calculated field in my main table...

it's not the 2/31 that isn't working... its that when I attempt to put in dateadd, it doesn't show as a valid funtion in 2010 acess... maybe I'm entering it in incorrectly... The field I'm basing it on is a date field called "date_implemented". I need a formula for a calculated field that will...

I'm trying to produce a calculated field in my table that will calculate the next month (same day) as another field in my table and cannot find the function to produce this result... the dateadd function doesn't seem to work in 2010 access and I'm stuck!!! Help please?? Oh, and in the event...

Forgive me if this is an ignorant question, but if I haven't split the database, and the users all go to the same file location to open it, how would someone connect to the wrong BE?

Got it! Thanks!!

Sorry... the option of making it a single user so that only 1 person can be in it at a time. :)