I am using access 2007 and have a huge database will lots of queries. I tried to use the new feature in 2007 that allows you to group database objects in...

Good day, I am not sure how to do this but here is what I would like to do based on a query. I have a table with the following information and field...

I am looking at Allen Browne's audit log at: http://allenbrowne.com/AppAudit.html and wanted some advice to ensure this is the right way for me to go to...

I deleted a couple rows when compiling my database. Now it goes from ID number 1 to 6. How can I fix it and make it number 2 and go from there?

How do i create a query that grabs only records where the Offering_ID field ends with 05 or 06, or 07, or better yet, how to i make it so that it prompts...

I am creating a database to retrieve performance information at different levels. The lowest level is an individual area, then going to a group area, then...

Afternoon all, Is there a function in Access that does the equivalent of an indirect function in Excel? I have created a query and want one of the fields ...

Sorry...this is a cross-post (is also in "General questions", but NO replies yet...if this is doable). I'm uUsing automation to Excel. Can I get the Column...

I never would have made it as far as I have without answers that I've found in this discussion group, so I will thank you in advance for helping me with my...

Hi everyone. I'm trying to do what I think is probably not too complex but I cannot wrap my brain around the logic behind it. In one table, I have Month...

I have two table with identical information (fields), but one of them is updated and the other is the one i need to update. I'm doing this in Visual basic 6...

Currently I export a customer list into Excel along with their YTD or trailing twelve month sales totals. The sales are summed to find the total sales of the...

I'm having trouble trying to delete duplicate records in a same table. What I've got, is one table, that has around 12,000 records. What it should have,...

Assuming: SummaryTable contains summary info in which the value of several items have been added together for each transaction. DetailTable contains detailed...

I have a table with 2 rows: Row A, Row B. There are many rows which are identical. how can I take these identical rows and make them unique?

Hi, I use access for millions of rows of data and I'm trying to set up a form with multiple option groups. I think I'm understanding that pretty well however...

I would like to get a result showing the number of journeys involving 3 particlar locations with any other place lumped in to a single column...

Hi, I have a make table query using groups & totals, one of my fields is set to show the average. I want to show the average value as a whole number, no...

I have a form called that stores the vehicle fleet number, registration number, vehicle type etc etc, that has a sub form called on it that takes its data...

I've a form with 'Unbound' text boxes with 'Format' & 'Input Mask' defined as 'Short Date' i.e. dd/mm/yyyy. Similarly, in the table, the date fields are...