Duane, First of all, thanks for directing me to your module, works like a charm... Here's my problem.. I have to run a query (qryItemNumbers) to sort out...

how do i have query data sheet view column order be the same as query design view column order? by default it seems to be that way BUT if I save any LAYOUT...

I have a basic database containing student records. I would like to be able to query incomplete phone numbers. Is there a simple way to do this? By the way,...

Hi, I have two queries that list and calculate time for a subform. Listed below is the SQL view of each: First query: SELECT tWorkLog.JobNumber,...

TRANSFORM Count(.ID) AS CountOfID SELECT .Area, Count(.ID) AS FROM GROUP BY .Area PIVOT Format(,"mmm")...

I have a problem with my IFF statement, it’s creating duplicates, this is the statement:- Pension: IIf("PEN"=();"Pension";"Non Pen"). It seems like it shows...

I have created the deleted query that will delete all records soon I hit run. However, I wanted to delete about 50 records, not all. Would you please tell...

Hello all I have created a make-table query that works just fine. My problem is I do not want to see the pop-up message asking: "The existing table 'name of...

I have this SQL SELECT peter.client_id, Left(IIf(Len()9,Left(,Len()-InStr(StrReverse()," ")),),IIf(InStr(," ")0,InStr(," "),Len())) AS title1,...

I have a table of active lease records. This table has fields such as lease number, expiration date for the lease, and month it was appended to the table. ...

In my db I have a table which has week-ending dates (Friday) for every week next year. I am using a query based on this list in a combo box on a form. To...

When joining SELECTs with SELECT name FROM table1 UNION ALL SELECT name FROM table2 UNION ALL SELECT name FROM table3 kan I sort the individuel SELECTs...

Hi NG, I'm trying to make sense of some data I have imported to Access from various sources. I have one table with two fields; A and B. Field A contain...

Hello again: I have a query based on a single table. The query has a date field which receives parameters from a form (Between and ) and multiple calculated...

I have a table called tblProducts, withing that table I have a field called itemcode which is the primary key. The user enters the itemcode for every...

I see many types of posts regarding the problem of averaging null values. I have made it work for my queries, except it won't work when all the values are...

Hi, I have just started some work on access and currently i am stuck on 1 query. I have a list of accounts alongwith project start date in below format: Sr....

Hi folks, Please help, running out of time! I am so close, (yet so far away). My goal is to end up with a query of all fields of the records with the...

Hi I am trying to use an update query to copy data from one column in a table to another column in a different table. Both fields are called DESCRIPTION in...