Search results

Hi everyone, I'm using DAVG to look up average days in a query. All works fine but I'd like additional functionality. Here's what I have so far: =DAvg("[kitted2completed]","KittedComp") What I would like is the above to return an average based on dates from and to in column "Comp". For...

Hi everyone, I'm just doing a fairly simple DLookUp and I'm having trouble. I'm making a query that returns all the fields in a table called "NewMasterData" with an additional field called "COMPLETED". The "COMPLETED" field needs to be populated by data from a table called "WIP". What I have...

Hi guys & girls, Doing a fairly simple thing here which I'm sure I've almost cracked, however no matter what I've tried I've not had any luck. Searching didn't shed much light either. I have the following SQL: WHERE DATEDIFF('d'.startdate,enddate) > 0 The idea is to have startdate and...

Hi guys & girls, I'm having a little difficulty finding an answer to this one - I assume it's a query of some kind that I need, but I'm no expert on them. Here's the scenario: I import a big Excel file into a new table, it has no duplicate rows, but it does have duplicate values in column...

Hi all, I've figured out how to append data using VBA, it's this simple bit of code: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "NewMasterData", "Shortage List.xlsx", True However, I want to do two things: 1) Prompt the user to select which file to import. 2) Not...

Good afternoon (Or morning, if you're in the US!), This seems like a simple request, however my brain and Google aren't helping me. I have a table, which contains amongst other things, a raised date and a completed date. What I'm trying to achieve is an average date to complete, so we can...

Hello all, I'm pretty new to the world of SQL queries, I've always stuck to VB and Excel in the past... As a result, I'm struggling on things that I'm sure most would find easy. I've Google'd this to no avail, so now it's time to cry for help! I have added two new fields to an SQL query, as...

Hi guys & girls, I'm building a query, that looks in a couple of Combo Boxes and a couple of Text Boxes for data, then displays info based on what it finds. Mostly the query just looks for things like "mduffield" (ie, the username) and it works just fine. However, I'm trying to make a...

Hello all, I have a quick question which I'm sure a lot of you will know the answer to straight away... A database I am developing displays PDF files in a web browser that is on a form. If the PDF file exists, all well and good - users can print, email it etc. If the PDF file doesn't exist...

Hi guys & girls, I "borrowed" some file copying code from the web and modified it to suit my needs. It works just fine, but isn't very user friendly. The goal is to have a form load, 4 labels which are black text that individually change to green text as each file is copied. The code I...

Morning all, Currently using this code: Dim strExcelFile As String Dim strWorksheet As String Dim strDB As String Dim strTable As String Dim objDB As Database On Error GoTo ErrMan strExcelFile = "G:\whatever\whatever.xls" strWorksheet = "WorkSheet1" strDB = "\\whatever\whatever.accdb"...

Good afternoon all, Having built a fairly complex database, I'm ashamed to say I've stumbled on something that's probably very easy to solve. OK, I have a table full of data. On my form I select a date from a combo box which then generates a report that contains a chart, showing information...

Good afternoon all, I typed a long message earlier and got a database error, so excuse me if this is a little short. I'm looking for a solution to the following issue: I have three tables. Each heading is a criteria. Each row is a customer account number. On each row I can assign one...

Hello all, I'm new to the forum and would like some assistance if you wouldn't mind? I'm currently building a "Main Menu" tool for the team I work with, which has buttons and combo boxes that allow a user to choose a tool to use and then launch it. When I use "Shell" to open an Excel sheet...