I need assistance in creating the formula to select one week ago Wednesday through Thursday of the current week. This query needs the ability to be run on...

Hi all, tia for any insight. I have the following query that gives some totals for qty's in a releases table, pulling and grouping information (part number,...

Hi, New to Access and have inherited a database at work, I need to create some crosstab queries and am unsure if I would be better off creating a new table...

Apologies for repeating what has probably been asked before although my newsreader can't find anything! I'd appreciate any advice on Access books and...

Hi, I have some 20,000 entires populating a text filed that ideally should be a combo box. I'm looking for the best way forwards with this and wonder if...

Hi everyone, I have a table with the following data upon which I would like to report: SomeDt SomeValue 1-sep-09 100 12-dec-09 ...

I am trying to create a query to give me the results from the first weds of each month back to the following day after weds. Having trouble formatting the...

I have two tables that I'm creating a query with. Table 1 has Agent field and Table 2 has product field. I'm linking the tables by a primary key. Table 1...

Hi everyone, I would like to create cumulative totals per month to create a chart. I have got this far: SELECT Data.Region, Data., Count(Data.) AS FROM...

The default number of columns on my Access database is 24. Can this be expanded to 40? Thanks

I am trying to run a scheduled task to run a macro with updates, but have to enter my Password as soon as Access opens, is there a way around this so it can...

I have a small table of data: Start End Appointment...

I can't seem to figure out why this query will not return any data. SELECT AsiaContracts.AsiaContractShipper,...

I have a table the has information about grant applications. I have another table that has the names and addresses of the schools related to the applications....

I have a lot of weather data for one month that is broken down by the minute. My end goal is to take the average hourly value of the column values (temp,...

I have 4 columns/fields of dates in a table: Field A, Field B, Field C & Field D. These fields can be either filled with a date or left blank. ABCD are all...

Hi, I have a table with new records added, that is some information has been pre-filled. Say I have 3 new records with the same reference code ZZZZZZ - they...

I am a beginer of Access. I have a database that consists of 4 columns/fields of dates. These dates/fields can be filled or can be blank. I call them A,...

My mdb file is moving tables from mdb backend to ODBC link to SQL server tables, but queries are in the front end. Should I change the queries to stored...

I have three (3) columns in a table which represent the month, day, and year. The values in these columns are 04 (month) 21 (day) 2010 (year). I want to...