I have a table with date fields and . I would like for the query to show me only the calls that have no date (are null) or if the date is greater than one...

Hi Folks - We track services to people. The services have number codes like 12, 13, 14, etc. I have a table of data that lists the client and their service...

Hello, In a field of a table there are entries with address and city in the same record. For example: High street 55 Paris. I only want the address in that...

I have a field in which some of the data that looks like this: ??/11/2009 I need to find all instances where this occurs. I tried using '*??* as my...

Hello All I'm obviously having a bad day query-wise, as this is the 2nd problem I've needed help on! What's wrong with this: SELECT practices., practices.,...

I am trying to put a Date Parameter in a Cross Tab Query. When I use the initial queries (which the cross tabs is based off of) the wording below in the...

I've created a random record query that works. It pulls 50% of records for a particular timeframe. The problem is that I don't want random records, I actually...

I need to set a sale price for a product based on the number sold. For example, first 200 will be at 100 each, and 201 to 400 will be at 90 and so on. Is...

I am working with a part number that is 10-11 alpha numeric characters. I need to focus on the 8th character which represents the color of the item and make...

I've created a random record query that works. It pulls 50% of records for a particular timeframe. The problem is that I don't want random records, I actually...

Running Access 2003 on Vista. I have a query that chooses 15 records at random. This works fine. What I want to do is run the same query for approx 110...

I would like to create a query that has a running total to 8 items and places this total in a field. Then use this as the basis of a report to show the first...

Hi Guys, I am converting a access application over to a SQL BE setup and am having to convert a number of update queries, I previously had a query to update...

Access 2007 I have a flight column and a date column. There are specific flights for specific dates I want to see data for. The query is returning the right...

Access 2007 Among other items in my table, I have a flight column and a date column. There are specific flights for specific dates for which I'd like to see...

Ok, i am at a loss. i am doing a dcount that was working and now it isn't. the only thing i can think of is that now not all of the criteria are...

I have two combo boxes. Location and Super1 The location box lets you select a location where a staff member is working at.For example U3 B-days. The Super1...

Hello everyone, The contents of all example tables in this message are shown by way of csv-file notation so that the data can easily be imported into a...

Hi, I'm trying to create a engineering database whereby there will be hyperlinks to engineering documents. I'm trying to create a query whereby I can search...

I have DSN Less connection code as follows for linked tables which the code is on the switchboard form: Private Sub Form_Open(Cancel As Integer) ' Minimize...