Hello, Sometimes ago, I requested and got help on truncating the last three digits from a field with data of the following format ????-????-???. I...

Hallo I have this select count query which i need to change into a random count what do i need to change to make it select random. What it does it count a Qty...

Please help. I'm trying to produce a product price list from a table that records all the price history for each item. The query should show only the last...

I have an unbound text box named Text62 with its' records source set as =Forms!Home!List0 on a form named f_PrimaryEntry that populates the text box based upon...

Hi there, i have a table that has duplicate values (maximum 2) for the field AWK_ID which is OK because 1 AWK_ID can refer to different products. i would...

I am trying to run an append query and am getting the following error: SQL0952N Processing was cancelled due to an interrupt. SQLState=57014 (#-952) I am...

I recently upgraded to Access 2003 from XP. I want to copy and paste a query result to Excel. But the "copy" and "cut" commands are disabled in the...

A query designed by someone else includes the following: SELECT Left(,4) AS YR It runs on my client's machine but not on mine. The error message I get...

Per earlier post, I am trying to save 'out' production data from a program called Solomon - basically (I think) this was /is an Access/Sql based program. We...

Hi there, I am trying to make a referral database for my boss. I have two tables REFERRALS and CODES. In REFERRALS, the table contains surname,name, date...

Order # Service 1 A 1 B 2 A 3 A 3 B 3 C ..... I have the above query in which orders...

Hello, all; I am trying to return just the records for a given course if the course id is given in the parameter of a parameter query, or all if the course...

Is there a way to query one record from a table. Specifically say the second record or the third record. I mean the criteria would not be specific data it...

I have an existing database used every 3 months for the last 4-5 years. Today, when I tried to open an existing make table query, the entire database closes....

Is there a function to take the information to the left or right of a comma? The issue is that I received a spreadsheet that has lastname, firstname and I want...

Hi folks! Sorry, but I really need urgent help. I have a table with the following fields: Date info1 info2 info3 info4 info5 I made a...

I have a table (Class Table) .... Class ID (Key), Division, Class Description, and Class On my second table I have Entry # (key), Division and Class I need...

This query is for agings debts. I want only to pull the records that are 1-45 days old. I've tried a number of ways ,but it still gives me all 56000 records...

Hello... I have table with these values: Date Product Imported Exported Total I want to view the data of the current month...

I'm trying to use the CHOOSE function as criteria in a query. Of course, it's pointed to an option group on a form. The form's option group has values 1, 2,...