Dates have been the hardest thing for me to pick up in Access. I don't know why I struggle with them so much but they confuse me. I have start dates,...

I need to split up an email address that is stored in a table. For example if the data is " I want my query field to display "msn.com". What...

My delete key is suddenly not working, is there any way to turn it back on?

Hi All, I need a query to extract only that records which have a word "Transfer" in remarks field. Plz help me, Hassan

I have a query as below and can't figure out what's wrong with it. It returns only a '-1' if the conditions are true irrespective or how many cases it's true...

Dear all, I have to run a query to generate the modified data like group a contains 30 perpon, group b contains 40 person, group c contains 20 person, group d...

i have a file which is export from UBS. i need to separate a field which is contain PO no n item. how i can make it to two field? eg in UBS: PO...

Hi all I originally posted this in the wrong NG..............DOH! Can anyone assist me with the following. I would like to insert this: SELECT...

Hi there, When I try and do this I get the phone numbers side by side and each customer next to each supplier. So its a complete mess. Is it possible to...

I need suggestion as to what to do with this error. Problem caused by Microsoft Access 2002: consider upgrading The problem was caused by Microsoft Access...

Hello All, I have a table which contains the orders from a customer. This table is filled out of an excel sheet which I import. The datastructure is as...

This expression in a query returns a date differance. If the dates in both values are the same it returns "0" which makes sense but is there a way to default...

I would like to either create a query from the following Union query or modiy the SQL to allow me to sum the all of the key counts. When i try to create a...

Hello Please Help, I have two tables table1, and table2. They both have patient information with patient_id as unique identifier. Table1 has 26609 patients...

I am trying to import a txt file into a DB and keep getting the following error message: Property not found. This file worked at one point, but no longer...

When I run in append query (which has worked in the past), Access now tells me all but 7 records violate some unforseen validation rule. All the records...

Hi. I need to merge several fields in a query and the fields that I have to merge must have a specific lengh even if data that is in the field has not that...

I have several phone numbers I would like to use as criteria in a phone number field. I have these numbers in another table. Is there an easy way of using...

I created a report based on a several combined queries. I made a number of changes throughout and now have it working 100%, but I have one small problem. ...

To append a single record, without getting a warning when a record already exists, I found out the following syntax works fine as Query in MS Access: first...