I am getting an aggregate message I am trying to pull the records of the latest retail price by the date. Not sure what I am doing wrong. SELECT item.item,...

I am wondering if it is possible to run a parameter query so that when the dialog box opens it will also have a dropdown list so the user can select the...

Hello, Got a bit of a problem. I've got two tables which hold results of tests (one current, one historic and yes it was too much to hope for that they'd...

Hello MS Online Community. I have created a very simply query on which one of my key forms is based. However, the WHERE segment of the SQL is not working. The...

I have a table that records all time off for my employees. To simplify entry, I used "begindate" and "enddate" for consecutive days. I have created a...

Can someone tell me when the Date() function works sometimes in Access going against an SQL database but at other times in an access database going against...

I am trying to get the average retail price in a query from a table that has the same item listed 3 or 4 times but sold to different customers. The end...

Can anyone tell me is it possible to display an image in a query, where the output of a field is true. An example would be, product is ready to ship and an...

I am not sure exactly what I need to do to get this delete query to work. I want to delete the records from tblCities that don't match tblCompanyAddresses....

Hi All, Problems with this selection criteria: IIf(!!=-1,"like *",!!) If it's not equal to -1 it works fine. But if it's not equal to -1, the "like *"...

Hi, Everyone I have already created a query for two table as below inv amount month 1 100 5/09 5 101 5/09 6 ...

additional information is, I am using access 2007 And I am trying to do a caculation on week discount rate Weekly discount rate=weekly rate*.15 but how do you...

If I have a hotel rate in colum c and in colum d I need the 15 percent rate of the amount in colum d how do you do that in access? The term I am using is...

Hi Guys - I hope someone can help. I have a database that hires out products, and need help to try and find which products are available for hire between...

I have a simple continuous form that's been working well for over a year, but will no longer permit the user to change data in any of the fields. When I open...

Ok this is what I'm trying to do: I have a database with about 30 tables (which are actually linked to Excel spredsheets). I need to be able to query each...

I am using FIX to match the functionality of rounddown() from excel, like so: FIX(*1000)/1000 if value is 1.2344 it returns 1.234 if value is 1.2349 it...

Can someone help me with this queries SQL? I have been beating my head on the desk for hours and can't figure out how to get the CPI: value to work...

I want a field to show $0.00 if it is not numeric. Is this possible? Thanks

I Have a whole bunch of data I need to get percentages for. Is there a way I can do this besides doing each cell one at a time?