I am working on updates to a couple related databases (not linked by any tables) and have a question about virtues of Make Table vs Append queries. Make...

Hi all, Admittedly, I have not programmed anything in years and Access 2007 seems to have some differences, but I am embarrased to say I can figure out how to...

I am new to Access, and very little knowledge about SQL. I read allot about normalization, need to know if I went to far with it with my Family table. Here...

I have a table that records when a form is returned (by year, 2008/09, 2009/10, 2010/11), every company in the table is sent a form. When the business...

Hi. I have a form (parent table) with an unbound text box. When the user hits the "close" button, whatever is written in the text box is put into the...

Hi I have multiple queries based on queries - each builds (with various parameters from a form) up to the final query which I am using as the source for a...

If this is not the correct newsgroup please direct my to the right one. I'm extending a legacy application at my work and I've created a macro that perform a...

HI, I have a query that shows all the sales against all sales reps and another with all sales against a specified rep, what I need is sales against a...

I am trying to general a query where by their is ranking within groups like the table below: firm-id rank 1 1 1 2 2 3

Hi, I’m trying to get my column heading in my report to show the month from the parameter input. I’m not sure how to write this expression with the...

Hi everyone, I really need help please. I apologise in advance if my description is difficult to follow. I am very new to Access and have the following...

I'm using MS Access 2002. I want to design a query that forces a certain key table's number of rows to be repeated in each query result, even when some...

I have used union queries before but since I am not much of a SQL person I am having a little trouble with the following: I have a table called Jobs and I...

I'm concatenating fields of various data types that upon completion sometimes reaches around 500 characters. Not huge, but larger than the Text limitation...

When I look at SQL versions of code created in design view, I see many different ways of referencing fields in a table. Please explain the differences and...

Hi I have an existing Update query that I just copied and converted to a Select query. When I run it as an Update query, I get 4 records. However, when I run...

Hi, I have the following fields (Acorn Catergory, CL Code). I have a query that will group by Acorn Catergory then group by CL Code and then count by CL...

I used to update Excel spreadsheets from Access with update and append queries. Now that I am with Office 2007 it seems that this feature is not allowed...

I have a single table in my database containing school names, usernames, and password for user accounts. I am trying to find an easy way of exporting out...

I am looking to minimize network traffic with SQL 2008 backend. I have 22,000 clients in a table and want to select a small filtered list (less than 50). My...