I am having a terrible problem creating a running sum in a query. I have created a in the query by combining the and field. I am trying to calculate a...

I have a query that has two tables joined together. The first table has fields: Plant Material Code Material Description The second table has...

I have an Access 2003 front end to an SQL 2000 database. On an employee form with a subform for related records that I include a button to delete the employee...

Hi. I'm struggling to get my query to bring back the information I want it to: Here's the fields with the criteria Contacts.MemberOption ...

I have a query as follows: Day Product Code 2/1/05 SOS 2/1/05 SBT 2/1/05 SBL 2/2/05 SBM 2/2/05 ...

Can someone help with the following recursive statement: I have an employeeID, supervisorID, supervisor_last_name and supervisor_first_name For each...

I need to know how to take a report that is grouped by account number showing cost detail - it shows the account number, all detail including spending, then at...

I'm using Office 2000 SP 3 trying to paste the results of large queries (between 5000 - 50,000 rows) to Excel and am having a problem with one machine where...

Using Access2000 - Trying to delete old data out of a table but it gives above message - turned the uniquerecords to yes - then it wants to delete all the...

Hi all, Access 2003 - I'm trying to get a list of birthdays grouped by month. My db has "Clients" and "Spouses". I create a query for each of them filtering...

I have a database that logs issues. The crosstab query shows the volume of issues by age (in days). Sample result looks like this: IssueType 1 2 4 6...

I am trying to create a query that allocates values on a pro-rata basis. However the results never add up to the original value. For instance, 85MM is...

I have two tables, one the main table "AR Details" has all invoice records with all the dollar amount, the second table "Nameaddress" has just customer names,...

Hi everyone, I am having quite a time trying to create a query that returns what I am looking for. Here’s the set up Employee Table Skill 1 Skill 2 Skill...

Hi, David! Hope you found this continuation post and have time to play... I'm still loving the PrimaryFamilyMember method. So, I think the next step (big...

Hi all, I have an update query that runs fine when I go to queries and select it but when I reference it from the form that provides the criteria, it...

I have a Query created with the Access Query designer. What I am trying to do is the following: I have a table of 'leads', consisting of information including...

That is correct. JET (the data engine in Access) is case insensitive. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users -...

Hello all :) I have read thru almost ALL of these postings and I can't find my answer though many have been helpful anyway. Thank you. I am developing one...

I have a parameter query "Cost by Style" that works wonderfully ..... I have another query I have based off of the one above "Total Cost by Piece" (because...