I have a linked Sql table in an Access database and I created a query on that table and assigned with a range on a date field as follows: =#1/1/2007# And...

I am using a Microsoft Access XP crosstab pivot query to get totals across several months. I would like to show the first twelve months and number of files...

How can I make Access recognize built in function? References are correct. The error message is Undifined reference 'replace' in expression. Problem seems to...

I am trying to insert a comma between and field if the field is not null - but I don't want the comma if the field is null RPTNAME: IIf(=" ",,IIf(" ",...

I am running an update query in Access that works for 3 out of 4 linked excell files. The fourth file seems to run fine, but then when I re-open it through...

Hello All, I've been waiting for a response to my query for over 30 mins... I'm attempting to run an append or make-table query for roughly 800,000 rows of...

I am trying to write a query that will prompt the user for a date then match the entered date to one of three dates in a table and then return the date and...

In the same query this works: q_103_G_RetPr_AnyYr: FormatCurrency((*),2,No,Yes,Yes) and this does not: ...

Hi I have an access query but get the error missing operator in query expression, Cast(string_column AS DateTime) Here is the sql I have SELECT column FROM...

I'm trying to run a query to search by information entered into a popup box which will in turn search by this and show the filtered data. Any ideas?

Hi, I have two tables; Collectors and Reassignments. I have a form that has a tick box relating to a field in the Reassignments table. It works perfectly...

I need help creating a query in MS Access 2007 that will take a determined value (FC) and run a query against it showing what percentile the value should...

I am using Access XP. I am working with a database with many file numbers. Each file number has multiple paid dates. How do I get the query to pull each...

Hi, I have a simple table in Access with four cols, as an output from my GIS: BUILDING_ID , ROAD_ID , ROUTE_ID , DISTANCE The table shows the distance of...

While designing an Access query, I know it's possible to prompt users for input which Access takes and matches up. However, is there a way to prompt the users...

I would like to know if there is an Access queries that allows me to take a table that has two columns and combined them into one. -- Gabriela

Hi there I am having a minor issue with my access. I am linked into our database through Access. All monetary columns have a 15.2 format which means access...

I wrote a query in sql...the sql is below....and then when I save, Access quits without an error message. I have done a compact/repair and also pasted the SQL...

Need a function that calculates the rank on a daily basis for the following data Data stored in table named "MR Daily Stats need to produce Date of...

Hi, I would like to retrieve data records from either table or query, and then do the calculation from them. Below is part of code to get the records, and I...