I'm trying to create a query that lists records in the AllNewParts tbl where RefPart/RefPart NHL don't have a matching Part#/AS Part# in the ExcelARefParts...

The following code produces a count Per Reviewer and Per Month. I'm trying to split out each month in a seperate column, this is not working, could you please...

Hi all, Having a bit of a problem with a summary query. When it's just the carrier and area, I get returns with this code: SELECT & " " & AS...

I split a database and now have a front end and back end. Everytime we run a make table query, the table is created in the front end, how can we run the...

Hello, I am trying to create and unpaid aging invoice report. I have used to forum to obtain several hints and have been able to create a basic aging...

I have a query where I am trying to pull the Project Number, The Resource Role and the Actual Hours worked for the month. I have seven roles that I track and...

I have received much help from this Group and I hope someone can help me with this: My form has two combo box’s the purpose of the form is to pull the emp...

I want to give a "point" value to a selections made in a combo box points an (ie. time in related field is 5 years, they get "5," for 3-5 years they get...

I've come up a bit of a problem with a planner/reminder program I am making. I am using a Month view calander as a date selection option, and am using this to...

Is there a flag/setting/function that will supress (or default) the value of #error when calculating two values example Working out a percentage (thanks to...

Hi, I have a question...I have 6 tables (Test Value, Calculated Value, PI Value, Diff Value, Test Uncertainty, Diff Uncertainty). Each of these has the first...

Hi all I am using the query as(example) Select * from Q1 where frequency=F1(WeekNo) and using this function as Function F1(WeekNo As Integer) As String ...

I have no option in my advanced e-mail section to turn on the suggested names feature. Is there an update for this ?

I have a fairly data intense Contact database. I am trying to run a simple query that will filter contacts based upon a certain category. This category...

I have a querty that I want to look at DOB field and calculate if applicant is over age 18 w/o having to change the "" date each time I run it.

I have a Base query that I need to filter down via a Form. This form has 21 options (date, Drop-down boxes, Check boxes) that can be used to filter the data...

What's wrong with qdf.Execute If I use qdf.Execute, an error message comes out, but if I do not use qdf. Execute, the following codes work OK Set qdf =...

How to autofill datatable columns with increasing numbers - like the way in Excel? Given a datatable with 2 columns : ID & Data. (a) How to fill the column...

Hi- I'm a newbie to M/S Access. I need to do several calculations in a form object. Basically I want to calculate 4 intermediate results, display them...

Hi, I'm looking to pass a value from a form to a query using something like the following: Like *!!* where is a number which can be contained anywhere...