I have a simple table that has a date field and another odometer reading field. I need a query to calculate the milage difference between each of the dates. I...

Hi All, How do you update different values in different cells with differnt values?. Thank you in advance. Thank you John

I have a union query that gathers financial data from a current period and a prior period. The users uses a pick list to pick two dates. The union query...

I'm trying to update a query expression and not having much luck. The origional expression pulled a value from a Form and then based on that value summed the...

I have two tables that were originaly Excel tables and imported them into Access. Import went well. Both tables consist of columns named - Name, Department...

I am trying to build a query that sorts data ascending order by date, so that when I select "Last" in the Total row for other fields in the query I will get...

I have two tables, one table listing names of people who did not receive a gift card and a second table of people who were taxed for the gift cards. Both...

First of all by accident I also posted this in the General Questions section of the discussion board. So if it shows in both places my aplogies, I think it...

I have a crosstab query for a two year period. How can I get it to return a zero value if there is no incidents for that year. I want to ensure I have all...

I have, with the help of this newsgroup, created a union query. However I now need to add a parameter to have it only show me the data for a specific period...

I want to accomplish as simple task - adding comments in my sql so that it is documented. Nowhere can I find this in the MS documentation or via a web...

Hi, I have working crosstab query transform sum(PF) select from group by order by pivot in ('1','2'); I would like to save into temp table (like select...

I gave a table that contains 7 fields Doctor1, Doctor 2, thru Doctor7 I would like a query that will combine all the fields from the table and display it as...

Hi What is the correct syntax of an access insert query that also return the ID (via @@Identity) of the new record? Thanks Regards

Hi I need to run a query string while stripping all the spaces from one of the fields being returned by query. I need something like this; st = ""SELECT ID,...

I have a table that lists rows of effective dated codes against IDs as such: ID DATE CODE 1 2008 A 1 2007 B 2 2007 A 3 2007 C 4 2008 B 4 2008 A

Hello. I'm trying to figure out a query that will show me the top x% by group. I have a query that counts the number of occurrences of a given event,...

Using word 2003: I have on one laptop a 3 column index - surname, given name, page. I have on another laptop a similar 3 column index, with the same...

I have a database for our hospital diabetes center. We created a great set of forms etc... to stream line our paperwork, now we need to create some reports....

I am fairly new to access and have created a great database. However the queries are now becomming more complicated than I expected. I have two fields (Goal...