Search results

I have 2 tables. The first is setup like this: ID, NUM, VALUE 1 5 Dan 1 11 11/01/1985 1 65 Length 1 32 86 2 5 Dave 2 11 6/15/1972 2 65 Length 2 33 44 3 5 Greg 3 11 9/041961 3 15 53 3 8 M...

I am not so great at writing functions from scratch, rather I generally have to find something that sort of accomplishes a similar task and then modify it to fit my needs. Unfortunately I haven't been able to find anything this specific yet. The idea is that I have a table with products. It...

My memory is not what it used to be... what a horrible feeling that is! I have a table that track monthly data for several thousand products. The idea is to grab the first month and the first three months of sales for each product. So I simply need to have a statement that scans through a...

I have a simple function that expects a string variable to be passed along to it. My intent is to send the contents of a column from a table as this string, so basically for every row in my table I want to pass the contents over to my code and have it run. So lets say I only had 3 rows in a...

A break from the more serious threads. Using jscript on a website it is possible to make a user button "runaway" from the mouse cursor. Got a new guy coming in to learn one of the databases I've created and I'd like to have a little fun, so I was thinking about doing something similar with the...

I have been searching for solutions to this problem, yet all I have found are little work arounds - nothing that directly addresses the issue. I have a file that we import using another program. I have written an import spec to bring it into access where I will prune out some entries. At this...

I have a query I use across 20 tables to check for differences for them. Before my updating process begins my original table is copied to a backup table. In this case the original table is named "vermillion" and it is copied to "vermillion_b4" as a backup. Generally I then run updates on the...

I am currently using a (DoCmd.Transfertext acImportFixed, "specification name", "table name", "source file", true) statement to bring in data. I've been using it for several months and I thought it was working fine. Today I realize that in the event the input file only has 1 line of data in...

Hello, I have a table setup where X = Identifier Y = Data The identifier is not unique in this case, as the table is loaded with a history of all possible Y values for each X. My goal is to write a query which groups the data by X but only where Y is different (if the Y is the same across...