Search results

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

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

How can I make a warning pop up when a user tries to access a database that another user is already in??

I've got a report with multiple date fields. I only want the fields that have todays date in them to be visible but with the code I've written, all of the data in the field disappears even if it does have today's date... here's an example of the code I'm using Private Sub Report_Load() If [Week...

I need to create a report that goes out to specific individuals (emails are a field in my table) when a specific date (also a field in my table) comes up. I've created a report that I can run and a form that allows me to put date ranges in, but that report compiles all of the individuals into...

Help?!?!? My report looks perfect in report view but it won't print. When I click print preview, I get an error message that says " the sum of the top margin, the bottom margin, the height of the page header, and the height of the page footer is greater than the length of the page you are...

Help!! I'm really stumped!:eek: I've created queries with date parameters and I created reports from those individual queries. Now, I'm trying to create 1 big report with all of the query reports in it as sub reports. I was able to create it, but now, when I click to run the report, it asks me...

I need to create 1 report that includes info from many queries... is this even possible? I'm new to access and attempting to teach myself as I go but at this point feel like:banghead:...

I would like to create a form that will prefill fields with the information from the table fields that those form field are bound to... For example: I'd like for the form user to be able to enter in an associate id number and the form prefill the rest of the fields. Some will be blank b/c they...

Hi!! I'm new to Microsoft Access and desperately trying to teach myself. I've taught myself the majority of the other Microsoft systems, but this one seems to be getting the best of me... hoping to find help here!!:o