I want to write a query that will separate a whole name into last name first. Ex: Smith,John = Smith John How can I do this? Thanks

Hi all I have a field that sometime has for example Ray Morris or Bill Hughes (FR) I am trying to get returned the names Ray Morris and Bill Hughes in other...

Hi, I am building queries for duplicate payments reports. I have the query working but when I go to run it in the report I get an error message (error 3079) in...

I have a query (thanks to this group) which works like a charm. This query finds the last date for an event. I now want to produce a report which displays this...

Thinking up upgrading from Access XP to Access 2003. Is a change for the better or worse expected when it comes to query speed? Does file format matter, I'm...

Hello, I am very new to Access and database in general. I have a database that has 3 columns that are each peoples' names and every time someone submits a vot...

Hello - I have a table with Fname, Lname, HouseNum, AddressDir, AddressStreet, AddressCity and I need to get a list of Unique Addresses (in other words, just...

Hello, I have a database that keeps track of attendance to 8 meetings. At the end of the year, I have to reset the entire attendance record for incoming...

Hi, I want to add three table to one main table, BUT The problem is that each table has, got agents name with they results in. So I want the query to do is,...

I am using access 2003 I have two fields :- date died and where died I wish to create a new field which is text-based and uses the data from the two fields...

I have three tables: Table1 - All Product Day Product Component# Qty 1/1/04 A 7 100 1/2/04 C 2 20 1/3/04 C ...

One of the fields on a table contains text data, basically Yes or No How can I make a query and report to count how many Yes and No inputs I have ? Please, if...

SELECT DISTINCT LOCAL_Sales.SaleID, LOCAL_Sales.Date, LOCAL_Sales.CardRecordID, LOCAL_Sales.InvoiceStatusID FROM LOCAL_Sales UNION SELECT DISTINCT...

I have a query form that has three query criteria fields. The first field is a diagnoses, the second is the first unit and the third is the second unit. First...

Could somebody please tell me if it is possible to use a wild card in an Iif statement e.g. IiF(="*PE","Y","N") In other words i want it to find HZPE, AEPE,...

I have a recordset (containing ProductId) that is the result of a join (criteria selected from the user). I would like to apply an update query to this...

HI, Here are the examples, which each field/data have in all 3 tables: Name Total Hours Sales Completes Wait time

I have 2 tables. One "inventory" thhe fields are PartNumber, QTY, Descrp. the other table "orders" have the ability to order up to 6 Partnumbers for each...

Is there a Password nor schedule module or VBA script or template that I can download and use on my access database? Thanks for any inputs you may...

Hi, I have two fields on a form.......Suburb and City The suburb is a cboSuburb Query In the City field I have =DLookUp(" ","","! =" & "") ( After...