Search results

What is the deal when a report prints out dates that are not in order, but thee dates are in order in the underlying query?

I have read through the issues that cause a query be unupdatable. My issue is that: The query contains a group by clause. I use this group by clause to show the records that need to be changed. Has anyone had a similar issue and how did you get around it?

If you want to run a query by pushing a button and a button to a form and go through the wizard. If you select Misc. there is a choice to run a query. Then it lets you select which query to run. If you want to run more then just right click the button you just made (while the form is in...

if you have all the junk specs somewhere in a table then run a query in the old database to get the right specs out and then import that.

use the nZ() function. There is a pretty good example on the Help in Access.

I have a field in a query that uses the Dsum() function. I want the field to be formatted in currency. I have set it to be currency on the properties but it does not change it to currency. Why is that and how do I fix it?

This might set you off on the right foot: you should go to Tools and then References in the VB editor and add the Excel Object. Then create a variable like dim variable as application set variable = (powerpoint.application) ~ I am not sure about that but it is something similar. Then you...

Is there a way to create a report, most likely using VB, to add all fields from a query into a report? Then add two groups to that report? (I don't want to use the wizard because the fields will change everynow and then in the underlying query) [This message has been edited by jesseb (edited...

I haven't been able to get that to work. I would really like to use the variable HOLD in a way like this: "Select ExcelImportUnits.[HOLD], ExcelImportUnits.SKU &_ "From ExcelImportUnitsForecast..." Can I use a VB variable in SQL like that?

I would like to have a query run using a variable in the select part of the SQL. The variable allows the query to be dynamic. Here is where my code is at so far: DoCmd.RunSQL "SELECT ExcelImportUnitsForecast.{put in variable}, [Price]*{variable name} AS Revenue" & _ "FROM...

I would have liked to do that. However this database is built off importing a spreadsheet from Excel first. In the spreadsheet are number of units sold with months essentially as fields. The price also changes with months in relation to the Company and SKU.

I am creating a database to track sales forecasting. I have one table that has Revenue. This table has fields for months. The fields are like this: SKU; Jan-02; Feb-02;... I would like to sum the all fields except SKU continually. So if I were to add another field it would be included...