Search results for query: *

Is there a software or an easy way to convert queries built in server 2008 to Access? I have a few dozen queries for various projects that on their own work fine, but I'm beinging a new project that will combine the data from these queries with spreadsheets sent over from other departments...

True, but with a different person of the team running them every quarter or even multiple people and different amounts of data everytime wouldn't that cause some data compromise at some point?

I add and delete it because once the csv is imported it takes the original file from 3 megs to 18 and not everyone's pc here is the same. I have more ram and can run larger files but it just locks up for the rest of them. So to keep the original file running smoothly and not breaking in the...

Excellent, but to throw a wrench in it, the macro as a whole adds Accnt Details2 as a sheet, then creates the import and imports everything, then after copy/pasting to the appropriate sheets deletes the Accnt Details2 sheet. So there is no refreshing of the connection only building of it...

Hi, I've got code written to import a csv file to a worksheet, the csv file will always be housed in the same folder on our server, the problem is everyone running the code has that paticular server named something different ie X:\Shared or G:\Shared or I:\Shared. I have a code that allows you...

I need help with checkboxes and based on everything I have searched I have not found out if this is actually possible. I have a simple form with 15 checkboxes, 2 text boxes for dates and a button to run the query. Each checkbox represents a different skill listed in a data table, ie DPU...

Hi! I have a table Name, Date, Hours, Comments. Each day an employee will have an entry Name, Date Hours, Comments (which might be blank). I need a weekending report that shows Name, Total Hours (summed, and all the comments. This is where the problem lies. I have the hrs totaled but I...

Thank you guys so much! I will try and get it sent out to each person to have on their PC. MoLaker, I am not able to import the tables it won't even let me choose the db as the same error pops up. Luckily my boss who looked at it last week was able to figure out that I had left all the...

Hello, I have a db that houses our payroll for nearlly 260 employees. There are only about 18 people who use it on a daily/weekly basis. The db is split, the front end is the one that is having issues. This Friday afternoon I get a phone call that it won't open, the below error is what pops...

Hi I have a team of 15 people, each having there own time cards for each day of the week. The report looks something like this: Name Date LogIn LogOut Smith,John 2-Feb-07 900 1730 Smith,John 3-Feb-07 900 1731 " " " " Total Hours: 40:25 Tony,Bobby...

Well I now have a more pressing issue to deal with. My queries dont seem to be working, at all. I have not made any changes to tables or their relationships but even when I create a very simple query I am getting no results returned. At first I though I must have accidentally altered my...

Skip your a genious! It worked until I tried to add more calculated fields, then it doubles the returns again...what am I doing wrong? SELECT DISTINCT [tbl_CSV_name-payroll].Name, [tbl_CSV_name-payroll].Supervisor, tbl_CSV_payroll.Date, tbl_daily_schedule.[Start Time], tbl_CSV_payroll.LogIn...

Skip, tried it still getting duplicate results.

here ya go SELECT [tbl_CSV_name-payroll].Name, [tbl_CSV_name-payroll].Supervisor, tbl_CSV_payroll.Date, tbl_daily_schedule.[Start Time], tbl_CSV_payroll.LogIn, [tbl_daily_schedule]![Start Time]-[tbl_CSV_payroll]![LogIn] AS [Start Variance] FROM tbl_daily_schedule INNER JOIN (tbl_CSV_payroll...

Actually they are both in the Date/Time format - Medium Date in fact.

I have a query that pulls from 3 tables, tblNames (Name & Supervisor Name) tblPayroll (start & end times) and tblSchedule (scheduled Start & End times). In the query there is a date range criteria in the date field. The various calculations in the query work fine except it returns 2 records...

I have a database setup on a network drive with a front and back end with multiple users allowed. The database has worked beautifully until today. I was in redoing a form which of course locked the database, after awhile I went to save a recent change and it told me it was locked user<name> on...

Sorry for the delay, but thank you it works beautifully!! You guys have been such a huge help I can now finalize everything and show Management, thank you thank you thank you!!!

No problem, let's see if this helps. Save: ([TotalTime]-[Lunch Time])+[Sick1]+[Vac1]+[Flt1]+[Other1] [Save] gives me an agents total hours for a given day including sick, vac etc. It is returned as a decimal value, for an employee who works an 8:02 day it returns 0.33472222222. This formula...

Save is just a general# calculated field, it contains some minor adding and subtracting of other fields. None of which are date/time formatted. 24*Int([Save])+Hour([Save]) & Format(Sum([Save]),':nn') This formula converts it to a time format. The formula I am having trouble with should be...