Hello all I have been searching in different groups to find an answer for these but no luck. I have a table that has invoice_num, total (amount), invoice...

How do I get the grouping to give me 0 - 30, 31 - 60, 61 - 90, 90 I have done the grouping and come up with 0 - 30, 30 - 60, 60 - 90, 90 I have used interval...

I am trying to build an expression but am having some difficulties. I have a field in the query that has percent values. I want to build an expression that...

Hi I have automated the exporting of Access 97 tables to CSV files. The prob is there is an address field, where some of the data is input as eg: Flat 3,...

I currently have two queries that I am trying to combine the results without duplication. This is in order to populate a form with those that will...

I have a Query that gives me the output as...

I have a yes/no field and would like to enable reports including records with "Yes" or "No" or both. I have a form that opens when the report is opened and...

Hi all, Probably one of the many having fun with Dlookup! Wonder if anyone can help. Trying to produce some data on whether certain members of staff have...

I have a query that sorts records by month, zone, and shift. I would like to add another sort criteria to list only the odd numbered records, or even...

I have a ‘make table’ query that creates a ‘top 10’ record list on a form. How can I allow the user to ‘requery’ the underlying query from within...

Hi. In a querie I have a column that is a diference between two other columns. The result have a lot of decimal places. If I make a fix, it transforms in a...

I have two fields in the following format: 2006-06-07 00:00:00.000. I would like to convert to a date field, preferably mm/dd/yyyy format, so that I can...

I have a table I wnat to insure has consistant data in the "Activity" field, based on data in the "Code" field. I am using an update query, but I have 75...

I am trying to get the sum of a text field, and only want data where the sum is not equal to zero, but I keep getting an error message saying that "the...

I won't describe the database I'm working with, because I can abstract the question like this: Assume you have 2 tables that have these fields: etc

I have a query in which i have multiple parameters being asked for for the user. I am using the wildcard and the or statement so that if the user just hits...

I have 2 tables linked to access from our SQL server via ODBC link Both tables have a field called "Prod" which contains our product codes. SQL has both...

Hi I want to set criteria in a query so that it only shows records the match befor the month of september 2006 Thanks

I need a Query to show me the last date for receipts on one table from companies listed on another table. They are linked by a relationship. Access 2000....

Hi friends, i am having a table with more than 5000 records, i want to delete first 1000 records. anybody know what is the query for this in ms...