I have the following code: Dim db As DAO.Database strSQL = "INSERT INTO tblRentaldetails ( Rentalid, Itemid ) " strSQL = strSQL & "SELECT '177' As Expr1,...

I have a query that Pulls 5 separate tables together. Table A has the major portion of data, and the Primary Key = to all the other Primary Keys. I bring 2...

Any idea how I could make the following query work in Access? Any help would be greatly appreciated. SELECT orders.ouser, products.cname,...

Dear Forum, I hope you could help me with my new MS access 2000 challange. I would like to calaculate in a query the different between 2 dates. Output should...

If an incident occurred on a given date and the report is due 15 business day I need a query to return the date on which the report is due

"Access error message "The object doesn't contain the automation object 'expr.'."

Hi, I have a time field in myTable of type text that has the date and time of day for each record. e.g. 3/03/2008 4:10:11 PM. I want to be able to Group...

Hi, I have a query that looks up about 10 fields from a child table and then 7 fields from 7 related parent tables. I have a subform based on this query...

I’m working with calculated fields that have percentages, but the data entry is like 43.5% my problem is that in order to multiply and get related percentage...

Any suggestions on how to accomplish a few simple formulas would be helpful. The information I have is 52 weeks worth of orders by item, by customer. I am...

I am using a query to pull up all my account service records via a form and subform - Main form is from account table, subform is the query of service...

I'm working with a datasource to obtain license information that's structed like...

I'm working on a query that bouncing dates against one another. I think it needs nested IIf statements, but my brain just can't seem to put it all together....

I would like to have MSACCESS enumerate dates between a start date and an end date. I have not worked with VBA code, can this be done via queries?

I'm so new to Access that I don't know how to purpose the question but here goes.1 - To obtain the number of new members since April 2008, would that be...

Hey there, I'm trying to create two queries which will ultimately be used to create reports based on them. In both queries I want to work with date fields...

I currently have a crosstab query that I used to count the number of each type of employee compliant and summarize by quarter. For example: ...

I am trying to build a query that shows expiry dates due in certain ranges i.e. 60 days, 30 days, etc. I've tried the DateAdd and the DateDiff function and...

I'm tring to creat a fiel that have the month and the year of the data. But turn out that is quite dificulte to do so. I excel I do that all the time to sort...

Hi, I have a days table where each calander day is represented from 1 - 7 (where 1=sun, 2=mon, 3=tues, 4=wed, 5=thu, 6=fri, 7=sat) I need to do the following...