hello there, I have been spining my brains for quite some time on this one. I want a simple cross tab query. following is a defination of my source data Main...

Hi , Please any body, can tell me List of database and table Properties , that has been given by Oracle, that all user can access ........ under which table...

SELECT ! & " " & ! & " (" & ! & ")" AS FullName, Sum(T.Score) AS Ranking, tPlayers.PlayerID FROM LeagueRoundsPlayed, ___PlayerRankings AS T INNER JOIN...

Hi All, In a database i'm developing i am using someone else's SQL tables for some of the core data. However the join fields in these are different...

Hello, Is it possible to trace what ADO exactly does with an MS Access database (Jet 4.0 Ole Db Provider) ? Thanks Best regards

I have a form with a text box and button and want to run an Access query that takes an input parameter. I have the following code for the button: I get an...

I've been able to take the house # and Street type and put them into their proper fields. The street name (being anything in between the first and last " " of...

I have a query that has many fields that I am running reports off of. I have it suming one of the fields (Defects) when (Action Required) = true. The...

Getting the above error message on just one of 4 PCs on a small LAN. the database works just fine an all 3 others. this unit is a laptop that has not been...

Maybe it's a typo but Value2 is missing a leading double quote. -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "John"...

I'm getting tripped up by some missing data and desperately need help. I start with one data table, tblTransactions, that has fields and . Each record...

I need to update data from Table 1 to Table 2 via an Append Query. The Query would find the same record from Table 1 and replace it in Table 2. Also it...

I am trying to create a Make-Table Query using the design grid that will have 2 fields named BillProvName and AllowedAmt that come from a table named Gyn...

it has been stated in this forum by knowledgeable people that the jet engine can pull select data based on indexes from tables across the network. Could...

Hi, I've a lot of student IDs and i want to use count function to count how many times a specific student number occurs. If there's other smart ways you know...

I'm trying to write a query that will delete customer records from the Customer table (tblCustomers) if they have no related records in the Bookings table...

Whenever I run my query and there is no data for a specific month the crosstab will skip that month and show the next that contains data (for example if...

I have a table that shows all orders placed by the company. I would like to create a query to only show products purchased from multiple vendors. my fields...

Hello All, I've been waiting for a response to my query for over 30 mins... I'm attempting to run an append or make-table query for roughly 800,000 rows of...

Hello! I'm trying to creating a running sum in an access query. I'm showing the invoice value as one column (called Tot_Amt) and a running sum of that bill...