How do i pass a global variable (as criteria) to a Query design/SQL?
The variable f$ will contain an sql where statement e.g. "[Enquired] Is Not
Null AND [Letter Sent] Is Null"
Works fine if i just copy/paste into the SQL statement, or criteria line in

I have set up a query linked to a number of tables. The query has fields
which are the links to the other tables. In some records, not all, i want
somes field to be blank so have used the IsNull function to allow this, but
when i have done this it seems to lock the query and i am ...

Hi there, I've got another tricky problem.
I have a table with 5 columns. Columns are called 1, 2, 3, 4, 5.
One case:
Columns 1 and 3 have numbers in them. Columns 2, 4 and 5 do not any

I setup an Update Query and I would like to Build and Expression to
Delete a row if the Field Value is Null or "0"
What would the Expression look like?
Thanks

certain Is there a query that will search for a number of leading blanks? I
have a text file (notepad) of music listings that has the band name (with 6
leading spaces) and the next line is the album name (with 9 leading spaces).
After that, there could be another album name or ...

A field in my Table contains Dollar Amounts that are off; instead of
12.44, it's 1244
Therefore I would like to divide this field by 100
I want to permanently modify the Table, no create a separate Table

Column 1 contains routing numbers (ie-RA12345). I need Column 2 to contain
the 3rd and 4th digit from column 1.
ex-       Col1            Col2
       RA12345           12

I have 2 tables; subnetallocation (SNA, for short) and  routers. each record
in routers will store a reference to a subnetidx. After a subnet gets
allocated and when i next go to routers form to allocate another, i want my
combo box to only show records from SNA that have NOT ...

I'm using a value from an unbound Form Combo Box to limit my Query.
I'm using this expression to limit by City
Like "*" & [Forms]![frm_Search]![cmb_CITY ]& "*"
My Table contains many rows with Null Values for this Field

I've posted several times and gotten some assistance with refreneces to
links, but I can't seem to get the supplied help to make my situation work...!
I'm getting very frustrated and cannnot seem to figure this out...I know
there must be a solution!

Oh my...I'm having a very difficult time trying to do this...and I at this
point could certainly use a bit of a step-by-step approach.  I'm trying to
get all the columns in a combo box in a query to make a report from.
My combo box has an account number then an account description ...

Is there an Access function (or combination of functions) that can remove
leading zeroes from a text string?  

I have a form that shows SSN, but I want to limit what the cell shows to just
the last four.  Any ideas?

I am using access 2000. I have an update query defined with one parameter
(defined as memo data type). The field in the table to be updated is also
memo type. However, when I run the query, the data is always truncated.
When I view the SQL, even though the parameter is defined as ...

Variable dtCurrent holds the curent date which is set up as a parameter in
query MainQueryWithParm.
Set rst = db.OpenRecordset("MainQueryWithParm", dtCurrent,dbOpenDynaset)
Is it not possible to pass a parameter in this way ?