Not sure where to ask this... From Access XP 2002 - upgrade to Office 2007.... 1) How many of my macros and modules will not work? 2) If I pass an Access...

Hello, I have a query that returns a list of records based on a date Criteria like !! Depending on the date selected the query may return a different number...

Morning, We have an Access 2007 tool. End users work with static data from one of the tables within that database. Each night, a macro runs a truncate query,...

I am new to Access 2007. In previous versions of Access, I was able to run an update query to place carriage returns in place of square box characters that...

Long time Access user.... new to Access 2007. I literally work in Access all day every. I can't find a feature that was most helpful to me in previous...

I want to set up a criteria for the Date Serial where I want to be able to run a report that will allow me to enter a date and then be able to tell me what...

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 ...

Greetings! I have a table of 17K records and need to export all the records in increments of 5K. How can I tell my query to only display 1-5000, or...

I have a query that pulls information from a Contributor table and a linked query (queries for ID, date and amount of contribution). This query asks for...

I have a query set up to identify the last date of attendance for individuals. For some reason, it is not recognising any entries after 09/09/09 and before...

I have a table with 36 rows containing the field, FiscalYear, values, 1,2 or 3, and EndDate, containing month end values for 3 calendar years, for example,...

Just upgraded to Office 2007. Previous versions automatically sorted queries by name. 2007 groups by query type, then sorts by name. Is there any way to...

Hello .. I am trying to create a query to update a field with a sequential number (not starting at 1) on certain conditions, by adding 1 to a value in a...

I am testing Access 2007 on my computer before we change the rest of our office. I have a situation that we build timesheets based on data filled out in a...

I ran into something strange while doing a Make Table Query that was followed by an Append Query (from a “purchased system� table that has many field...

i have 2 fields in a table, 'qty on order' and 'qty rxd', In a query I subtract 'qty rxd' from 'qty on order' how can i store the result of this calculation,...

What is the maximum number of records that Access 2007 can handle? My friend wishes to set up a disco database containing all his tracks - and he has over...

The database is split. There is a subform within a form. One person wants to use the form in datasheet view and change the subform. However, Access 2007...

Greetings, This has been an odd issue for this query with the given criteria in the WHERE statement: SELECT Parameters.ShortName, Parameters.LongName,...

We recently upgraded to Office 2007, and since doing so have found our crosstab queries to take a very long time to save. They run just as quickly as ever,...