Search results for query: *

I have a report based on a query where: WHERE (((tblSchedule.[Cheque Date]) Between [Enter start cheque date] And [Enter end cheque date]) AND ((tblSchedule.Decision)=[Enter Decision A or R (Approvals/Refusals)])) I would like the event procedure to display a report named "rptPrimaryCategory"...

Hi there, I have a report based on a query where: WHERE (((tblSchedule.[Cheque Date]) Between [Enter start cheque date] And [Enter end cheque date]) AND ((tblSchedule.Decision)=[Enter Decision A or R (Approvals/Refusals)])) I would like the event procedure to display a report named...

I don't know if you need this, but the form's On Current is: Private Sub Form_Current() Me![txtDocInv] = DLookup("[SumofInvoice Amount]", "[qryInvoicedTD]", "[Docket #]=" & Me![Docket #]) Me![txtEstimate] = DLookup("[SumofTotal]", "[qryEstimates]", "[Docket]=" & Me![Docket #]) End Sub I'm...

Can someone please tell me why my records aren't sorting in ascending order? 02/09/2005 appears after 02/16/2005. Here is my SQL - the report is grouped by "Date Range" - each value - group interval 1. SELECT [SchedDate] & " - " & [EventEnd] AS [Date Range], tblSchedule.StartTime...

Hi, Is there an easy way to run a report by week (7-days)in calendar format? I want to display the weekday with the corresponding information i.e., [event name] below it. In my SQL below, how can you list "WhatDay" for each weekday for the month/year requested with the event information below...

Is it possible to make a macro to change the default setting for the built-in Find/Next method from "Match: Whole Field" to "Match: Any part of Field"? Thank you.

Can you help me fix a form button? My On_Click is below. I am trying to run a report based on the information in the displayed record. i.e., with record 3368 displayed, I receive the message: syntax error in date in query expression '(Docket #=3368'. Note that the report worked when I had the...

Currently, my report prompts the user to enter the Docket number to select records. What do I need to change so the user can click a button to preview a report based on the currently displayed record on the form? (skip the WHERE below) Here's my query: SELECT tblEstimates.Date...

I am trying to display a calculation in a form - here is the On Current I have so far: Private Sub Form_Current() [txtDocInv] = DLookup("[InvoicedToDate]", "[qryInvoicedTD]", _ " & [Docket #]) End Sub [InvoicedToDate] is a calculation in a separate query (not connected to the form)...

Hi! I am creating a report based on a query - here is the SQL so far: Note: [Docket #] = [PRNumber] (same number) SELECT [Project Expenses Table].[Docket #], [Project Expenses Table].[Invoice ID], [Project Expenses Table].[Invoice Date], [Project Expenses Table].[Invoice Amount], [Project...

In an Access form, what is the easiest way to link a field that only displays a description (text) of the number that is punched in? that ALSO allows data entry of numbers that may not match what is in the description table. [Project Request Table].[Network number] is the form field that allows...

I am preparing a report based on a query. I would like the user to enter the invoice number so I have [Enter invoice number] in the criteria for that field. There are four digits in the invoice number, however some have extensions such as "####.1" and I would like to include them in the report...