I have a fixed length field file that I have imported into a table. I set the field types to TEXT. There are several fields that have negative and...

Hi, I run a report that lists the sales week to date, month to date and year to date by combining three separate queries. I am combining the three based on...

I am trying to run an entire set of queries but when I try to run them, I recieve a error message "Invalid Arguement". One of my fellow employees has also...

I have a linked table to a outlook inbox. I am trying to build query based on the information inside these emails. These are customer orders that have...

Hi ; I use the forms function to record information into a table . There is a primary key defined for one of the fields that allows me not to input duplicate...

I have a next CrosstabQ, for example to FEB2001. TRANSFORM Sum(Table1.Valor) AS SumOfValor SELECT Table1.Day FROM Table1 WHERE (((Table1.Day) Between...

I have a Table- TableInterviewStatus with a field- SuggestedDate For every record in the DB I need to change the SuggestedDate by adding say 7 days to the...

I want to make my database available over our network at work, but just a viewable version. How do I do that? Thank you.

Hi -I've got a macro that outputs query results as an excel sheet. I need to put a specific comment on the excel sheet headers -is this doable without human...

I just want to create a query that returns all records (from a single table)where a particular field contains more than 100 characters. Can someone please...

I am looking to has a Query field be a list of items, each starting on a new line.

I just want to write out a query that returns all records (from a single table)where a particular field contains more than 100 characters. Can someone please...

Hi - I need help on the following that i've been working on forever. I have 2 tables: Table 1: Contains fields 'Supplier', 'Item', 'Quoted?', 'units',...

I have a table to keep track of volunteers among others (a couple of relationships also). After each day I click a homemade menu to Update files and make...

ACES HIGH CASINO!!!!

Is it possible to use the Group By function to group results from a query on a Quarterly basis (Jan - Mar, etc)? I have sucessfully used the Group By function...

I am trying to perform a self join query to link. The manager's name is a number, and I need to make a query that shows the supervisor name. I have the basic...

Hello All and sorry for the multiple posting - I really need help with this problem and am stumped. This is my third database so am not a complete novice. I...

Does anyone know how to calculate a column by adding 3 years to the date? Once I can calculate this it may go into Queries or Tables. The first column is...

Can anyone help me please? I am working from a Table. First Column is the Training Date and the 2nd column is to be a calculation of the training date + 3...