i have a cross tab query which gives an output like below with following columns------- ozip dzip week no1 week no2 week no3 columns week no1 , week...

I have a field named CntItmPrgs_Interactions which contains Scorm training data. I need to be able to extract elements from the field. A sample of the data...

In which tables is the SKU the primary key? To completely eliminate the possibility that there could be a cartesian product, both the .SKU and .SKU fields...

Please forward a digital receipt re a puchase made today for home, office and student 2007

Hello, Here is my situation. I have table A that has the field ID as the first field. The field ID is the AutoNumber and it is a primary key. Table A also...

I am trying to use an Iif statement in a query, using a calculated field as one of the result paramets: Exp1: Iif(="9002,,0) is a field in the query being...

subs View profile More options Feb 7, 2:38 pm Newsgroups: microsoft.public.access.queries From: subs Date: Sun, 7 Feb 2010 11:38:53...

Dear all, I have two tables, POs and Orders. POs represent purchase orders from our client, and Orders represent internal orders. One PO can be related to...

Have 2 tables..one for Membership Data, one for Member Contributions. Have Member form with Contributions as subform. Have field in Member table to check...

I need to run a query that picks up a particular date no matter how it's formatted. For example if a date is 02/02/2010 or 2/2/2010 or 02/2/2010, ect, I need...

When capturing data from another database owned by another group, I need all of the data for 120 days from tableA and all of the data that matches by keyID...

I have a database that has an Access front-end and a MS SQL back-end. It has a report that is based on a query of the inventory table. The query...

Greetings, I am working on a membership database. I have a table with member names, a table with positions within the organization and a table of membership...

I have a Query I am trying to Build that has the Following data: Name WO Days Old AD K-12345 10 AD K-12346 23 AD K-12368 02 AD ...

I have a table which is based on a defect report for wagons. There are various text boxes to fill in, and also tick boxes. I have produced queries to which...

i have a query that takes about five minutes to run. i think that the delay is not justified: the table contains around 40000 records and the query is based...

Access 2007 - I'm trying to randomly select 2 claims per examiner. My first query successfully creates a RandomSeed field that contains a unique number for...

I have searched Access Monster and I have been unable to answer my question. I am trying to come up with a formula to put in my query that would...

Hi - hope someone can help. What I'm trying to do is to select service dates within a 53 week year - and the year doesn't always start on the 1st Jan. When I...