Search results

not as long as COBOL though..... ;)

If it is a parameter query, use the following expression: Like "*" & [your parameter] & "*" If the parameter is left blank, all records will be returned.

Do you mean that you want to calculate the difference between successive readings of a counter on a machine? So if the morning reading is 100,the afternoon reading is 300 and the evening reading is 550, you want the query to return 100,200, 250? Please confirm.

How it's done... Create a query with an IIf expression. jfgambit's query is: SELECT tblHours.Date, tblHours.Associate, IIf(Sum([Hours])>10,"There are too many hours",Sum([Hours])) AS Hrs FROM tblHours GROUP BY tblHours.Date, tblHours.Associate; You may need to change the field names to...

Meet me halfway... How is your calculation derived? What do you want to display if the calculation results in a sum >10 hours?

don't think it's possible... it appears that this can't be done using a saved import spec. You can't even manually add an autonumber field to the spec as far as I can see. Strange, eh? It's easy enough to add the primary key manually after the import though, or use a simple procedure to add it...

Join the two tables on both fields that have to correspond. Do this using the query grid for ease. If you want to use SQL switch to SQL view and paste into your code.

I think your code would fail much sooner if it was a reference problem. I believe it is the SQL string that is causing the error. What does your debug statement return?

If you open the table's recordset, you can use a Filter by Selection command from the toolbar to show e.g. All users with last names beginning with S. You can toggle between the filtered records and the full recordset. Access remembers the filter, and if you use an ApplyFilter to the recordset...

To get you going and give you some experience, I suggest you do it this way to begin with. You can easily switch over to another method later without changing your table structure in any way. First, create a query to select all Baseball records from your table. Use the Query Wizard to select...

There are many ways to accomplish what you want, but most of them involve a knowledge of things like combo boxes or simple event procedures. As you are a "newbie", you may not feel comfortable with these. To do what you require in the simplest, though not most elegant way, requires two queries...

You have to base your form on a query which returns different records depending on which button (or better, which option in an option group) is selected. First , we need to know how your table differentiates whether an entry relates to soccer or baseball. Besides, why have the results lumped...

One way would be to have a command button on your main switchboard (assuming you have one). The OnClick of the button would call a module which you would imaginatively name as IMPORT. IMPORT would first delete the old data in your holding database, import the new data, then re-export it to your...

This is an extract from the help file for the Transferdatabase Action: "If you select Import in the Transfer Type argument and Table in the Object Type argument, Access creates a new table containing the data in the imported table. If you import a table or other object, Access adds a number to...

Put a message in square brackets in the criteria line of your query, something like: [Enter Yes for closed issues or No for open issues:] In design view, go to Menu item Query /Parameters and enter the same text in the parameter window and select Yes/No as Data Type. The query won't work as...

Create a query with the following Expression: IIf(IsNumeric(Mid([PC],2,1)),Mid([PC],1,1),Mid([PC],1,2)) Where PC is the name of your postcode field This goes in the Field Line of the query and is preceded by PC: or any chosen name. It will return the first character or the first two...

You could also use one parameter query which would prompt you to enter Yes or No and open the form with the appropriate records depending on your response.

You don't need a function. It can be done with an update query. Have you carefully considered the advice that Pat Hartman gave about not storing calculated values? If so, and you have determined that combining your two fields is the best scenario for you, drag the field to be updated into the...

Now that you have explained the matter in more detail, I can only agree with the last respondent. I thought you wanted a one-off way to merge two fields. And indeed, if the combination of county and store is unique and you use both fields for identification only, you could still merge them to...

Yes,you're probably right. I'm always having my shortcomings exposed - not a pretty sight at the best of times. It still requires the user to have an open form and possibly a command button to open the report, unless the AfterUpdate of the combo is used. Doing it this way simply requires you...