I have a medical database containing (amongst others) a history of injury field (text), body region and attending dates. I have the following query that...

This is the current SQL query I have. It only displays Saturday and not Sunday. I need it to display both (SATURDAY and SUNDAY). SELECT format(date_1,...

Hello: On a form: Trying to display results of a query in a listbox. Textbox | Button | Listbox The textbox takes the criteria for a query. The button...

I am trying to group time information by year. I have a field containting seconds and have figured out how to show hours and minutes in the query but cannot...

Hi maurizio, I think your query will be a bit more complex. It will have to look something like: Select StudentID from STUDENTS where StudentID IN (Select...

Salve a tutti, qualcuno ha qualche idea su come eseguire una query e ordinare il risultato per il giorno? Mi spiego meglio: Ho una tabella contenente i giorni...

Hi, I actually copied over the database of previous yr to tis yr. So as i want to enter the data, the autonumber continues from the previous database. So...

For something like "10 and =20" how do I create an IIF statement?

I have to have the data transfered automatically in the fields. 1. Data in Field A= data in Field B* data in Field C/ 100.How to do this in the "Forms"? 2....

Hello :-) Im having a problem with and external libary from Intellicad that includes a function called Left. This is the same name as the Left function in...

What do I need to change so this query will not filter out duplicate records? I know there is an ALL function but I cannot get the syntax to work....

I need to find gaps in a series of time periods (ie 8-8:30am or 10-11:00am). I have a table with the Time Periods listed as well as a query with each...

Hi all! I have a database that show: Zone, Person, Days (and a few other things which are not important atm) Basically there are multiple people in the...

In publisher: I'm using a query (find unmatched query wizard) in access as the merge information for my publisher piece. There are more records in the merge...

I have a select query that I want to turn into a cross tab. The value I want to use is the average hours for the row and column heading (week and...

I have a query that was runing fine and still is. However, all of a sudden I can not get into the QBE view, I get the message "Query too complex". I still...

Hi there I have a text field with all different text like A1000 A1 A 1000 A 10 what i want to do is filter only the fields with A1000 ( letter + numbers...

I'm trying to set up a query that will give me a total of each item ordered by a store in a specific data range where if they ordered an item 5 different...

I have an access query where I use the Nz function. The function works fine on Access 2003 (ver 11.5614.5606) but on ver (11.6355.6408) I get a "function...

My Access 2000 database contains a field name . Data in this field is a varable number of characters to the left of an = sign and a variable number of...