Have 12 months of data,
most with nine groups.
Need to divide the sum of
all groups $ by

I am a beginning-to-intermediate user of Access, I recently ran this query
(QBE), but I often wonder if there was a better way of approaching this…maybe
through SQL?  I mainly use the QBE, but I often wonder if I am limiting
myself.  First of all, the data I am working with has ...

Is there a way to maximize a form to cover up the taskbar?  I would like a
from to be something like a lock on the PC if possible.

When I view the datasheet view of my make table query, the data is calculated
as expected.  However, when I run the make table query and open the table
created, I receive zero values for the expressions (the summed values are ok).
Please advise!

I know this has been asked before but I couldn't find a question that matched
mine.  Here's the process, I download an Excel sheet that I then import to
Access as a table.  I then need to append the Excel information (T1) to
another table (T2).  T1 contains past records as well ...

In a Crosstab Query, we can sum up numbers.
But, if all data is text, can we merge the text into one value in a Crosstab
Query?
Thanks.

I am trying to write a criteria for a query that changes based on whether a
checkbox on the form is checked.  If the checkbox is empty it should return
only records where the criteria matches a text box on the form.  If the
checkbox is marked, it should return records less than ...

Can anyone tell me how to find records in a table that has no related
records in two other tables?
I want to find the records that I can delete without having to just try
record after record.

I need help with a query.  One field is "Code", the other field is "Account".
What I want to do is enter the criteria [Enter Code: ], then write an IIF
statement ; if the [Enter code:] is in the database then count them, but if
the Code has a duplicate "Account" then count it as ...

My query results do not return the records when there is an empty or null
value in any one field.  Below is the my query. How would I modify this allow
the empty or null values. Thanks for yoru help.
strSQL = "SELECT * "

I have one table in my database named, Clients.  It has the following
fields: FirstName, Surname, Address1, Address2, Address3, DOB, and
LetterSent.
My question is, how do I show all the clients who have a birthday coming up

How can I delete this " from a feild.
eg:
"khkhkhkh"
kk"khkhk"

I'm trying to understand this Select statement.
SELECT tTech.Name, Sum(tTickets.[Time to Fix]) AS Total, Min(tTickets.Date)
AS [Start Date], Max(tTickets.Date) AS [End Date]
FROM tTech INNER JOIN (tDivisions INNER JOIN tTickets ON

I have 2 questions.
(1) table1 and table2 has same data structure.
I like to delete duplicate records in table1 and table2.
i.e. table1 and table2 will not have same records. table1 will be the main

A union query I developed has suddenly stopped working.  The syntax
is:
SELECT * FROM [myQuery - Part 1] UNION SELECT * FROM [myQuery - Part
2];