Can someone give me a simple expression to print the weekend date in a report based on the date of the information entered in the details. I will have daily...

I am looking to create unique records and combine donation totals which look like this: Donor ID Donation Participant Donor 1234 $50 Ray...

Hello, I've read other posts, but can't quite get my query to do show what I want. Perhaps I'm still trying to get my brain around the idea. I have a query...

WWW.SWEETSAUCE.BIZ More Software, Better Savings

My Brain is fried and I lost my book... I have data from an outside source that is not really user friendly, but now I have a way to update several tables...

I have a square matrix of values that I'd like to re-format into a few columns in order to better manipulate them. I was wondering if anyone could help me...

Hello. I have a crosstab query with parameter, when I run the query, the pop up window by the access (not the parameter form I created),...

If I say 'SELECT TOP 5' and the result set returns less than 5 rows, do I get an error? I looked in Access SQL help and it did not say.

i have a number field like the following: 125645 1236544 54623211 125487 i want the field to be 10 positions with zeros in front how do i make this field...

I have a table with 2 fields (Department_Name, and the responsibilities for each department): Department_Name Responsibilities Dept1 ...

UNION SELECT 19 as MyID, ActivityDate as , tblEmployee.first_name + " " + tblEmployee.Last_Name as EDA, (Select count(*) from...

I'm trying to figure out a way to this without adding 7 queires to my macro.. I have a data set that has a column for Date and Time.. Below is an...

I have a table with 2 fields (Department_Name, and the responsibilities for each department): Department_Name Responsibilities Dept1 ...

I have a table with 2 fields (Department_Name, and the responsibilities for each department): Department_Name Responsibilities Dept1 ...

Hi to all, I am gettin the folowing error "operation must use an updatable query" with the following : UPDATE BudgetHST SET BudgetHST.Avril = (SELECT Avril...

I have a table that has 2 fields with the following data field1 field2 department1 a, b, c department2 d, e, f I would...

My boss has asked me to make him a complicated report. I use Crystal Reports most of the time but for this report I need to make some queries in...

I have a form bound to a table. I want to use the form to enter new records in the table. There are 3 fields in each record that are limited selections - the...

Hello, Can somebody help me with a problem I have? I am importing a text file into a data base and the data in the file is simular to this. ...

I'm running a query that joins two sub-queries. It doesn't work when I use an inner join, but works when I use a left join. The SQL is: SELECT .* FROM ...