Hi, I'm trying to do a simple calculation of the number of weekdays between two dates. This what I have in my query, but it's not working. Seems so...

Hello, I am doing an inner join query. Typically, you would match up the ID's and away you go. I have a query that is a little different. I now have to...

Hello, I have a query that has a parameter that you need to enter. I can call the query from the command line with this line of code. Can I somehow make it...

Hi, Is there a way to run a query from a command line and have the parameter included in the command line? In other words, I want to open the query with my...

Hello, I'm trying to use an "OR" in this iif statement and it's not working. Can somebody please help? My goal is: if ProductResultBDHC contains C or P,...

Hi there, I have a query that does: - and it gives me a number of days. This works, but I want it exclude Saturday and Sundays. Is there a way to do...

Hello, I have the following criteria in a query. It will find anything with the letter "H" in it and it works. Like "*H*" I want it to be a a prompt...

I am attempting to combine a 2 digit month (ex. 05) with a 4 digit year (ex. 2007). I need it to be a single 4 digit number (ex. 0507). thanks.

Good afternoon, I'm having troubles with a query I'm workiong on. I have three tables for a patient recvoery database: Admission Table, Discharge Table,...

I am in the process of testing a database upsized to SQL Express 2005 (originally created through jet/local mdb). The data is comprised a couple dozen...

I am working on a query for one of my reports. It takes a percentage of selected diagnoses (and some diagnosis groups). To save the number of queries, I...

Hey Guys, I want to create tables through ADO that have the exact same fields that are in an existing table in my access 2003 .mdb file. I don't want to copy...

I am using access to query an Oracle DB... my query is as follows SELECT a.DEFECT_ID, b.STATION_NO, b.CODE, b.DEFECT_STATUS, b.PO FROM a INNER JOIN b ON...

I currently have run a series of queries that basically take a final item and break it down by its components over and over again.. i end up with columns...

I have 5 tables which were set up across rather than down - ie fields are Jan04,Feb04...Sept04,Oct04...Jan05,Feb05...Aug05,Sept05 I currently have a...

First of all I realize that this is an extra long post and I'm guessing a challenging one, too. I would be willing to offer compensation to anyone who is...

First of all I realize that this is an extra long post and I'm guessing a challenging one, too. A gracious thank you in advance for taking the time to read,...

Hello, I first off want to say thank you to all those who post on this site. I am not very experienced in Access and the advice and direction offered here...

need to run a make table query that adds a few new numeric fields to a table. used statement "New field:", but gives me binary.

need to import Excel spreadsheet with text fields and return back to Excel numeric field without adjusting the table structure (user interface is only through...