Firstly, let me apologize for making this beautiful cross-post. I know it bad etiquette, but in this instance I'm hoping no one will truly mind (after all...

I'm sure this will not be too advanced for someone but I'm lost with it, I'm using Access 2000. I have a table with almost 1 million records and 8...

Hi All: I have a database I import from Outlook, and am keeping a list of all active recruits. Each week, I need to update 10 logical fields to see how many...

Hello, I would like guidance producing a query statement that will count the number of times a particular name appears in query/table. I have created a query...

I have a query that I am trying to find out who did not submit a report during a particular time period. The unmatched works for all if I do not have the...

Hi Guys, I have an got an invoice application and want to be able to part dispatch items and append a letter to each invoice , so for each dispatch I...

Hi I am currently trying to make a query for a pareto chart. For this I need to be able to calculate a running sum. I have a query that shows top 5 result...

Hello, I have a query as a Recordsource for a form. It originally contained two tables, and with an inner join. It was updateable. SELECT .*,...

I need to take a series of numbers that are in different fields and combine them into one number. I am linking to a spreadsheet that contains our UPC codes....

This is what I have: 1) A tblLocation with 3 numerical records called OfficeID (1,2,3) 2) A query called qryData based on the tblData. The Criteria in the...

I have a database with duplicate records within a Table. The ENTIRE record is duplicate except for the Key which is an Auto Number which Access automatically...

Hi All: I have a query like: Dept Sec G1 G2 G3 M1 M2 M3 ACC 100 3.5 2.8 3.2 ACC 100 2.6 3.1 3.8 ACC 200 3.5 2.8 3.2 ACC 300 2.6 ...

Hello, My problem has got to do with the Purpose of Travel field (query created field). Along with for e.g. object code - 2145, purpose of travel is "Sick...

Hope somebody can help me!! I am trying to create a query that displays all submissions of applications for the past month and am finding entering the...

I can create a pivot table to show data from a query in the view that the user would like to enter the data into. However, the pivot table will not let me...

Hi. I have a query that's sloppy, and I'd like to revise the name order. I have members that can be spouses. If there is a member spouse, I'd like their names...

Hi all, I have a query with doubles and I want to know how many times the Record appears in this query. How do I do that for every row ? It's a combination...

I have created a user function that averages values in columns for each record. It seems to work fine up to a point. The table has 30 columns for scores. I...

I have 3 modules that I would like to use within a query I am designing. I currently have an expression in one field of my query that references one of...

I currently have the following SQL which works fine but requires me to enter the whole Servicing Division such as Henderson. How do I add Like & "*" without...