Could someone assist with the following query? In short, I want to see the count of updates per day, and a total, from 3 different tables. The query runs OK,...

I have a query with a date/time field. I'd like to write a criteria to only show records = 5:30pm for all dates in the dataset. I know this should be...

I'm trying to automate the running of 8 queries that append to 3 different existing tables (for example): qry1, qry2, qry3 appends to tbl1. qry4, qry5, qry6...

I want to have a criteria using the like condition on a field. For example the criteria Like . & "*" is under the field hier_cd. The query works, but only...

I have a form where I would like the "Quarter" entered automaticly when the date is entered into the OTDLdaTE text box. Currently it has to be enter...

I have 2 tables: 1 is Main stock code and the other is Main historical the primary key is stock code. I create a combo box in a form where the user can...

Hi, Pls help: I have 2 tables: 1 is Main Stock. The other is Main Historical. After creating a query list based on a particular stock name. I could like to...

In an Athletics program (built in Access) I have created a report (based on a query) that shows the number, name, sex and race time of each athlete. On that...

I have a crosstab query and I would like to know how to add a grand total at the bottom for the three columns I have. Here is my SQL code: SELECT...

I have a query (see SQL below) that connects 2 tables: Contacts and Orgs. Each table has the field Organization in it. That field is the linking field...

I'm trying to sequence claims in a table. Claims can have any number of service lines, so the claim number is not unique. I want the claims labled Claim 1,...

I have a query which pulls records based on = criteria. I have changed to read "=DateValue()" but the results are still not correct. When entering 4/1/07...

I'm still new to Access, so please bear with me. I am trying to create a report from a query so that I can pull information about a particular employee. I...

I'm not sure if this question should be in the query section or maybe module coding. I have a table (tbl_cost) that has two fields CC and Cost. I want to...

I ran across a curious situation that someone who knew what they were doing would probably be able to solve without even thinking about it. I have to track...

I have a field called CONTACT that has both a name and phone number as text. I need to separate this into two fields, NAME and PHONE. How do I display just...

I am getting an error when running a query with StDev in Access. Most rows have a good calc value, but 2 rows have an #Error value. When I try to sort by the...

I have field [inv_no and is numbered from 1 to 999999. I would like the numbers to be from 000001 to 999999 (all fields with six numbers). Any suggestions?...

I have follow steps by steps instructions under the "Use Parameters in queries and reports" to create a parameter collector so that the query table will...

I have a query linked to a subreport that may have null entries based on which individual's data is pulled. What I would like is to display the subreport...