First time I've tried this. I have created the "WorkingDays2" function from the mvp/access site. I Hope I did it correctly as it was my first. Now, I want...

I am having 4 records for each customer with different dates, so how can I get the last records for this customer. I also want to see 4 other fields in my...

I have a table imported from some other programme which I have no access to. The data is in text format and has strings. Example "123456789". I need to...

I am trying to create a query that will delete a duplicate record in a table. I want to delete the older record and keep the new one created. I have used the...

I'm having problem setting a parameter in an append query. I want to optionally use all records or only active records (Inactive field = False). In the...

I have a check book with deposits and checks written on the account. I would like to run a query and show a running balance next to each entry. Please help.

Hello, I was wondering if someone could help me with my query. I am creating a db to track keys and employee info for our school. I am trying to create a...

I have a table where i keep mission information. i am trying to build a query to pull the date (for date specific info), the type of aircraft, and the...

Hi I have finally managed to work out how to rank the results from a MI Quiz, however I cannot work out how to avoid having to scores equal. i.e. 2 in second...

I have a table that I want to normalize. The SQL below delivers the results in Alpha Order. But I want them to appear in field order, just like the order in...

Any ideas how to retrieve a parameter's default value for an Access/Jet PROCEDURE a.k.a Parameter Query (PARAMETERS declaration)? I created the proc/Query...

Hello. I need to create a querie that analise a a specific value and compare to some standards. Well, I was able to create this querie if the were no such...

I have a form which has on it the field for entering the barcode of a book, a field for the student ID and a date field for returning of book. When I put this...

I have two tables in Access 2007 which have a 1 to 1 relationship. When I try to run a simple query I get the following error message: "The wizard is unable...

These are probably simple and I appreciate the patience of everyone. Yes, I am trying the "search" with no success so far. I'll try to explain in more...

I've made a function that would calculate only business dates between current data and a date field (Nxt Cpn Dt). I've used the function dhCountWorkdaysA in...

Hello all. I am having a bit of trouble getting my query to work properly. I am trying to run a query (for my report) based on criteria entered on a form. I...

I have the following query; SELECT dbo_SYS_INFO.SYS_NME, dbo_SYS_INFO.SYS_URL, dbo_SYS_INFO.TEST_BEGIN_DATE,...

I have 3 tables I am trying to join in a query. They are as follows: tblProducts tblCustomerEquipment tblEmployees In SQL Server, this query would produce...

I would like to create a running average in a field that takes dated results (10 days from the current field date) and averages them for the current...