how do I extract part of a field after the "/" character in a query?

I've got a query set up that will return all the entries relating to a particular Name. The names are stored in the "Name" field. In the Query, I simply used...

I'm not even sure how to phrase this for a search to see if it has been answered before. I have a query that identifies results in a table with two pertinent...

Hello i am creating a query that i need to ask the user for a start date and a end date, how do i create a form with a calendar control that passes the...

hi is there any way to pull up date of monday and wednesday of every week. for example; 06/03/2006 is monday 08/06/2006 is wednesday and so on. i want these...

I have a couple of fields QtyYear & QtyAmount. QtyYear contains the year (2002, 2003 etc) for the given amount (QtyAmount). However, if there was no amount for...

I am having a problem with a query that is using a form to get its criteria. there are several comboboxes on the form and i want to be able to leave them...

Attachments: IIf(.=True,"Y","N") It works fine in the select query but when I change to my update query it say it is not a valid name and to make sure it...

OK first the question: why are the NULLs screwing up my query results? The problem: I am constructing a series of append queries to dissect non-normal data...

Have been trying to find what characters mean in a 'like' query. See that means numeric characters 0 thru 9. So what does *, # ... mean. I have been unable to...

I have been asigned the task of figuring out how to use access. I have what i think is successfully having a linked table to a master excell spread sheet. ...

How to? At the moment I have 6 linked tables that have data I need to search & extract from. To do the searching I have 6 'types' of queries & forms to each...

I have a query that pulls records with various status dates. Some have dates in a Complete field, some have dates in a Referred field, some have dates in a...

Hi Folks, I have a table of starttime and endtime (with calculated daily total) and I would like to count how many people were at work before 8:30 am, how...

Hi I need to print "blank" invoices with invoice numbers only at the top. I have a table full of invoice numbers which I am using as the record source for the...

In my application I have a form with a combo box. What I want to do is select an item from the combo box and have that item removed without deleting it from...

I want to sort by the "C04" part of the records. The data connected to the Datestamp and DateScanned can be a string of entries or just one, with the "C*"...

I have a table with birthdate of persons I would like to write a query giving me all anniveraries coming up within one month from now. Can someone help me with...

I have four tables of different "entities". One table contains information for "people", one for "trusts", one for "companies" and one for "self managed super...

Hi All, Satellite Collars (Named PTT on the table) on Caribou acquire a position "fix" everyday at a certain time. It records the Postion with a...