If I have a table with columns: Assignment - User names - then 65 different security columns. The Assignment could be Booking then a user name then a Y...

I am trying to use a field from the current record in a table as a where clause parameter in a Lookup query. I don't know how to reference the current record...

i have a field in a query consisting of both text and numbers. sample field data : "ps-re 38107" "ps-bmw 39155" "ar- 46505888" i want to manipulate the data...

friends, Q.1: I have table "HMADetail" That has fields as Date Lot# SubLot# HMAPlacedToDay HMAPlacedToDate ....... (1) (2) (3) ...

I can't figure out how to do this. I have an Access Database 03' that manages our Service Calls. I have over 5K customers in the database that were exported...

Hi. I cant get this to work. So I think I need some professional help here. :) SELECT .PL, .Article, .Size, DLookUp("",""," = " And " = ") AS EAN FROM...

Hello I am a newbie in Access 97. When I run the query : SELECT DISTINCTROW MAX (TbTrans1.Date) FROM TbTrans1 WHERE (((TbTrans1.Date) BETWEEN #01-jan-07# AND...

in design view have a DOB field (date of birth) need the query to find those 18 and older....thus the criteria would need to be a DOB that is: CurrentDate...

I have inherited a database that has rather a personal method of taking telephone numbers i.e. 12345c ext 1234, Mob12345, EX12345, 12345ex dir etc... I want...

I am having problems with 1 query. I keep getting a timeout error. I have changed the timeout value in the control panel on the data source, I have changed...

Hi all Is there any way that I can pass a variable (year) to a cross tab query. I know I can "hard code" it into the query itself as a selection but I want...

....though I'm not so sure myself! Hello, From the following list in a query product ALS ALS/24

Hi all, Irun a query to build a temporary table of staff who have completed a training course in the last 12 months. Some people have done this course twice...

I have a table than joins several other tables and it consists mostly of AutoNumber records. The query gets the results I want, but displays them as...

On building a query based on 10 subqueries, the time to run is pretty fast. On adding 5 more for a total of 15, it's about 20 seconds. If I add even one...

In a query, under field, I have the following: Month: Format$(,"mmmm yyyy") In this query I also have Analyst and Count: Analyst. This is an example of a...

I have a very complex matrix of 15 columns and 70 rows. The matirx has 49 potential results. Each of those results in one of 17 codes. I have 20000 lines of...

Hi there I would like to be able to filter words with a certain length and format and then delete the last 2 letter of that word using a query update. Any...

For financial and budgeting purposes, we want to allocate a total project value across the 4 quarters of the year based on the start and end date. I'm...

I have an access 2003 db and I wish to produce a report. The report is based on one record and its information. The information is contained in the 'main...