Search results

In my query I have sorted my list by "Tasks_Recieved.ID_Recieved DESC , Tasks_Recieved.ID DESC" When I open my query or my form sorting is ok but when I filter by any of the fields, sorting of the list changes, and it seems it will be sorted ascending by "Tasks_Recieved.ID"...

I have queries (query1,2) that there is calculated field in that. Now when I use left joint another table with this query (query2) for some rows that there is no match between them, result query (query3) shows #error in calculated fields please help how I can remove this #error and just shows...

thanks it does not return what i need, i like to have result like below. DocumentNo TITLE REV DATE TRANSMITTAL purpose DW-1013 TEST 2 1-Jan-12 TT-6031 afcit returns max value in purpose"ifr', but i need "afc" value in my row. best regards.

Excuse me I forget another column like below in my list that can not be grouped like doc,title and in each row has different value, I need it’s result but when I use max function for this field result is not ok and it returns value of another row in result list. Actually because of that I made...

Hello I like to make a query for extracting latest (max) rev of one list like below. But for catching this result I have made 3 queries that are related (one by one). So I have floated between queries with slow speed. LIST: DocumentNo title REV DATE TRANS DW-1013...

Hello In previous design of my db as I describe like below I was running 3 append queries regularly (by 1 macro) for inserting records in my tables after extracting data by queries (3 simplequery) from 1 base table that comes from imported excel file in my database. Now I have changed...

I have 3 tables. Table 1: Doc no (Primary Key) text (50) Title text (100) Originator text -------------------------------------------------...

Is it possible explaining more how I can do that? For example for my table that I defined like below Doc no (PK) Title Originator I want to add primary key (auto number) doc id: Doc id (pk) Docno Title Originator Best regards

actually i use template of task management.acct Microsoft acees 2007.and i like to customize that. Option Compare Database '------------------------------------------------------------ ' Search ' '------------------------------------------------------------ Function Search() On Error GoTo...

Actually my question is in 2 parts: If we have one table like below that we are sure 1 field of this table always is unique we have to select that as primary key or we have to add one auto number field for primary key? Table: Doc no (PK), Text type...

overdue parameter.but when i entered data "overdue" nothing happens (no filter).actually i do not know for calculated fields (unbound text box with control source) in the form filtering is possible or no? now i made query and used expression property of unbound text box in that (new field)...

In my form I have one unbound text box that it has 2 values (null or "overdue") according to its control source. Expression control source: IIf(Int([Due Date])<Int(Date()),"Overdue") Now when I want to filter my form (for example records are "overdue") with search box bottom at the...