My ODBC sql code below is giving me the error: #933: SQL command not properly ended. Can anyone tell if I'm missing a comma or something that is holding this...

Hello there, I have a parent child relationship between tblProfile and tblAgreement. I have a form frmProfile that enables the user to make a profile...

To exclude names in a query do you use "name" And "name" in the ctiteria? -- Thomas

Hi Is it possible to make table from a crosstab query? Thanks Regards

My vendor requires that I report to them a 2-digit year for dates of birth & enrollment. What is the best method to write out only a 2-digit year?

Hi, I'm sure this is so simple I will feel stupid... I can not remember how to find records that have duplicate ID numbers. I was given a spread sheet with...

hi, I am trying to email a zipped file as an attachment. I know how to email an excel file as an attachment, but the attachment is too big. Does anyone...

Hi, I would like to create a query that updates a field only if the field is not null along with several other fields doing the same. I know how to do an...

I have SSNs (& zip codes) stored as text in my tables, but have a vendor that wants to see them as numeric! (they also want to drop any lead zeros!!) ...

I'm using Access 2003 and windows XP. I'm building an update query based on a select query to update information in one table with a new table. I have a...

The qry COADS contains only 86 records, one for each county. The qryScanLog contains 88 records, one for each county. I have tried all possible joins and I...

I have a table with one of the fields is a look up field with multiple values. After that I made a query with all the field from that table. If I run it from...

Hi, Thanks in advance for tyring to help me. Maybe I could have been more clear about what I am trying to do, but I have posted before without a...

I have a union query that is quite simple: SELECT DetailCust.OrderNumber, Mid(DetailCust.ProductCode,3,2)+MID(DetailCust.ProductCode,7,2) AS...

Happy Holidays everyone. I have a task to create a report from a data set. I think the quickest way is to query the data. fields: Date, Region (ie BC, AB,...

I could use some help. I have a table with customer info and a table with contracts. They are linked by an ID field. I would like to create a query that...

I've been trying to get the below query to work. It only pulls a couple of dates. Any suggestions on how to fix it? IIf(( = ), IIf(( = ), IIf(( = ), IIf((...

ACCESS DB for tech inventory purposes. I'm updating some information directly in a query datasheet view. While trying to change a room number where a...

Hi, This should be simple, but I am still pretty new at this. I have a main table in which each record has a unique identifier (Policy No.) and each record...

Hi Thanks for reading my question. I have a delete query that works fine. However, I want to circumvent the Access warning messages so that I can add my own...