Search results

Here is what I have: SELECT tblPSC.OrderNum, Min( tblPSC.Date) AS FirstOrder FROM tblPSC; GROUP BY tblPSC.OrderNum I got this error Msg "The LEVEL clause includes a reserved word or argument that is misspelled or missing, or the punctuation is incorrect"

I have a table that has a list of order information, there are multipule records per order that have information about when the order was processed. There is a day tied to the process time of each record, I need to filter out the duplicate records and get one record for an order, but that one...

Hey i want to search a string for Not Like in a query, I tried this: Not Like "*" & "total meds" & "*" but it just gave me all the records suggestions?

i imported it into access. do you have any suggestions on how to sort for the first record and the last record of the order? some orders have 3-5 records in them so it makes it hard to get a good time.

ok so im not sure how to explain this but ill give it my best shot. I have an excel sheet that has a list of order info. heres a sample of what it looks like: 701 44:37.0 Starting order split <34010993;01> gregory_pm 34010993 702 45:16.0 Script complete for <34010993;0106> Rx <24073318>...

I have a table of all the user logon IDs in it with the employee's name and infos. Is there a way to select a record out of a table by the logon ID and assign the employee's name to a variable/field? basicly i want to filter a table by the employee name after that.

that doesnt really show me how to compair currentuser with a table...

do you have quick example code of what the compareing currentuser() against a table would look like?

nm i found it, thanks

Im trying to make a PO database where people can enter, submit, and approve orders. I'm having trouble allowing a user to start a record and then return back to it when they want to finish it. How would you allow a user to look up an existing record so they can edit them?

I was wondering what a person would get payed for making databases with Access and Visual Basic all day? Anyone have a job doing that? If so how much do you make a year and how long have you been doing it? where do you live?

do you know how to make it so that if a user signs on and opens a form it shows his info in text boxes. I have a table with the currentuser(), name and bunch more info, how would create it so that it automaticly populated a form?

thank you sir

I have made some accounts with the user-level security wizard, and i was wondering is there a way to know who logs in? Im wanting to give a person preset information on forms and stuff.

Im using Access 2003. I have a form with a combo box that has a list of all the names that are contained in a table. I am trying allow the user to select a name but then when the user selects that name it pops up the email in another text box. The name that is being selected is in the same...