Running & Setting Up Queries - Page 405

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
Multiply by Dlookup() by Ripper I have a rate that changes from time to time and am trying to multiply a value *dlookup("","") I get an error message. Am I using the wrong syntax or is...	October 23rd, 2008 11:24 AM by Michel Walsh	5	99
Pull every Nth record based on starting value by LisaInAz I am using Access 2002. I have a sorted table and I used the DynamicCounter logic to number the rows 1 through end of file, as I can not use another PK. I...	October 23rd, 2008 06:59 AM by LisaInAz	5	124
make table queries not working by subs my access database is greater than 2 GB. now when i run a make table queries- i get this error- " Invalid argument". what should i do. When i compact the...	October 23rd, 2008 04:37 AM by John W. Vinson	1	90
Self-generating Number by [email protected] Good evening everyone, I built a database to track reprocessing of parts that were fixed where I work. We are required by instruction to serialize these...	October 23rd, 2008 12:50 AM by Bob Barrows [MVP]	7	119
How to Exclude Duplicates by Lisa W. I am trying to get query results that will exclude all duplicate records. I only want to see results of records that are not dups. Is this...	October 23rd, 2008 12:39 AM by Lisa W.	7	100
Need help sorting a self join query by Max Moor Hi All, I have a table of employees, each with a unique ID. Each employee record also includes a "ReportsTo" field, which contains either a 1, if...	October 22nd, 2008 11:51 PM by John W. Vinson	4	115
Average last 30 days for each day in the quarter by [email protected] I have an access database with a table of info for the past year. 236 records for each day x 365 days. What I need is an access query that will give me an...	October 22nd, 2008 10:35 PM by Jeff Boyce	7	97
Seperate First Name and Last Name by Jeanne S I have imported data into a database that has the Last Name, First Name M in one field and I want to seperate them in a query. I have used the following for...	October 22nd, 2008 10:14 PM by John W. Vinson	3	94
Data Normalization by Trisha Can you please define Data Normalization using a simple example? Thanks	October 22nd, 2008 09:48 PM by John W. Vinson	2	71
manipulate inported table by Dennis Villareal[_2_] ok i have a field that shows YLD=58415/TEN=67182/ELG=29.76 or YLD=62793/TEN=77688/ELG=32.3 or YLD=135470/TEN=146793/ELG=10.9 ...	October 22nd, 2008 09:45 PM by Dennis Villareal[_2_]	4	71
dateadd/future date by Donna I have posted a question similar to this one, but it wasn't quite working the way I need it to. I have a calibration date (day calibration was performed)...	October 22nd, 2008 09:18 PM by Donna	6	112
60 days old by Microwave how to identify data greater than 60 days old	October 22nd, 2008 08:32 PM by KARL DEWEY	1	74
Append with multiple criteria?? by Gary F Shelton Want some advice on how to design some data. I have created an inventory table. In the table it has many fields which provide good reference points. I now...	October 22nd, 2008 07:19 PM by John W. Vinson	2	86
Less than Or Equal by bladelock I am trying to write a query that will substract two dates from one another and display only the results of "Less Than Or Equal to 1" Here is what I have so...	October 22nd, 2008 07:05 PM by bladelock	2	80
I need 3 sql help by Skido Data Request 1: Find customers who placed orders on or after May 1, 1998. Show distinct company names of these customers. Data Request 2: Using the query you...	October 22nd, 2008 07:01 PM by John W. Vinson	2	93
Shelf Life by Gary F Shelton NOTE: I have a field called SHLF_Life and in it there are some null fields. I want to replace the null fields with 365. I have wrote a statement and it works...	October 22nd, 2008 06:26 PM by John W. Vinson	5	120
Big format problem when exporting a query to excel by RobertM I'm trying to export a query to Excel. Below is an example of the numbers I want to see: 0.001568257 0.00021853 0.00001812 Here are the values coming up in...	October 22nd, 2008 05:19 PM by John Spencer	3	102
Make Table Query by Samy Hi I have 2 tables saved in the same database. Table A has 2 fields (age and ID). The other table, Table B has 49 fields, 1 being ID. I need to combine all...	October 22nd, 2008 03:54 PM by KARL DEWEY	1	83
Manipulating data type from linked table to run query by ges681 via AccessMonster.com I am trying to run a query that works off a range in my query. I based it off this format: WHERE yourDateField BETWEEN...	October 22nd, 2008 02:24 PM by ges681 via AccessMonster.com	4	76
Replace Multiple Substrings by Phish76 Hi I have fields containing "Personal Reference 123456/PC". I need to only keep the number and get rid of Personal Reference an /PC. I can use the replace...	October 22nd, 2008 01:09 PM by John Spencer	1	72

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed