Search results

I have a table with the following fields and data: ID, DateFrom, DateTo, Qty 5, 1/1/08, 6/1/08, 3000 Can I convert the above to this: ID, ShipDate, Qty 5, 1/1/08, 3000 5, 2/1/08, 3000 5, 3/1/08, 3000 5, 4/1/08, 3000 5, 5/1/08, 3000 5, 6/1/08, 3000 Thanks!

I have a query with the following columns: ID, Customer, MthQty, BeginDate, EndDate, Jan,Feb,Mar....up to Dec If MthQty is 1000 and BeginDate is 1/1/08 and EndDate is 6/30/08, columns Jan to Jun will contain 1000. I need to run a query that will pull up sales for a particular month only...

I have a stock price database with the following fields: Code Date Close WAG 5/16/2008 $36.55 WAG 5/19/2008 $36.48 WAG 5/20/2008 $36.18 WAG 5/21/2008 $36.19 WAG 5/22/2008 $35.39 WB 5/16/2008 $27.65 WB 5/19/2008 $27.40 WB 5/20/2008 $27.20 WB 5/21/2008 $26.73 WB 5/22/2008 $25.49 WMT...

I am trying to link Access to an Excel sheet on the server and I only have Read access to the Excel file. When I open up the linked table, there are some #NUM! errors on a column with dates formatted as 6/1-6/30. Single dates like 6/1/08 have no errors. How can I solve this? Thanks.

I need help on a query. There are 3 columns in the table: Month, Company, Amount. I need to add the amount of every 2 months to find the highest 2 month average. Example: Date Company Amount 2-Month Jan 07 AAA $100 $100 Feb 07 AAA $200 $300 Mar 07 AAA...

I imported an large Excel file with a date column consisting of 3 different date formats and need help on a query to extract the number of days. Examples of the date on that column: 7/6/2006 7/1/06-7/31/06 7/1-7/5 Appreciate any advise.

I have a table with two columns; [Number] and [Amount]. On the report, I have 3 fields; [Number], [Amount1] & [Amount2]. [Amount1] is =IIf([Number] Like "[A-G]",[Amount],"") [Amount2] is =IIf([Number] Like "[H-Z]",[Amount],"") The details are coming up correctly but I am having an error...

I have the following line on my subform [frmFixedsubform] referring to the main form [frmFixed] and it is working fine. [Forms]![frmFixed]![FYE] I then put the main form to a tab control in a new form [frmDeal] and changed the syntax to the following but it didn’t work...

I encountered a Compile Error: Variable not Define on the following combobox and have no idea how to fix it. Private Sub cboFYE_AfterUpdate() On Error Resume Next cboBeginDate.RowSource = "Select tblBeginDate.BeginDate " & _ "FROM tblBeginDate " & _ "WHERE...

I would like to limit the selection of records in a combobox to the selected record in another combobox. For example if I select 2009-10 fiscal year in the main form, the combobox in the subform will limit the selection to only 07/09 thru 06/09. I have attached the sample db. Thanks for any...

I am getting an error message when clicking on a preview button to retreive a report for the record shown and can't figure out why. The code is Private Sub PrintPreview_Click() Dim strReportName As String Dim strCriteria As String strReportName = "rptSales" strCriteria = "[sales_id]=" &...

I have multiple subforms and would like advise on how to load only one on the main form via a combobox. I searched the forum but can't find any past solutions. Thanks.

I have a couple of checkboxes and would like it to perform calculations when checked. Is it possible?

I have a [Date] column and want to populate [FYE] column with the corresponding fiscal year end but can't make it work. Here is the code: FYE: IIf([Date]<7/1/2007,"2006-2007",IIf([Date]<7/1/2008,"2007-2008",IIf([Date]<7/1/2009,"2008-2009"))) Attached is the DB. Thanks!

I am trying to design a database to replace an Excel worksheet that I am currently using and need help to figure it out. Quite simple actually:) If I purchase an item with deliveries of 400 units per day starting from Jan-1 2008 thru Mar-31 2008, how can I auto populate the table with the...

I have a form with a working list box. But when I insert that form into a tab control form, clicking the reports on the list box will give an error message. Attached is the db. Appreciate any advise on how to solve it.

I have a table column with fixed data of "ABC-123" and need to add a zero to the number like "ABC-0123". How can I do it to all the data? Thanks.

I have a bunch of dates in my query and when I pull it up on a form I would like to see dates earlier than Dec 2006 strikethrough or bold. Can anyone help or point me to the right thread? Thanks.

I have qrData with AcctNo and Balance column and would like to pull certain AcctNo with their respective Balances in a report. I tried using Dlookup but failed. This is my code =Dlookup("Balance","qrData","AcctNo=1000") Or, should I even use Dlookup?? Thanks for any help.

My report is showing me an error on the total sum of "2.79396772384644E-08". I looked at the code and can't find whats wrong with it. Appreciate any advise.