I am hoping someone can help me with this. My database contains events/courses with a start date and an end date, the start date could be say 1/9/12 (UK...

Hey, I have had to set up several rather complex queries using nested queries. I am required to enter an initial date, and would like to be able to use that...

I have a database which contains an events table, fields a Event Title, End date, Start date, Start time, End time, Frequency (this is a combo for weekly,...

I have a query where I would like a date entered by the user to be used in a formula for each record. The user is prompted to enter a date, and then that date...

I tried to add another table to my query with a Left join and I receive a message that my SQL contains ambiguous joins. It went on to say that I needed to...

I am trying to do a like criteria with 2 wildcards using a text box as the parameter. The original data comes from our ERP system that I ODBC to. Everything...

if (Escalation/Assignment = 0) or (Updateheat = 0 )or (Worklog = 0), then 0 for the total. Else total. How would you set this up in design query? Each of...

What I want to do, hopefully, will be simple enough. I want to have a search form that has two fields, one a combo box and the other an unbound field. I want...

I am looking at a field from a query that is in design view. Inside the field are two field names from the same table which are separated by a colon. For...

Hi, I am getting duplicate results when I run a query. Here are the details. Bothe tables have the same data only dates have changed. what I am trying to do is...

I am having a problem figuring the right way to pull specific data from within the text of the table's field and separating it into a unique...

I have a table (tblTerms) with 2 fields & . The typical terms in the table would be 2%10 Net 30 with having a value of 30. I then take the difference...

Hi all, Kindly solve my problem. I have 2 tables stock_received , stock_utilized. stock_received fields -- date,3pcs,4pcs,boxes. stock_utilized fields -- ...

I have a simple query that pulls data from a single table containing some basic client information. One field is a text field containing alpha-numeric data. ...

I have to loop through the data from one table (demand) and calculate total supply expected depending on the data from the other tables, here is example and...

Dear all, I have 2 fields, Eng and Math. I would like to set the parameter query for Eng and Math == Eng min, Eng max, Math min and Math max. The Eng query...

I have tried to follow many of the suggestions in other posts, but have not been able to get this to work. I have a table called DailyCalls and another table...

Hello, I am fairly new to Access and Excel. I am trying to write a formula/expression, but I think my problem is as simple as having the parenthese in the...

Hi all, Kindly solve my problem. I have a mdb file. tables created t1,t2,t3,t4. fields are almost same in all tables, but the data is different in all...

I have an inspection table to keep track of rooms in various buildings. These rooms are shared with different supervisors. One inspection of a location would...