I am trying to display everything on a query through a report, but when i include some fields, then there is no data showing. here is the query that i have,...

Hi all: I have a SELECT query I'm having problems with (returns the error message "you tried to execute a query that does not include the specified expression...

I am getting an invalid syntax error when I apply the * wildcard character to the follow criteria in a query. Like !! Can someone help me with what I am...

I have two queries that work exactly the way I want them to. The difference between the two is that one query looks for a value of 1 in FloatTable.Val,...

I have a large table listing agent name and premium bound on each new customer. I am trying to find the top selling agent, which is hard to find, but I only...

Hello. I've been designing in Access for quite a while, but I write very little SQL. What is the method of returning a note that is associated with most...

I've been fiddling with this for a couple days now but can't get it: SELECT tblProfiles.txtProfileID, Concatenate("SELECT ProfilesAssociations FROM...

Hello All Please assist. I need to create a crosstab query that will count patient visits between 2 dates in the table. dates: report rundate - visit...

My concatenation code is returning: "Invalid SQL statement. Expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. Can anyone see the problem in my...

I am creating a "Round Robin" form (an interactive form that lets users specify the parameters of a report to be run). Currently the drop down list to choose...

I work for a Fortune 50 company. We upgraded to Access 2003 approximately 1 year ago. We are now upgrading our ODBC drivers. The new driver is Informix 3.82....

I run around 100 excel reports with data from sql queries every month. The process for each report is fairly simple: I first run a saved sql query to get...

Hi everybody I have a query which has will group the majors in the university, group the city the students are from and count each gender (female or male) I...

I want to get a count of the number of records where the field equals "Face to Face" and the field is blank I've tried this in a text box on the...

I am trying to setup a very basic report with a Query from the Order Entry database template. I am trying to get my report to show a gross total for each...

Ok, i'm stumped.... This works: SELECT TRANSDATE, B.TRANDESC, A.CARDID, D.FIRSTNAME, D.LASTNAME FROM (CARDTRANSHISTORY AS A LEFT JOIN TRANSACTIONCODES AS B...

I have two tables. The first is tblPeriod which lists months including start and end dates. It also has an AllocatedNo field which gives every month a...

Hello, I have a small test table called 'Flavors'. It has 2 fields: Field 1: 'FlavorID' and Field 2: 'Flavor'. In the 'Flavor' field I have different flavors...

I've got a report I've built for a customer that runs a query that has 2 parameters which requires the user to input a start date and an end date. The query...

Can someone please help me design an expression in expression builder that included "equal or grater than". The example is the query design has a field called...