I have two tables (Individuals and Census) - with a one to many relationship...One individual may have many census codes. Census codes define when an...

Hello guys. I'm trying to run a very simple query that shows all results from a table called EE_DR, where the Date field in this table is between two certain...

I have a report which produces an alphabetic directory of names. is there a simple way to insert a record along the lines of "Wife's last name, see other...

Thanks for the response. I have decided that the group of subs to each person is acceptable so a simple query will do. By thw I am dealing with 2000+ people...

I want to be able to select multiple postcodes for a selection criteria. These are British 'main' postcodes. eg: SW3, SW5, NW2, NW7, N1, N2 and so...

I want to clean emails before sending out. People have all kinds of typos in domain part of email. Like following example, all should be @yahoo.com What's...

How to use query to find email address field that contain more than 1 @ sign like one above? Thanks.

I am trying to put together the SQL statement to get me the time (in minutes)between the time entry for the current record and the time of the most recent...

I have a table that has fields that are quite normal except for one that contains differing values which are names of submarines that the person has served...

I am trying to convert some MS Access queries to .net. These queries call other queies, that call other queries, etc., sometimes up to five levels deep. I am...

I have a report that we need to run when we send a invoice. The report shows monthly total due plus late fee and then balance due plus things like gymnast...

I have a database where a date needs to be entered for records, ie DateReceived. If the date text box is blank; no date entered, I need to track that by...

Hello, I have 5 files in excel. These files will have the same fields, but the information will change in them every week. I am then going to import the the...

Hello, I'm using Access 2003 and have data that looks like...

I have a table which I input labor charges(laborID). I have a second table which I input parts charges(partsID). when I querry the 2 table to create my...

I find myself using workarounds for this way too often. A little advice would be appreciated. I have Three tables. I want to delete all entries from TableA...

Trying to do something similar to a VLOOKUP (Excel) in an Access 2003 query. I have the following tables: JOBS Job,Quantity A,96 B,256 C,300 D,4299

My outlook Calendar does not retain past appointments, etc. for more then a month . What am I doing wrong? I need to keep a record of the past appointments...

I have a query that uses a criteria of "269.9". I realized it was not working because the format of the field being queried was text. I successfully...

running access 2k adp/project as front-end; and sql-server 7 as back- end. I would like to create my own special function that I can then reference from a...