I have field in a database that contains a date for a DUI conviction - i need a criteria that compares that date and todays date and sees if it is more than 15...

I'm working with an Access database and one of the fields contain codes like this: A03AA01 A03AB01 and so on I would like to make a query where I select...

Hi, I have the following SQL statement which I use for calculation some figures: SELECT , .Product, .Year, .Month, .Value,DSum("Value","TBL 1",. &" =") AS...

Hi, I am appending data from an Excel spreadsheet to an Access table. The problem is: A field (called Lender) in the spreadsheet is formatted as Text which...

Hello. When i use the following string in a "DoCmd.OpenReport stDocName, acViewPreview, , strWhere", it gives me the report i want: " = "A V H INTERIORS 4061"...

I am trying to produce a query so simple, I'm almost embarrassed to ask this question! I have two tables: (i) Projects, which lists a number of projects for...

I'm trying to write a query something like this: "Sum(Pcs)as Pcs1 where Date =, Sum(Pcs)as Pcs2 where Date=-1" so that both Sums appear in One result...

Hi, I tried many unmatch query but not have result. Please help. I have 2 tables: Score1 and Score2, 2 table have identical structure. Score1: ScoreID, Name,...

I am trying to create a query but can't get the criteria set up correctly... I'd like to run a query for our patients who have been charged code (X or Y) AND...

I would like to know if it is possible to "explode" a table via a query; here is a small example Table fields ID number Type text (E or M) Source_Ref...

Hello All, I am parsing a text field from a table ( ex Data: A/ASEL) I reviewed the MVPS.org/Access webpage to get a start. Here is the function the parsed...

Hi All, I have a date conversion problem. 1. I've calculated the difference between dates from field#1 and field#2 2. I want to add 90 days to the...

I have designed the tables for the information that I need several times, trying to find the right way to set up the data so I can get a Querie to do what I...

Hello, Im trying to get the prevous YTD to work. The current year to date works fine. Projects: Sum(IIf( Between !. And !.,1,0)) Here's the expression for the...

After docmd.openQuery opens a select query, what is the syntax to close it? Actually I don't need to see the result of it. Is there a way to make it...

I would like to be able to set a Column in one of my queries that will give me the abs(max() of a series of columns within the query .. I am having trouble.. I...

Hey guys, maybe it is a silly question, but I don't know that much of ACCESS... How can I append data to a Table checking if the new data is already in...

I am running a query in Acess that produces a null field for a few of the results (this is intentional.) How do I run another query to change the null field...

I've already spent a good 3 hours or more reading posts and help topics and trying everything I can think of to solve this. What I am trying to accomplish is...

Hi, help on this would be much appreciated.... I have a database very similar to the northwind example i.e. supplier, product, customer, order etc.... I have...