I pass a date paramter criteria to my query. using following 2 methods. The first one pass from form and subform which does not return recoerds, but second...

I am trying to figure out if there is a way to sort a field in a table by just the year, when the field in the table is formatted mm/dd/yyyy? I want to be able...

Hi All, I have a query with a date field that is from a table where the date is looked up from another table. I am trying to enter a Between and criteria...

Is it possible to make the destination table name variable (prompted entry) for a Make-Table Query?

I have a simple count query that I would like to put a zero for a null value for the count and also indicate the group that was counted. following is the...

I have a Query. One field is an expression called ID. I want that field to return the value that is not zero unless all three fields are 0, otherwise it...

Thanks in advance for your responses. I am creating one report with several columns that pull data from 2 different tables and are based on different date...

I am working on a mail merge. My fields in question are lookup fields, When I do the mail merge, the number shows instead of the actual name. My lookup is...

I have a table that has task start and end dates. I have a query built to group by the end date by week ending (group everything with and end date from Sat...

I'm having a problem coding this subquery... Not quite sure where to place the EXISTS. Any help appreciated. Thanks DS SELECT tblCheckDetails.CDBizDay FROM...

Materials: Concatenate("SELECT Material FROM tblPKPKMSsMaterials WHERE txtProfileID =""" & & """ ORDER BY Material") How can I squeeze into this? For...

I have some linked table data from our server DB, that I need to run a few times a month, where one of the pulled data columns gives me a column of...

I have a table that lists rows of effective dated codes against IDs as such: ID DATE CODE 1 2008 A 1 2007 B 2 2007 A 3 2007 C 4 2008 B 4 2008 A

I want to build a SQL statement that only returns the last row of data (defined by "SEQ") if the ID and DATE match. Here is my sample data: ID DATE SEQ 1...

I have a dummy database with numerous tables. For one of the tables, tblDepartments (pks HospID and CostCtr), I want to import data from an Excel...

How can effectivly use NZ for the following two expressions? If I live some record without a date in, I am getting error messages. CalenDays:...

I am trying to remove superflous programs on my computer. I have no need for Chinese Characters. I don't think that I need Microsoft GB18030 support...

In an Access DB ( Access 2K3) I have the following querie that work perfectly except I would like paramerterize the # so if i want the top 25 then I imput 25...

I want to query a DateSerial field called TestsDue (syntax shown below) as follows: =Date()-7 and =Date()+30 (i.e., all records that are "due" by today...

I am modifying a query where I need to provide the user with a "From" and a "To" date input boxes, then run the query based on those two dates as filter...