I have a query of Month to Date information for weeks 1-5. Unfortunantly they
are text fields- so I am unable to sum them together. Can anyone help me?
Maybe I need to find a way to change the data type to numeric?

I posted on 8/9 & again, want to thank Rick B.  The information helped, but I
am still struggling to get teh syntax right.  Through reading other posts I
have figured out a little SQL, but I'm obviously still lacking...this is the
query I have in place:

I have a query that will not open, I get a message saying 'Join expression
not supported'. Is there any way to get the SQL of the query without opening
it in the designer??? The query does run and execute ok. The SQL has an ANDed
condition in a LEFT join.

I have an existing form which contains various building sites with their own
site ref numbers and upgrade numbers. The buildings have maintenance work
carried out on them, with each work assigned a unique upgrade number so if a
site has had previous works, there will be multiple ...

Well, I tried linking the tables and it works provided I only reference one
table as a recordsource for the form. When I have multiple joins it gives me
the same message. Could you suggest what I could do?
Thanks

I need to find the records in one table that match the records in another
table. All the SIPID records in tblSIP that match the SIPID in tblBusiness.
How do I put this in an expression in a query?
Thanks

I'm in dire need of some assistance if someone can help me.  I'm trying to do
a "text" search for the first few letters of a username which will bring up a
listing of everything that begins with those letters.  
Here is my SQL code:

Is it possible to use an OR statement in an IIF? e.g.
Expr1: (IIf((Left([TRACKINGNUMBER],2))="88" OR "27" OR
"51","http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=" &
[TRACKINGNUMBER],"test"))

When openning a table or a query that has a memo field, the memo field
is not displayed in the output. However if a form or report is based on
the table or query the memo field is displayed. The database is a
replication database.

Trying to query on a subquery.
Text works fine but when I return to it, the query designer
tries replace the parentheses () with [] around the subquery and sticks a
'.' after the ']'.  A variant is it creates a bizarre alias e.g.

Can anyone help me with a date based query?
I have two tables:
PriceChange| PriceChangeID; Date; Amount; ProductID
Product| ProductID; ProductName

I have the following tables:
Choices:
ChoiceKey: autonumber
Category: Text

Hi, I have converted the backend to Sql. Now I am facing a problem. I have
created some Pass through queries and  I use them as the recordsource for the
forms. However I am not able to edit any forms as it gives me this message on
the status bar that the "Recordset is not ...

I am creating my first database, so I might be doing things
incorrectly/inefficiently here ... but this, in part, is what I've done.  
Pertinent to this question are three tables and a query.  I am working at a
goverment facility and am calculating salary expense data for a fiscal ...

I understand this error is due to having too many tables being accessed.  I
ran into it today trying to clean up some bad design - a major lookup table
storing the text value of a field rather than the ID.  I was burned when I
had to alter the name of one of the look up records ...